070-459試験無料問題集（114題）「Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform 認定」

出題：1

You need to recommend a solution that addresses the index fragmentation and index width issue.
What should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)
What should you include in the recommendation? (Each correct answer presents part of the solution. Choose all that apply.)

A. Change the data type of the modifiedBy column to tinyint.

B. Change the data type of the id column to bigint.

C. Change the data type of the lastModified column to smalldatetime.

D. Remove the lastModified column from the clustered index.

E. Remove the modifiedBy column from the clustered index.

F. Remove the id column from the clustered index.

正解：D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

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 (Column1) INCLUDE (Column2)

B. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NOT NULL

C. CREATE INDEX IX_Table1 ON Table1 (Column2) WHERE Column2 IS NULL

D. CREATE INDEX IX_Table1 ON Table1 (Column2) WITH FILLFACTOR=0

正解：B 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：3

You need to recommend a solution to synchronize Database2 to App1_Db1. What should you recommend?

A. Snapshot replication

B. Master Data Services

C. Transactional replication

D. Change data capture

正解：C 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

You need to recommend a solution for the planned changes to the customer classifications.
What should you recommend? (Each correct answer presents part of the solution. Choose all that apply.)

A. Add columns for each classification to the Customers table.

B. Add a table to track any changes made to the classification of each customer.

C. Add a column to the Classifications table to track the status of each classification.

D. Add a row to the Customers table each time a classification changes.

E. Implement change data capture.

正解：B,C 解答を投票する

出題：5

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 (KEEP PLAN)

D. OPTION (OPTIMIZE FOR UNKNOWN)

正解：D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

You are creating a database that will store usernames and passwords for an application.
You need to recommend a solution to store the passwords in the database.
What should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

A. One-way encryption

B. Transparent Data Encryption (TDE)

C. Reversible encryption

D. Encrypting File System (EFS)

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

You are creating a table to support an application that will cache data outside of SQL
Server.
The application will detect whether cached values were changed before it updates the
values.
You need to create the table, and then verify that you can insert a row into the table. Which code segment should you use?

A. Option D

B. Option C

C. Option A

D. Option B

正解：A 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：8

You need to recommend a solution to improve the performance of usp_UpdateInventory. The solution must minimize the amount of development effort.
What should you include in the recommendation?

A. a subquery

B. a common table expression

C. a table variable

D. a cursor

正解：B 解答を投票する

出題：9

You administer an instance of SQL Server 2014.
You are tasked with tuning a common set of queries. You have the results of several test executions, along with query plans. The schema and the data for all database object(s) used remain unchanged between executions. The QueryTime column is defined as a computed column that uses the GETDATEO system function. The query plans and results are shown below:

You need to make an initial diagnosis of the situation, based solely on this input.
Which two statements can you make about the performance characteristics of this query? Each correct answer presents a complete solution. Choose two.

A. The object Account is a table, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.

B. The queries would perform worse if the index named AccountNumber included the NameColumn.

C. The object Account is a view, joining the Account-AccountNumber and Account.PKAccount objects together.

D. The queries would perform better if the index named AccountNumber included the Name and QueryTime column.

E. The queries would perform better if the index named AccountNumber included the Name column.

F. The object Account is an indexed view, with an index having a leading column of AccountNumber and a Clustered Index named PKAccount.

正解：A,B 解答を投票する

出題：10

You need to implement a backup strategy to support the requirements.
Which two actions should you perform? Each correct answer presents part of the solution. Choose two.

A. Schedule a full backup by using the command BACKUP DATABASE ProdDB TO SHARE ... WITH CREDENTIAL=N' MyCredential'

B. Create a credential called MyCredential on SQL Server, using MyStorageAccount for the storage account name and StorageAccountKey for the access key.

C. Schedule a full backup by using the command BACKUP DATABASE ProdDB TO DISK...

D. Create a share on the hot standby site and grant permission to the SQL Server service login.

E. Create a share on your Windows Azure site by using your Windows Azure storage account information, and grant permission to the SQL Server service login.

F. Create a credential called MyCredential on SQL Server by using a Windows domain account and password.

G. Schedule a full backup by using the command BACKUP DATABASE ProdDB TO URL ... WTTH CREDENTIAL=N'MyCredential'

正解：E,G 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

070-459試験無料問題集「Microsoft Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform 認定」