070-473試験無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions 認定」
Your company's data center contains three Microsoft SQL Server databases named DB1, DB2, and DB3.
You plan to migrate the databases to Microsoft Azure.
You need to provision the recourses in Azure to meet the following requirements.
* DB1 must be able to execute CLR assemblies.
* DB2 must be able to run SQL Server Agent jobs.
Which database solution should you use for each database? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You plan to migrate the databases to Microsoft Azure.
You need to provision the recourses in Azure to meet the following requirements.
* DB1 must be able to execute CLR assemblies.
* DB2 must be able to run SQL Server Agent jobs.
Which database solution should you use for each database? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation
You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template.
You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual machine. The web app and the virtual machine will be on the same Azure virtual network.
You need to ensure that the web app can access the SQL Server database.
Which three actions should you perform? Each correct answer presents part of the solution.
You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual machine. The web app and the virtual machine will be on the same Azure virtual network.
You need to ensure that the web app can access the SQL Server database.
Which three actions should you perform? Each correct answer presents part of the solution.
正解：B,C,E
解答を投票する
Your company has a Microsoft SQL Server database hosted on a Microsoft Azure virtual machine. You create several reports that display data from the database.
Users report that the reports are slow to display data.
You create an index.
You need to identify whether the performance of the reports significantly improves.
Which tool should you use?
Users report that the reports are slow to display data.
You create an index.
You need to identify whether the performance of the reports significantly improves.
Which tool should you use?
正解：A
解答を投票する
You are provisioning a virtual machine in Microsoft Azure to host a Microsoft SQL Server database named DB1.
The tempdb database on the SQL server is not expected to grow to more than 20 GB during the next five years.
You add a 1-TB disk to the virtual machine and configure the disk as drive F.
The disk is not configured for read or write caching.
You need to reduce the amount of time required to read data from DB1 and tempdb.
On which drive should you place each database? To answer, select the appropriate options in the answer area.
The tempdb database on the SQL server is not expected to grow to more than 20 GB during the next five years.
You add a 1-TB disk to the virtual machine and configure the disk as drive F.
The disk is not configured for read or write caching.
You need to reduce the amount of time required to read data from DB1 and tempdb.
On which drive should you place each database? To answer, select the appropriate options in the answer area.
正解：
Explanation
Your company has a Microsoft Azure SQL database that is hosted in the West US region and uses the S1 performance level.
You need to ensure that the database is available as quickly as possible if the database is deleted accidentally.
The solution must minimize data loss.
What should you implement for the database?
You need to ensure that the database is available as quickly as possible if the database is deleted accidentally.
The solution must minimize data loss.
What should you implement for the database?
正解：D
解答を投票する
You have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine.
The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections.
You need to identify whether the performance issues are related to the connection pooling.
Which dynamic management view should you query?
The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections.
You need to identify whether the performance issues are related to the connection pooling.
Which dynamic management view should you query?
正解：A
解答を投票する
解説: (GoShiken メンバーにのみ表示されます)