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

DRAG DROP
You have a SQL Azure database named Database1. You need to design the schema for a table named table1.
Table1 will have less than one million rows. Table1 will contain the following information for each row:

The solution must minimize the amount of space used to store each row. Which data types should you recommend for each column? To answer, drag the appropriate data type to the correct column in the answer area.

正解：

You need to prepare the database to use the .NET Framework ProcessProducts component.
Which code segments should you execute? (Each correct answer presents part of the solution. Choose all that apply.)

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

You need to recommend a solution for Application1 that meets the security requirements. What should you include in the recommendation?

• A.Signed stored procedures
• B.Certificate Authentication
• C.Secure Socket Layer (SSL)
• D.Encrypted columns

You need to implement a solution that addresses the index monitoring requirements.
What should you do?

• A.Schedule a SQL Server Profiler trace, and then save the trace data to a table in the database.
• B.Create a SQL Server Audit that saves data to a log file, and then create a SQL Server Audit Specification that gathers data from the DATABASE_OPERATION group.
• C.Create a performance monitor Data Collector Set (DCS) that monitors the SQL Server counters.
• D.Schedule a SQL Server Agent job that saves data from the dynamic management views to a table in the database.

You need to recommend a change to USP_3 to ensure that the procedure completes only if all of the UPDATE statements complete.
Which change should you recommend?

• A.Set the IMPLICIT_TRANSACTIONS option to on.
• B.Set the IMPLICIT_TRANSACTIONS option to off.
• C.Set the XACT_ABORT option to off
• D.Set the XACT_ABORT option to on.