Online Access Free 070-459 Exam Questions

You need to write code that will allow the sales force to retrieve data for their reports with the least amount of effort.
Which code should you use?

• A.Option A
• B.Option C
• C.Option D
• D.Option B

You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?

• A.the index on the ProductName column
• B.the collation of the ProductName column
• C.the data type of the ProductName column
• D.the collation of the Products table

You execute the following code:

You create a nonclustered index named IXCustomerName on the CustomerName column. You execute the following query:

You need to reduce the amount of time it takes to execute the query.
What should you do?

• A.Replace LEFT(CustomerName ,1) = 'a' with SUBSTRING(CustomerName ,1,1) - 'a'.
• B.Replace LEFT(CustomerName ,1) = 'a' with CustomerName LIKE 'a%'.
• C.Replace IX_CustomerName with a clustered index.
• D.Partition the table and use the CustomerName column for the partition scheme.

You need to recommend a disk monitoring solution that meets the business requirements.
What should you include in the recommendation?

• A.an audit
• B.a maintenance plan
• C.a dynamic management view
• D.a SQL Server Agent alert

Which data type should you use for CustomerID?

• A.nvarchar(11)
• B.bigint
• C.varchar(11)
• D.char(11)