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

質問 1

You plan to design an application that temporarily stores data in a SQL Azure database.
You need to identify which types of database objects can be used to store data for the application. The solution must ensure that the application can make changes to the schema of a temporary object during a session.
Which type of objects should you identify?

（A）Common table expressions (CTEs)

（B）Temporary stored procedures

（C）Temporary tables

（D）Table variables

正解：C 解答を投票する

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

質問 2

You are troubleshooting an application that runs a query. The application frequently causes
deadlocks.
You need to identify which transaction causes the deadlock.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.

（A）Query the sys.dm_exec_requests dynamic management view.

（B）Query the sys.dm_exec_sessions dynamic management view.

（C）Create a trace in SQL Server Profiler that contains the Deadlock graph event.

（D）Create an extended events session to capture deadlock information.

正解：D 解答を投票する

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

質問 3

You need to add a new column named Confirmed to the Employees table. The solution must meet the following requirements:
- Have a default value of TRUE.- Minimize the amount of disk space used.
Which code segment should you use?

（A）ALTER TABLE Employees
ADD Confirmed bit DEFAULT 0;

（B）ALTER TABLE Employees
ADD Confirmed char(1) DEFAULT "1";

（C）ALTER TABLE Employees
ADD Confirmed char(1) DEFAULT '0';

（D）ALTER TABLE Employees
ADD Confirmed bit DEFAULT 1;

正解：D 解答を投票する

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

質問 4

You run the following code:

You need to ensure that the root node of the XML data stored in the Details column is <Order_Details>.
What should you implement?
More than one answer choice may achieve the goal. Select the BEST answer.

（A）A Data Definition Language (DDL) trigger

（B）An XML schema collection

（C）A data manipulation language (DML) trigger

（D）A user-defined data type

（E）An XML index

正解：B 解答を投票する

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

質問 5

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.

正解：

質問 6

You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table. The following is the relevant portion of the script. (Line numbers are included for reference only.)

You need to ensure that the view can update the data in the table, except for the data in Columnl.
Which code segment should you add at line 06?

（A）WITH VIEW_METADATA

（B）WITH CHECK OPTION

（C）WITH SCHEMABINDING

（D）WITH ENCRYPTION

正解：B 解答を投票する

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

質問 7

You have a database hosted on SQL Server 2012 R2. The database contains 5 million rows.
You need to recommend a repeatable method to migrate the database to SQL Database.
Which method should you recommend?
More than one answer choice may achieve the goal. Select the BEST answer.

（A）Extract a data-tier application, and then import the application.

（B）Create a SQL Server Integration Services (SSIS) package, and then run the package.

（C）Back up the database, and then restore the database.

（D）Generate scripts to create all of the all database objects and all of the data, and then execute the scripts by using SQL Azure.

正解：B 解答を投票する

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

質問 8

You need to provide referential integrity between the Offices table and Employees table.
Which code segment or segments should you add at line 27 of Tables.sql? (Each correct answer presents part of the solution. Choose all that apply.)

（A）Option D

（B）Option B

（C）Option C

（D）Option A

正解：A、C 解答を投票する

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

質問 9

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 D

（B）Option B

（C）Option C

（D）Option A

正解：C 解答を投票する

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

質問 10

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

（A）Option E

（B）Option D

（C）Option B

（D）Option C

（E）Option A

（F）Option F

正解：A、B、D、E 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験