70-469 試験問題を無料オンラインアクセス

You have a Microsoft SQL Azure database that contains a table named Customers.
You have a table-valued function named TopCustomers that returns a list of all the customers that have purchased items during the last 12 months. The ID of the customer is passed as an argument to the TopCustomers function.
You need to create a query that returns a list of all the Customer names and the purchase dates.
The solution must return only customers that have purchased an item during the last 12 months.
What should you add to the query?

• A.CROSS APPLY
• B.CROSS JOIN
• C.OUTER APPLY
• D.OUTER JOIN

You need to optimize the index structure that is used by the tables that support the fraud detection services.
What should you do?

• A.Add a not hash clustered index on POSTransactionId and CreateDate.
• B.Add a not hash nonclustered index to CreateDate.
• C.Add a hashed clustered index on POSTransactionId and CreateDate.
• D.Add a hashed nonclustered index to CreateDate.

DRAG DROP
You administer a SQL Server 2014 instance.
You have been assigned to determine the cause of frequent long-running transactions that
have been tracked to the dbo.Account table, where there are many cases of blocking and deadlocks. The dbo.Account table contains more than one million rows.
Users and processes frequently search for and update data by using the AccountId column, and less frequently the AccountNumber and GovernmentId columns, all of which contain only unique values. Users frequently get lists of AccountNumber values by searching on Last Name and then First Name.
You need to modify the structure of the dbo.Account table to alleviate the issues.
How should you complete the table definition to reduce contention on the table structure? To answer, drag the appropriate code snippets to the correct locations in the CREATE TABLE statement. Each code snippet may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

正解：

You need to modify the usp_DetectSuspiciousActivity stored procedure.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

• A.Option D
• B.Option C
• C.Option B
• D.Option A
• E.Option E
• F.Option F

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

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