070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the az sql db create command from Azure Cloud Shell.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the az sql db create command from Azure Cloud Shell.
Does this meet the goal?
正解：B
解答を投票する
You need to implement a storage architecture for the Azure virtual machines that will host the OLTP database.
The solution must meet the business goals and the technical requirements.
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.
The solution must meet the business goals and the technical requirements.
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
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the Add-AzureRmSqlDatabase cmdlet from PowerShell.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a Microsoft Azure tenant.
You need to provision a new Azure Database for MySQL server database in the tenant.
Solution: You run the Add-AzureRmSqlDatabase cmdlet from PowerShell.
Does this meet the goal?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
Your environment contains a Microsoft Azure virtual machine and an Azure SQL database. The virtual machine has Microsoft SQL Server installed and contains several applications. You need to recommend a solution to migrate one of the applications to the Azure SQL database. The solution must minimize downtime.
Which solution should you recommend?
Which solution should you recommend?
正解：A
解答を投票する
You have a database named DB1 hosted on Microsoft Azure Database for MySQL servers. DB1 contains two tables named table1 and table2. Several web servers access DB1.
You create a login named Login1 to access the database from any web server.
You need to ensure that Login1 can read the tables in DB1.
The solution must ensure that Login1 can read all the tables created in the future.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You create a login named Login1 to access the database from any web server.
You need to ensure that Login1 can read the tables in DB1.
The solution must ensure that Login1 can read all the tables created in the future.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation
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
You plan to deploy a data platform solution for 4 TB of data. The solution will be used to generate analytic reports during business hours only. All reports will be generated by using Microsoft Excel.
You need to recommend a data platform for the data. The solution must minimize costs and provide the highest possible read performance.
Which data platform should you recommend?
You need to recommend a data platform for the data. The solution must minimize costs and provide the highest possible read performance.
Which data platform should you recommend?
正解：A
解答を投票する