Microsoft 70-473 Designing and Implementing Cloud Data Platform Solutions Online Training
Microsoft 70-473 Online Training
The questions for 70-473 were last updated at Nov 20,2024.
- Exam Code: 70-473
- Exam Name: Designing and Implementing Cloud Data Platform Solutions
- Certification Provider: Microsoft
- Latest update: Nov 20,2024
You have a Microsoft Azure SQL database that is used for reporting.
You discover that some reports complete more quickly than other reports, even though the reports retrieve approximately the same amount of data and use queries that have the same table structure.
You need to reduce the amount of time it takes to complete the reports.
What should you use?
- A . Index Tuning Wizard
- B . Database Engine Tuning Advisor
- C . Azure Throughput Analyzer
- D . Azure SQL Database Index Advisor
You plan to implement a Microsoft Azure SQL database.
You need to create and manage the new database on a new server.
Which three cmdlets should you use? Each correct answer presents part of the solution.
- A . New-AzureSqlDatabaseServer
- B . New AzureSqlDatabaseServerFirewallRule
- C . New-AzureSqlDatabaseServerContext
- D . New-AzureVM
- E . New-AzureSqlDatabase
DRAG DROP
You have four Microsoft Azure SQL databases located on the same database server. You need to configure the databases to be in an elastic database pool.
Which four 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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You have a Microsoft Azure SQL database. The database is hosted in the West US region and uses the Premium service tier. Users of the database are located in Los Angeles, New York, and Singapore.
The users in Singapore report that when they run reports against the database, the reports take a long time to complete. The reports contain thousands of rows.
You need to recommend a solution to resolve the performance issue. The solution must maintain the performance for the other users.
What should you include in the recommendation?
- A . Move the Azure SQL database from the West US region to the East Asia region.
- B . Implement Azure ExpressRoute for the subscription.
- C . Configure a readable geo-replica in the East Asia region.
- D . Configure pagination for the report.
You have an on-premises Microsoft SQL Server 2014 database in an AlwaysOn availability group. You are planning a backup solution for the database. Backups will run on a secondary replica. You need to create a backup procedure for the database. The solution must ensure that the
backups are stored on-premises and in Microsoft Azure Blob storage.
Which two actions should you perform? Each correct answer presents part of the solution.
- A . Run the BACKUP DATABASE statement and use the TO DISK clause.
- B . Run the CREATE DATABASE statement and use the AS COPY OF clause.
- C . Run the BACKUP DATABASE statement and use the TO URL clause.
- D . Run the BACKUP DATABASE statement and use the MIRROR clause.
Latest 70-473 Dumps Valid Version with 162 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
