Microsoft 070-473 Actual Free Exam Questions & Community Discussion
You plan to migrate a 150-GB on-premises database to a Microsoft Azure virtual machine.
The domains in your network are untrusted. The network has 1.5 Mbps of available bandwidth. You need to migrate the data to the Azure virtual machine as quickly as possible.
What should you use?
The domains in your network are untrusted. The network has 1.5 Mbps of available bandwidth. You need to migrate the data to the Azure virtual machine as quickly as possible.
What should you use?
Correct Answer: C
Vote an answer
Your company's data center contains two databases named DB1 and DB2.
DB1 contains 500 MB of data. DB2 contains 400 GB of data that is read-only. Both databases contain sensitive data.
Each database regularly has more than 1,000 concurrent connections.
You need to migrate the databases to Microsoft Azure SQL Database. The solution must minimize costs.
Which tier and service level should you choose for each database? To answer, select the appropriate options in the answer area.
DB1 contains 500 MB of data. DB2 contains 400 GB of data that is read-only. Both databases contain sensitive data.
Each database regularly has more than 1,000 concurrent connections.
You need to migrate the databases to Microsoft Azure SQL Database. The solution must minimize costs.
Which tier and service level should you choose for each database? To answer, select the appropriate options in the answer area.
Correct Answer:
Explanation
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-dtu-resource-limits-single-databases#single-dat
Your environment contains a Microsoft Azure machine that has Microsoft SQL Server Standard installed.
An application named App1 uses the data stored in SQL server. The Service level Agreement (SLA) for App1 states that the application can lose a maximum of 10 minutes of data and that the data must be available if two Azure regions fail.
You need to implement a solution that provides disaster recovery for App1.
In two other Azure regions, you deploy an Azure virtual machine that has SQL Server installed.
What should you implement next?
An application named App1 uses the data stored in SQL server. The Service level Agreement (SLA) for App1 states that the application can lose a maximum of 10 minutes of data and that the data must be available if two Azure regions fail.
You need to implement a solution that provides disaster recovery for App1.
In two other Azure regions, you deploy an Azure virtual machine that has SQL Server installed.
What should you implement next?
Correct Answer: D
Vote an answer
You implement Microsoft Azure ExpressRoute.
You need to ensure that if the ExpressRoute connection is unavailable, you can manage the resources in Azure over a secure connection.
Which two actions should perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to ensure that if the ExpressRoute connection is unavailable, you can manage the resources in Azure over a secure connection.
Which two actions should perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: B,E
Vote an answer
A marketing department manager reports that the marketing department database contains incorrect data. The manager reports that the data was correct yesterday.
You need to recommend a method to recover the data.
Which three actions should you recommend be performed 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 need to recommend a method to recover the data.
Which three actions should you recommend be performed in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
Explanation
Your company has a data warehouse that contains a database named DB1.
You plan to implement data encryption for DB1.
You need to configure DB1 to meet the following requirements:
* Prevent the system administrators of App1 from reading the Personally Identifiable Information (PII) stored in DB1.
* Ensue that all backups are Stored in an on-premises local drive for three days.
* Ensure that all backups are stored in a remote location for 10 days.
* Encrypt all backups.
All solution must support the ODBC Driver for Microsoft SQL Server 2012.
Which two solutions should you implement for DB1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to implement data encryption for DB1.
You need to configure DB1 to meet the following requirements:
* Prevent the system administrators of App1 from reading the Personally Identifiable Information (PII) stored in DB1.
* Ensue that all backups are Stored in an on-premises local drive for three days.
* Ensure that all backups are stored in a remote location for 10 days.
* Encrypt all backups.
All solution must support the ODBC Driver for Microsoft SQL Server 2012.
Which two solutions should you implement for DB1? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: B,C
Vote an answer
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.
Correct Answer:
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 need to recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer presents part of the solution.
You need to recommend an auditing solution that meets the business goals.
Which three events should you include in the recommendation? Each correct answer presents part of the solution.
Correct Answer: A,C,E
Vote an answer
0
0
0
10