Microsoft 70-473 Exam Practice Questions (P. 2)
- Full Access (26 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #6
DRAG DROP -
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.
Select and Place:

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.
Select and Place:

Correct Answer:
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-monitoring-with-dmvs/

References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-monitoring-with-dmvs/
send
light_mode
delete
Question #7
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:
Database files and backup files must be encrypted always.
The encryption strategy must minimize changes to the databases and to applications.
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.
Select and Place:

You have an AlwaysOn availability group between several Microsoft Azure virtual machines.
You need to ensure that the databases meet the following requirements:
Database files and backup files must be encrypted always.
The encryption strategy must minimize changes to the databases and to applications.
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.
Select and Place:

Correct Answer:
References:
https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/28/how-to-enable-tde-encryption-on-a-database-in-an-availability-group/

References:
https://blogs.msdn.microsoft.com/alwaysonpro/2014/01/28/how-to-enable-tde-encryption-on-a-database-in-an-availability-group/
send
light_mode
delete
Question #8
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.
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.
- AChange the SQL Server authentication to mixed mode.
- BUse sp_configure to enable remote access.
- CFrom the Azure portal, add an endpoint for TCP port 1434.
- DOnthe virtual machine, enable the inbound connections on TCP port 1433 from Windows Firewall.
- ERestart the SQL Server service.
Correct Answer:
BDE
BDE
send
light_mode
delete
Question #9
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?
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?
- AMove the tempdb data files to drive D.
- BMove the tempdb data files to drive C.
- CChange the servicetier of the virtual machine to Standard D12.
- DChange the service tier of the virtual machine to Standard DS3.
Correct Answer:
A
A
send
light_mode
delete
Question #10
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?
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?
- ADatabase Engine Tuning Advisor
- BIndex Tuning Wizard
- CAzure Throughput Analyzer
- DAzureSQL Database Index Advisor
Correct Answer:
D
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/
D
References:
https://azure.microsoft.com/en-gb/documentation/articles/sql-database-advisor/
send
light_mode
delete
All Pages