Microsoft Provisioning SQL Databases - 070-765 FREE EXAM DUMPS QUESTIONS & ANSWERS
You have Microsoft SQL Server on a Microsoft azure virtual machine that has 12 databases.
All database files are in the same Azure Blob storage account.
You need to receive an email notification if I/O operations to the database files exceed 800 MB/s for more than five minutes.
Solution: You run the Get-Counter cmdlet and specify the -counter '\physicaldisk:disk Transfers/sec' parameter.
Does this meet the goal?
All database files are in the same Azure Blob storage account.
You need to receive an email notification if I/O operations to the database files exceed 800 MB/s for more than five minutes.
Solution: You run the Get-Counter cmdlet and specify the -counter '\physicaldisk:disk Transfers/sec' parameter.
Does this meet the goal?
Correct Answer: B
Vote an answer
You have Microsoft SQL Server on a Microsoft Azure Virtual machine that has a 4-TB database.
You plan to configure daily backups for the database. A single full backup will be approximately 1.5 TB of compressed data.
You need to ensure that the last backups are retained.
Where should you store the daily backups?
You plan to configure daily backups for the database. A single full backup will be approximately 1.5 TB of compressed data.
You need to ensure that the last backups are retained.
Where should you store the daily backups?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have Microsoft SQL Server on a Microsoft Azure virtual machine that has a database named DB1.
You discover that DB1 experiences WRITE_LOG waits that are longer than 50 ms.
You need to reduce the WRITE_LOG wait time.
Solution: Add additional data files to DB1.
Does this meet the goal?
After you answer a question in this sections, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have Microsoft SQL Server on a Microsoft Azure virtual machine that has a database named DB1.
You discover that DB1 experiences WRITE_LOG waits that are longer than 50 ms.
You need to reduce the WRITE_LOG wait time.
Solution: Add additional data files to DB1.
Does this meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You deploy a new Microsoft Azure SQL database instance to support a variety of mobile application and public websites. You configure geo-replication with regions in Brazil and Japan.
You need to implement real-time encryption of the database and all backups.
Solution: You use the always Encrypted wizard to encrypt all possible for the tables in the primary instance.
Does the solution meet the goal?
You need to implement real-time encryption of the database and all backups.
Solution: You use the always Encrypted wizard to encrypt all possible for the tables in the primary instance.
Does the solution meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have a Microsoft Azure SQL Database instance named Marketing. The instance is hosted on an Azure SQL Server named mycompanyazure. The server uses a storage account named mycompanyblob.
You attempt to connect to the Azure SQL Database instance by using SQL Management Studio on your Windows device. You are unable to connect.
You need to resolve the issue.
Which three actions should you perform in sequence? (Choose three.)
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
You attempt to connect to the Azure SQL Database instance by using SQL Management Studio on your Windows device. You are unable to connect.
You need to resolve the issue.
Which three actions should you perform in sequence? (Choose three.)
To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Correct Answer:
Reference:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms
You are using dynamic management views to monitor an SQL Server server named SQL1.
A database administrator named Dba1 must monitor the health of SQL1.
You need to ensure that Dba1 can access dynamic management views for SQL1.
The solution must use the principle of least privilege.
Which permissions should you assign to Dba1?
A database administrator named Dba1 must monitor the health of SQL1.
You need to ensure that Dba1 can access dynamic management views for SQL1.
The solution must use the principle of least privilege.
Which permissions should you assign to Dba1?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have Microsoft SQL Server on a Microsoft Azure Virtual machine. The virtual machine has a database named DB1.
You need to identify the fragmentation percentage for the indexes of DB1.
Which dynamic management view should you query?
You need to identify the fragmentation percentage for the indexes of DB1.
Which dynamic management view should you query?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You have an on-premises Microsoft SQL Server named Server1.
You provision a Microsoft Azure SQL Database server named Server2.
On Server1, you create a database named DB1.
You need to enable the Stretch Database feature for DB1.
Which five 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 provision a Microsoft Azure SQL Database server named Server2.
On Server1, you create a database named DB1.
You need to enable the Stretch Database feature for DB1.
Which five 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.
Correct Answer:
1 - Enable the remote data archive option in DB1
2 - Create a firewall rule in Azure
3 - Create a master key in the master database.
4 - Create a database scoped credential for authentication to Azure
5 - Create a server-level credential for authentication to Azure.
Explanation:
Step 1: Enable the remote data archive option in DB1
Prerequisite: Enable Stretch Database on the server
Before you can enable Stretch Database on a database or a table, you have to enable it on the local server. To enable Stretch Database on the server manually, run sp_configure and turn on the remote data archive option.
Step 2: Create a firewall rule in Azure
On the Azure server, create a firewall rule with the IP address range of the SQL Server that lets SQL Server communicate with the remote server.
Step 3: Create a master key in the master database
To configure a SQL Server database for Stretch Database, the database has to have a database master key. The database master key secures the credentials that Stretch Database uses to connect to the remote database.
Step 4: Create a database scoped credential for authentication to Azure When you configure a database for Stretch Database, you have to provide a credential for Stretch Database to use for communication between the on premises SQL Server and the remote Azure server. You have two options.
Step 5: Create a server-level credential for authentication to Azure.
To configure a database for Stretch Database, run the ALTER DATABASE command.
For the SERVER argument, provide the name of an existing Azure server, including the .database.windows.net portion of the name - for example, MyStretchDatabaseServer.database.windows.net.
Provide an existing administrator credential with the CREDENTIAL argument, or specify FEDERATED_SERVICE_ACCOUNT = ON. The following example provides an existing credential.
ALTER DATABASE <database name>
SET REMOTE_DATA_ARCHIVE = ON
(
SERVER = '<server_name>' ,
CREDENTIAL = <db_scoped_credential_name>
) ;
GO
References:
https://docs.microsoft.com/en-us/sql/sql-server/stretch-database/enable-stretch-database-for-a-database?view=sql-server-2017
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains unique solution. Determine whether the solution meets the stated goals.
You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile applications and public websites. You configure geo-replication with regions in Brazil and Japan.
You need to implement real-time encryption of the database and all backups.
Solution: You use the Always Encrypted Wizard to encrypt all possible columns for the tables in the primary instance.
Does the solution meet the goal?
You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile applications and public websites. You configure geo-replication with regions in Brazil and Japan.
You need to implement real-time encryption of the database and all backups.
Solution: You use the Always Encrypted Wizard to encrypt all possible columns for the tables in the primary instance.
Does the solution meet the goal?
Correct Answer: A
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).
You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory.
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?
Users need to be able to SELECT from all tables in the database and execute the stored procedure.
You need to grant only the necessary permissions.
What should you do?
Correct Answer: C
Vote an answer
Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).