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
DRAG DROP
You have an AlwaysOn availability group between several Microsoft Azure virtual machines. You need to ensure that the databases meet the following requirements:
The solution must prevent any disruption to replication.
Which four actions should you perform in sequence? I answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.
You deploy a Microsoft SQL Server instance on a Microsoft Azure virtual machine by using a template.
You plan to deploy a PHP-based app in an Azure web app. The web app will use a database on the virtual machine. The web app and the virtual machine will be on the same Azure virtual network.
You need to ensure that the web app can access the SQL Server database.
Which three actions should you perform? Each correct answer presents part of the solution.
- A . Change the SQL Server authentication to mixed mode.
- B . Use sp_configure to enable remote access.
- C . From the Azure portal, add an endpoint for TCP port 1434.
- D . On the virtual machine, enable the inbound connections on TCP port 1433 from Windows Firewall.
- E . Restart the SQL Server service.
You have Microsoft SQL Server installed on a Microsoft Azure virtual machine. The virtual machine is on the Standard D3 service tier. All of the data files for the databases on the virtual machine are located on a single volume that is mounted as drive E.
The virtual machine experiences performance issues.
You view the wait statistics and discover a high number of GEIOLATCH_SH waits associated to the tempdb data files. You need to resolve the performance issues.
What should you do?
- A . Move the tempdb data files to drive D.
- B . Move the tempdb data files to drive C.
- C . Change the service tier of the virtual machine to Standard D12.
- D . Change the service tier of the virtual machine to Standard DS3.
You have a report that runs against a Microsoft Azure SQL database. The report takes more time to return results than expected. You add an index to a table in the database. You need to identify whether adding the index improves the performance issue.
What should you use?
- A . Database Engine Tuning Advisor
- B . Index Tuning Wizard
- C . Azure Throughput Analyzer
- D . Azure SQL Database Index Advisor
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?
- A . Update-AzureVM
- B . Stop-AzureVM
- C . Suspend-VM
- D . Stop-VM
You have several SQL Server instances on Microsoft Azure virtual machines. Periodically, one of the virtual machines runs more slowly than expected. The issue typically
persists for up to 30 minutes. You investigate the issue and discover that when the issue occurs, there is high CPU usage on the virtual machines.
You need to be notified automatically when the performance issue occurs. You want to achieve this goal by using the minimum amount of administrative effort.
What should you configure?
- A . extended events to monitor the Processor:%Privileged Time of the virtual machine and SQL Server Agent alerts to notify the operator by sending an email message
- B . Azure Diagnostics for the logs on the virtual machine and a rule in Management Services to send you an email message when the CPU usage is more than 80 percent
- C . extended events to monitor the Processor:%User Time of the virtual machine and SQL Server Agent alerts to notify the operator by sending an email message
- D . an alert rule in the Azure portal to send you an email message when the CPU usage is more than 80 percent for five consecutive minutes
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
DRAG DROP
You have several instances of Microsoft SQL Server on several Microsoft Azure virtual machines.
You need to implement an automated process to back up all of the virtual machines to an Azure storage account. The process must run weekly.
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 have an application that uses a Microsoft SQL Server database on a Microsoft Azure virtual machine.
The application experiences performance issues, which you suspect are related to the connection pooling. The issues are prevalent only when there are more than 150 concurrent connections.
You need to identify whether the performance issues are related to the connection pooling.
Which dynamic management view should you query?
- A . sys.dm_os_memory_pools
- B . sys.dm_exec_requests
- C . sys.dm_exec_connections
- D . sys.dm_exec_sessions
A customer plans to monitor the performance of a Microsoft Azure SQL database.
You need to explain to the customer which metrics are used to calculate the Database Throughput Unit (DTU) percentage.
Which three metrics should you identify? Each correct answer presents part of the solution.
- A . Log IO percentage
- B . Data IO percentage
- C . CPU percentage
- D . Blocked by firewall
- E . Database size percentage
- F . Total database size
Latest 70-473 Dumps Valid Version with 162 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
