070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」
You have Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application.
Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application.
Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.
正解：A、E
解答を投票する
You plan to implement row-level security for the CWDB database.
You create the fn_limitusers function under the restriction schema.
You need to create the policy.
How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
You create the fn_limitusers function under the restriction schema.
You need to create the policy.
How should you complete the policy? To answer, drag the appropriate elements to the correct locations. Each element may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
正解：
Explanation
References:
https://msdn.microsoft.com/en-us/library/dn765131.aspx
You have an Azure SQL Database elastic database pool that contains two databases named database1 and database2.
Users of database1 report poor performance during peak business hours.
You discover that database2 consumes most of the available resources.
You need to resolve the performance issue.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
Users of database1 report poor performance during peak business hours.
You discover that database2 consumes most of the available resources.
You need to resolve the performance issue.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
正解：C、D
解答を投票する
A customer plans to monitor the performance of a Microsoft Azure SQL database.
You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DTU) percentage. Which three metrics should you identify? Each correct answer presents part of the solution.
You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DTU) percentage. Which three metrics should you identify? Each correct answer presents part of the solution.
正解：C、D、F
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You have an on-premises database hosted on a Microsoft SQL Server instance.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You plan to back up the database to Microsoft Azure.
You create a storage account in Azure for the backups.
You need to back up the database to Azure. The solution must ensure that the backups are encrypted before they are sent to Azure.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
正解：
Explanation
A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You are evaluating the use of active geo-replication for one of the research department databases.
You need to identify which service tier to use for the database. The solution must meet the department requirements and the business requirements.
What should you identify?
You are evaluating the use of active geo-replication for one of the research department databases.
You need to identify which service tier to use for the database. The solution must meet the department requirements and the business requirements.
What should you identify?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are designing a hybrid data analytics solution that contains an on-premises Microsoft SQL Server environment and a Microsoft Azure SQL data warehouse.
You need to load data warehouse from the SQL Server environment as quickly as possible.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You need to load data warehouse from the SQL Server environment as quickly as possible.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
正解：
Explanation
