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

You discover that the usp_GetOrdersAndItems stored procedure takes a long time to complete while usp_AddOrder or usp_AddXMLOrder run.
You need to ensure that usp_GetOrdersAndItems completes as quickly as possible.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

• A.Execute the ALTER DATABASE Sales SET ALLOW_SNAPSHOT_ISOLATION OFF statement.
• B.Set the isolation level of the usp_AddOrder stored procedure to SERIALIZABLE.
• C.Set the isolation level of the usp_GetOrdersAndItems stored procedure to SERIALIZABLE.
• D.Set the isolation level of the usp_GetOrdersAndItems stored procedure to SNAPSHOT.
• E.Set the isolation level of the usp_AddOrder stored procedure to SNAPSHOT.
• F.Execute the ALTER DATABASE Sales SET ALLOW_SNAPSHOT_ISOLATION ON statement.

You have a database for a mission-critical web application. The database is stored on a SQL Server 2012 instance and is the only database on the instance.
The application generates all T-SQL statements dynamically and does not use stored procedures.
You need to maximize the amount of memory available for data caching.
Which advanced server option should you modify?

• A.Optimize for Ad hoc Workloads
• B.Scan for Startup Procs
• C.Allow Triggers to Fire Others
• D.Enable Contained Databases

You have a Microsoft SQL Azure database named DBAzure1.
You create a table in DBAzure1 by using the following script:

You need to recommend a solution to ensure that each combination of CustomerContact and CustomerDetails is not duplicated.
What should you recommend creating?

• A.A filtered index
• B.A UNIQUE constraint
• C.A CHECK constraint
• D.A columnstore index

You execute the following code:

You discover that the Customers table was created in the dbo schema.
You need to create a code segment to move the table to another schema named Schema2.
What should you create?
To answer, drag the appropriate code segments to the correct location in the answer area. (Answer choices may be used once, more than once, or not at all.)

正解：

Explanation:
http://msdn.microsoft.com/en-us/library/ms173423.aspx

You are creating a stored procedure named usp1. Usp1 will create a table that will be used during the execution of usp1. Only usp1 will be allowed to access the table.
You need to write the code required to create the table for usp1. The solution must minimize the need to recompile the stored procedure.
Which code segment should you use to create the table?

• A.CREATE TABLE oneTable
• B.DECLARE oneTable TABLE
• C.CREATE TABLE ##oneTable
• D.CREATE TABLE #oneTable