Microsoft Designing and Implementing Cloud Data Platform Solutions - 070-473 FREE EXAM DUMPS QUESTIONS & ANSWERS
You have a Microsoft Azure SQL database.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to ensure that you can use the Always Encrypted feature for the database.
Which two components should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine named VM1. VM1 is provisioned by using the classic deployment model and is on the Standard GS5 service tier.
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should you use?
The virtual machine is used for testing purposes only.
You need to minimize the costs associated with VM1 when the virtual machine is unused.
Which command should you use?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have a Microsoft Azure SQL database.
You discover that the workload grows over time.
You are evaluating whether to switch to a higher service tier for the database.
You need to examine the system utilization trends over time.
Which dynamic management view should you query?
You discover that the workload grows over time.
You are evaluating whether to switch to a higher service tier for the database.
You need to examine the system utilization trends over time.
Which dynamic management view should you query?
Correct Answer: B
Vote an answer
You have a Microsoft Azure SQL data warehouse.
During peak usage, you discover that the data warehouse fails to meet performance expectations.
You need to provide additional resources to the data warehouse.
What should you do?
During peak usage, you discover that the data warehouse fails to meet performance expectations.
You need to provide additional resources to the data warehouse.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have 10 Microsoft Azure SQL databases.
One of the databases is named DB1.
You need to ensure that only a specific IP address can be used to access DB1. The solution must affect only DB1.
What should you use?
One of the databases is named DB1.
You need to ensure that only a specific IP address can be used to access DB1. The solution must affect only DB1.
What should you use?
Correct Answer: B
Vote an answer
You have an application named App1 that connects to a Microsoft Azure SQL database named AppDB1.
App1 uses columnstore indexes as part of the database schema.
You plan to deploy another Azure SQL database named AppDBDev that will be used as the development environment for Appl.
You create a copy of AppDBl for AppDBDev.
You need to identify which service tier must be used to store AppDBDev. The solution must minimize the cost to store AppDBDev.
Which service tier should you identify?
App1 uses columnstore indexes as part of the database schema.
You plan to deploy another Azure SQL database named AppDBDev that will be used as the development environment for Appl.
You create a copy of AppDBl for AppDBDev.
You need to identify which service tier must be used to store AppDBDev. The solution must minimize the cost to store AppDBDev.
Which service tier should you identify?
Correct Answer: A
Vote an answer
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 tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
You need to tell the research project leaders how to migrate their databases.
Which task should you instruct the leaders to use from SQL Server Management Studio?
Correct Answer: B
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
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 ensure that the performance statistics for the research department are collected. What should you enable?
You need to ensure that the performance statistics for the research department are collected. What should you enable?
Correct Answer: D
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have a failover cluster deployed to Microsoft Azure virtual machines.
You plan to deploy a new Microsoft SQL instance to the cluster. The instance will host one database that has
10 file groups.
You provision 10 disks for the instance.
You need to recommend a storage solution that always provides the fastest possible reads for the database.
What should you include in the recommendation?
You plan to deploy a new Microsoft SQL instance to the cluster. The instance will host one database that has
10 file groups.
You provision 10 disks for the instance.
You need to recommend a storage solution that always provides the fastest possible reads for the database.
What should you include in the recommendation?
Correct Answer: C
Vote an answer
Your environment contains several Microsoft Azure SQL databases.
You need to execute Transact-SQL-based maintenance steps automatically against the databases.
The execution must occur weekly.
What should you use?
You need to execute Transact-SQL-based maintenance steps automatically against the databases.
The execution must occur weekly.
What should you use?
Correct Answer: C
Vote an answer
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?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You need to implement a solution to meet the technical requirements for the encryption of the data in Appl.
Which two features should you enable? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point
Which two features should you enable? Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point
Correct Answer: B,C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You need to implement the monitoring solution for the Listings database.
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.
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
Topic 1, ADatumCorporationOverview
General Overview
ADatumCorporation is a real estate firm that has offices throughout North America.
ADatumhas a main office and four branch offices. The main office is located in Seattle. The branch offices are located in New York, Montreal, Denver, and Vancouver.
Existing Environment
Network Infrastructure
The network contains one Active Directory domain namedADatum.com. Each office contains one domain controller.
Each office has a 100-Mbps connection to the Internet that is 20 percent saturated on average. The offices connect to each other through the Internet by using VPN appliances.
ADatumuses the public IP addresses shown in the following table.
SQL Server Infrastructure
In the main office,ADatumhosts a Microsoft SQL Server instance on a server named SQL1. SQL1 has a
400-GB database named Listings. Log-shipped copies of Listings are present in each branch office. The copies are used for reporting. Currently, all of the SQL Server instances run SQL Server 2014 Enterprise edition.
Each branch office has an application server that hosts an application named App1. App1 is configured to connect to the Listings database on each local SQL Server instance for reporting and to connect to the SQL Server instance in the main office for any updates to property listings.
The main office also has an application server that hosts App1. The application server connects to the local Listings database for reporting and for any updates to the property listings.
Historic activity of the Listings database shows a maximum of 475 concurrent requests from as many as 200 concurrent connections.
User Issues
Users report that, frequently, they are disconnected from the Listings database when they run reports. Users also report that there is an unacceptable delay between when a property listing is updated and when the updated listing appears in the listings reports.
Developers report concerns about the lack of a testing environment in which code changes can be validated before being deployed to the production Listings database.
Requirements
Business Requirements
ADatumidentifies the following business requirements:
Planned changes
ADatumplans to implement the following changes:
Technical Requirements
ADatumidentifies the following technical requirements:
High-Availability and Recovery Requirements
ADatumidentifies the following high-availability and recovery requirements:
You manage a large Microsoft Azure SQL database. The database contains data that changes several thousand times each day.
You need to ensure that the performance of the database stays consistent when the data changes.
What should you do?
You need to ensure that the performance of the database stays consistent when the data changes.
What should you do?
Correct Answer: C
Vote an answer
You are designing the database for a new application. The application will have 7,500 users located in New York and 2,500 users located in Paris. Users of the application will load large amounts of data into a database in their region.
You need to recommend an architecture that will minimize latency while data is loaded.
What are two possible architectures that achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
You need to recommend an architecture that will minimize latency while data is loaded.
What are two possible architectures that achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
Correct Answer: C,E
Vote an answer