070-473 無料問題集「Microsoft Designing and Implementing Cloud Data Platform Solutions」
You have a Microsoft Azure SQL database named Database1.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
You need to implement the Always Encrypted feature for Database1.
In which sequence should you execute the code blocks? To answer, move all the code blocks from the list of code blocks to the answer area and arrange them in the correct order.
正解：
Explanation
Your company registers the domain name of contoso.com.
You plan to deploy two web servers, two application servers, and two Microsoft SQL server instances on Microsoft Azure virtual machines. All of the virtual machines will be located on the same Azure virtual network. The SQL Server instances will be in an AlwaysOn availability group.
You need to ensure that the web servers and the application servers can access the availability group listener by using a fully qualified domain name (FQDN) from the contoso.com domain.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to deploy two web servers, two application servers, and two Microsoft SQL server instances on Microsoft Azure virtual machines. All of the virtual machines will be located on the same Azure virtual network. The SQL Server instances will be in an AlwaysOn availability group.
You need to ensure that the web servers and the application servers can access the availability group listener by using a fully qualified domain name (FQDN) from the contoso.com domain.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：D、E、F
解答を投票する
Your company has several Microsoft SQL Server databases that are hosted on Microsoft Azure virtual machines. You plan to protect the data in the databases. The company employs several developers who implement changes to the databases. An application named App1 accesses the databases. App1 uses the Entity Framework and does not use any stored procedures.
An application named App2 accesses the databases. App2 uses the SQL Server 2008 R2 driver. App2 only accesses the names of customers that are stored in the databases.
You need to configure the databases to meet the following security requirements:
Prevent the developers from viewing the customer's names
Prevent unauthorized users from restoring a backup of any database
Prevent system administrators from viewing the customers' credit card numbers that are stored in the databases.
What should you implement to meet each security requirement? To answer, drag the appropriate technologies to the correct security requirements. Each technology 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.
NOTE: Each correct selection is worth one point.
An application named App2 accesses the databases. App2 uses the SQL Server 2008 R2 driver. App2 only accesses the names of customers that are stored in the databases.
You need to configure the databases to meet the following security requirements:
Prevent the developers from viewing the customer's names
Prevent unauthorized users from restoring a backup of any database
Prevent system administrators from viewing the customers' credit card numbers that are stored in the databases.
What should you implement to meet each security requirement? To answer, drag the appropriate technologies to the correct security requirements. Each technology 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.
NOTE: Each correct selection is worth one point.
正解：
Explanation
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
Your organization contains several Microsoft Azure SQL databases.
You need to ensure that an administrator is notified when SQL injection is detected on one of the databases.
Which two features should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to ensure that an administrator is notified when SQL injection is detected on one of the databases.
Which two features should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
正解：C、E
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
You are evaluating the migration of the databases from Host1 and WebData1 to Azure.
You need to recommend the most cost-effective solution for storing the database in Azure. The solution must meet the business requirements.
In the table below, recommend the most cost-effective storage solution for Host1 and WebData1. NOTE:
Make only one selection in each column.
You need to recommend the most cost-effective solution for storing the database in Azure. The solution must meet the business requirements.
In the table below, recommend the most cost-effective storage solution for Host1 and WebData1. NOTE:
Make only one selection in each column.
正解：
Explanation
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 evaluating whether to replace CRM-B with an Azure virtual machine.
You need to identify the required virtual machine service tier to replace CRM-. The solution must meet the following requirements:
Which virtual machine service tier should you identify?
You need to identify the required virtual machine service tier to replace CRM-. The solution must meet the following requirements:
Which virtual machine service tier should you identify?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)