Microsoft DP-300 Practice Test - Questions Answers, Page 26
Question list
List of questions
Related questions
HOTSPOT
You have an Azure subscription that contains a group named Group1 and an Azure SQL managed instance that hosts a database named 081. You need to ensure that Group 1 has read access to new tables created m 06I The solution must use the principle of least privilege How should you complete the Transact-SQL statement' To answer, select the appropriate options in the answer are a. NOTE: Each correct selection is worth one point.
You have an Azure SQL database named DB1.
A user named User 1 has an Azure AD account.
You need to provide User1 with the ability to add and remove columns from the tables m DBV The solution must use the principle of least privilege.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1.
You need to ensure that you can back up db1 to storage1. The solution must meet the following requirements:
* Use block blob storage.
* Maximize security.
You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation. You need to create the required Automation accounts.
Which two accounts should you create? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You have an Azure SQL database named DB1.
You need to encrypt DB1. The solution must meet the following requirements;
- Encrypt data in motion.
- Support comparison operators.
- Provide randomized encryption.
What should you include in the solution?
You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image. You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance. What should you do first?
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance.
What should you use to minimize downtime and data loss during the migration?
You have an Azure subscription.
You need to deploy an Azure SQL database. The solution must meet the following requirements:
- Dynamically scale CPU resources.
- Ensure that the database can be paused to reduce costs.
What should you use?
You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:
- Support real-time data replication to a different geographic region.
- Use Azure as a disaster recovery target.
- Minimize costs and administrative effort.
What should you include in the recommendation?
You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attribute is unsupported in SQLMI1?
Question