最新的 Microsoft SQL Server 2012 70-459 免費考試真題:

1. You have a SQL Azure database.
You execute the following script:

You add 1 million rows to Table1. Approximately 85 percent of all the rows have a null value for Column2.
You plan to deploy an application that will search Column2.
You need to create an index on Table1 to support the planned deployment. The solution must minimize the storage requirements.
Which code segment should you execute?

A) CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NULL
B) CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NOT NULL
C) CREATE INDEX IX_Table1 ON Table1 (Column1) INCLUDE (Column2)
D) CREATE INDEX IX_Table1 ON Table1 (Column2) WITH FILLFACTOR=0

2. You need to create the object used by the parameter of usp_UpdateEmployeeName. Which code segment should you use?

A) CREATE XML SCHEMA COLLECTION EmployeesInfo
B) CREATE TYPE EmployeesInfo AS Table
C) CREATE SCHEMA EmployeesInfo
D) CREATE TABLE EmployeesInfo

3. You execute usp_SelectEmployeesByName multiple times, passing strings of varying lengths to @LastName.
You discover that usp_SelectEmployeesByName uses inefficient execution plans.
You need to update usp_SelectEmployeesByName to ensure that the most efficient execution plan is used.
What should you add at line 31 of StoredProcedures.sql?

A) OPTION (ROBUST plan)
B) OPTION (KEEPFIXED PLAN)
C) OPTION (OPTIMIZE FOR UNKNOWN)
D) OPTION (KEEP PLAN)

4. You need to recommend a solution to ensure that USP_4 adheres to the security requirements.
What should you include in the recommendation?

A) Enable trace flags.
B) Enable C2 audit tracing.
C) Configure data manipulation language (DML) triggers.
D) Enable SQL Server Audit.

5. An administrator provides a digital certificate named ServerCert.
You need to implement Transparent Data Encryption (TDE) on ProductsDB.
Which code segment should you use?

A) Option B
B) Option D
C) Option C
D) Option A

問題與答案：