070-465 無料問題集「Microsoft Designing Database Solutions for Microsoft SQL Server」
DRAG DROP
You plan to deploy three highly available SQL Server environments that will use SQL Server 2014.
You identify the following specifications for each environment as shown following table.
You need to recommend which high-availability feature is required for each environment. Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.
You plan to deploy three highly available SQL Server environments that will use SQL Server 2014.
You identify the following specifications for each environment as shown following table.
You need to recommend which high-availability feature is required for each environment. Which features should you identify?
To answer, drag the appropriate feature to the correct requirement in the answer area.
正解：
HOTSPOT
You use SQL Server 2014. You create a table within a database by using the following
DDL:
The following table illustrates a representative sample of data:
The system is expected to handle 50 million orders a month over the next five years.
You have been instructed by your Team Lead to follow best practices for storage and performance in the utilization of SPARSE columns.
Which columns should you designate as SPARSE? To answer, mark each column as SPARSE or NOT SPARSE in the answer area.
You use SQL Server 2014. You create a table within a database by using the following
DDL:
The following table illustrates a representative sample of data:
The system is expected to handle 50 million orders a month over the next five years.
You have been instructed by your Team Lead to follow best practices for storage and performance in the utilization of SPARSE columns.
Which columns should you designate as SPARSE? To answer, mark each column as SPARSE or NOT SPARSE in the answer area.
正解：
You have a database named DB1.
You plan to create a stored procedure that will insert rows into three different tables. Each insert must use the same identifying value for each table, but the value must increase from one invocation of the stored procedure to the next.
Occasionally, the identifying value must be reset to its initial value.
You need to design a mechanism to hold the identifying values for the stored procedure to use.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.
You plan to create a stored procedure that will insert rows into three different tables. Each insert must use the same identifying value for each table, but the value must increase from one invocation of the stored procedure to the next.
Occasionally, the identifying value must be reset to its initial value.
You need to design a mechanism to hold the identifying values for the stored procedure to use.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You deploy a SQL Server instance named SQLProd that uses SQL Server 2014.
You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The solution must minimize the amount of custom code required. What should you recommend?
You need to recommend a solution to monitor the transactions that are running currently against SQLProd. The solution must minimize the amount of custom code required. What should you recommend?
正解：C
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
DRAG DROP
You need to recommend the actions that are required to partition a table.
In which order should the four actions be performed?
To answer, move the actions from the list of actions to the answer area and arrange them
in the correct order.
You need to recommend the actions that are required to partition a table.
In which order should the four actions be performed?
To answer, move the actions from the list of actions to the answer area and arrange them
in the correct order.
正解：
You have a SQL Server 2014 environment that includes four servers. The servers are configured as shown in the following table.
You plan to configure Policy-Based Management to enforce the following rules:
- On Server1, enable SQL Server password policies and enable the default trace. - On Server3, ensure that the names of user-defined stored procedures begin with the prefix "usp_" and ensure that all databases use a case-sensitive collation.
You need to recommend which server you must configure as a Central Management Server.
Which server should you recommend? (Each correct answer presents a complete solution. Choose all that apply.)
You plan to configure Policy-Based Management to enforce the following rules:
- On Server1, enable SQL Server password policies and enable the default trace. - On Server3, ensure that the names of user-defined stored procedures begin with the prefix "usp_" and ensure that all databases use a case-sensitive collation.
You need to recommend which server you must configure as a Central Management Server.
Which server should you recommend? (Each correct answer presents a complete solution. Choose all that apply.)
正解：A、B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)