070-473 무료 덤프문제 온라인 액세스

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.

정답:

Explanation

You have a Microsoft Azure virtual machine named SQL1 that has Microsoft SQL Server 2016 installed.
SQL1 has a critical database that contains online transaction data. The database is 700 GB.
You regularly perform full database backups.
On a separate Azure virtual machine, you run a test restore procedure of the database and discover that restoring the database takes longer than expected.
You need to reduce the amount of time required to restore the database.
What should you do?

• A.Modify the backup solution to use differential database backups.
• B.Partition the tables in the database, and then modify the backup solution to use incremental backups.
• C.Create multiple filegroups in the database, and then modify the backup solution to use filegroup backups.
• D.Modify the backup solution to use transaction log backups.

Your organization contains several Microsoft Azure SQL databases.
You need to ensure that an administrator is notified when SQL injection is detected on one of the databases.
Which two features should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Auditing
• B.Query Performance Insight
• C.Azure Resource Health
• D.Management Data Warehouse
• E.Threat detection

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.

정답:

Explanation

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

You need to identity which service tier to use for the research department databases. The solution must meet the business goals and the department requirements.
What should you identify?

• A.an Azure virtual machine on the Standard service tier
• B.an Azure SQL database on the Standard service tier
• C.an Azure SQL database on the Premium service tier
• D.an Azure virtual machine on the Basic service tier
• E.an Azure SQL database on the Basic service tier