Designing and Implementing Cloud Data Platform Solutions 온라인 연습
최종 업데이트 시간: 2024년11월08일
당신은 온라인 연습 문제를 통해 Microsoft 70-473 시험지식에 대해 자신이 어떻게 알고 있는지 파악한 후 시험 참가 신청 여부를 결정할 수 있다.
시험을 100% 합격하고 시험 준비 시간을 35% 절약하기를 바라며 70-473 덤프 (최신 실제 시험 문제)를 사용 선택하여 현재 최신 162개의 시험 문제와 답을 포함하십시오.
/ 5
Question No : 1
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.
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?
정답:
Question No : 3
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 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.
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?
정답:
Question No : 6
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.
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?
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 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.
정답:
Question No : 10
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?
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?
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?
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?
정답:
Question No : 14
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.
정답:
Question No : 15
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.
