Proper study guides for 70-473 Designing and Implementing Cloud Data Platform Solutions certified begins with preparation products which designed to deliver the by making you pass the 70-473 test at your first time. Try the free right now.
Online 70-473 free questions and answers of New Version:
NEW QUESTION 1
You need to recommend a disaster recovery solution for the CRM application that meets the business requirements.
What should you recommend?
- A. backup and restore by using Windows Azure Storage
- B. log shipping
- C. AlwaysOn Availability Groups
- D. database mirroring
Answer: A
NEW QUESTION 2
You have a Microsoft SQL Server instance that is hosted on a Microsoft Azure virtual machine.
You need to identify the most recent wait type for all of the currently running queries in the instance. What should you use?
- A. the sp_who2 stored procedure
- B. the sys.syscacheobjects view
- C. the sys.dm_exec_requests view
- D. the sys.dm_exec_connections view
Answer: C
Explanation: References:
https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-requ
NEW QUESTION 3
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 CREATE DB command from the mysql command prompt. Does this meet the goal?
- A. Yes
- B. No
Answer: A
Explanation: References:
https://docs.microsoft.com/en-us/azure/mysql/quickstart-create-mysql-server-database-using-azure-portal
NEW QUESTION 4
You need to export a Microsoft Azure SQL database named DB1from a server named Server1. The credentials to connect to Server1 are stored in a variable named Credential.
The backup of the database must be stored in a storage account named Storage1 in a container named container1.
Which commands should you run in an Azure PowerShell script? To answer, drag the appropriate values to the correct targets. Each value 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 are point.
Answer:
Explanation: 
NEW QUESTION 5
You need to configure auditing to meet 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.
Answer:
Explanation: References:
http://solutioncenter.apexsql.com/how-to-setup-and-use-sql-server-audit-feature/
NEW QUESTION 6
You hire a new employee to assist in the management of a Microsoft Azure SQL database. You need to ensure that the employee can query dynamic management views.
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.
Answer:
Explanation: References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-monitoring-with-dmvs/
NEW QUESTION 7
HOTSPOT
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.
Answer:
Explanation: 
NEW QUESTION 8
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.
Answer:
Explanation: 
NEW QUESTION 9
DRAG DROP
Your company has a Microsoft Azure subscription that contains 20 Azure SQL databases on a single Microsoft SQL Server.
You need to ensure that you can aggregate results from the databases in a single query.
Which five components should you create in sequence? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation: References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-query-horizontal-partitioning
NEW QUESTION 10
You need to recommend a solution to implement high availability for the Listings database.
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.
Answer:
Explanation: 
NEW QUESTION 11
You need to provision a new Microsoft Azure Database for PostgreSQL server database.
Which two actions should you perform to create the database? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. From Azure Cloud Shell, run the az sql db create command.
- B. From the PostgreSQL command prompt run the create database command.
- C. From PowerShelUun the New-object cmdlet.
- D. From the PostgreSQL command prompt, run the CREATEdb command.
- E. From PowerShell, run the New-AzureRMsqlDatabase cmdlet
Answer: BD
NEW QUESTION 12
You plan to deploy a Microsoft Azure SQL database named DB1 to support a new application named Appl. You need to recommend a solution for DB1 that meets the following requirements if a single region fails:
• DB1 must remain available.
• App1 must reconnect automatically.
What should you recommend implementing to meet each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation: References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview
NEW QUESTION 13
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?
- A. Active Geo-Replication
- B. database mirroring
- C. BACPAC exports
- D. log shipping
Answer: A
NEW QUESTION 14
You have Microsoft SQL Server 2014 installed on a Microsoft Azure virtual machine.
One of the databases on the virtual machine supports a highly active Online Transaction Processing (OLTP) application.
Users report abnormally long wait times when they submit data in the application.
Which two tools can you use to identify the longest running queries? Each correct answer presents a complete solution.
- A. the Job Activity Monitor
- B. Database Engine Tuning Advisor
- C. dynamic management views
- D. SQL Server Extended Events
- E. SQL metrics in Azure Diagnostics for the virtual machine
Answer: CD
NEW QUESTION 15
You have a Microsoft Azure SQL database named DB1 on a logical server named Serverl48923034.database.windows.net. You need to restore DB1 to another database named DB2 on the same server.
Which Azure PowerShell command should you run first? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation: 
NEW QUESTION 16
You have a hybrid Microsoft SQL Server environment that has multiple servers and services that run in both Microsoft Azure and on-premises.
If the network fails, you need to ensure that users can authenticate and connect to the resources available in Azure.
Which two server roles should you deploy to Azure? Each correct answer presents part of the solution.
- A. Active Directory Federation Services
- B. Active Directory Certificate Services
- C. DHCP Server
- D. Active Directory Domain Services
- E. DNS Server
Answer: AD
NEW QUESTION 17
You establish a site-to-site VPN to Microsoft Azure.
You need to implement a high-availability solution for the data warehouse. The solution must meet the business goals and the technical requirements.
Which two actions should you perform? Each correct answer presents part of the solution.
- A. Configure the databases to be in Full recovery model.
- B. Create an AlwaysOn availability group between SQL03 and SQL04.
- C. Implement iSCSI storage.
- D. Migrate SQL03 to an Azure virtual machine and configure an AlwaysOn availability group
Answer: AB
Thanks for reading the newest 70-473 exam dumps! We recommend you to try the PREMIUM Surepassexam 70-473 dumps in VCE and PDF here: https://www.surepassexam.com/70-473-exam-dumps.html (136 Q&As Dumps)