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

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 URL clause.
• B.Run the BACKUP DATABASE statement and use the MIRROR clause.
• C.Run the BACKUP DATABASE statement and use the TO DISK clause.
• D.Run the CREATE DATABASE statement and use the AS COPY OF clause.

You plan to create a database named DB1.
You need to ensure that all the data in DB1 is encrypted when the database is at rest.
Which four actions should you perform in sequence after you create DB1? 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://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=

You have a Microsoft SQL Server instance that is hosted on a Microsoft Azure virtual machine.
You need to identify the most recent wait type for all of the currently running queries in the instance.
What should you use?

• A.the sys.dm_exec_connections view
• B.the sp_who2 stored procedure
• C.the sys.dm_exec_requests view
• D.the sys.syscacheobjects view

A solution for the data warehouse system must be created to provide disaster recovery between SQL03 and an Azure virtual machine named SQL04.
You are designing the data warehouse.
You need to recommend a solution that meets the business goals and the technical requirements.
What should you recommend?

• A.Create an AlwaysOn availability group between SQL03 and SQL04.
• B.Create an Azure DocumentDB database.
• C.Host the data warehouse on an Azure virtual machine.
• D.Create an Azure HDInsight cluster.

Your company has two offices located in London and New York.
The London office has a public IP of 131.107.1.1 and a private IP subnet of 192.168.4.0/24. The New York office has a public IP of 131.107.15.1 and a private IP subnet of 192.168.8.0/24.
You have a Microsoft Azure SQL database. Currently, only the users in the London office use the database.
You plan to provide the users in the New York office with access to the database.
You need to ensure that the New York office users can access the database.
Which command should you execute?

• A.EXECUTEsp_set_database_firewall_ruleN'NewYork,'131.107.15.1','255.255.255.255'
• B.EXECUTE sp_set_database_firewall_rule N'NewYork, '192.168.8.0', '192.168.8.255';
• C.EXECUTE sp_set_database_firewall_rule N'NewYork,'131.107.15.1','131.107.15.1';
• D.EXECUTE sp_set_database_firewall_rule N'NewYork,'192.168.8.0', '255.255.255.0';