HOTSPOT
You need to recommend the appropriate purchasing model and deployment option for the 30 new databases.
The solution must meet the technical requirements and the business requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

Section: [none]
Explanation:
Box 1: DTU
Scenario:
* The 30 new databases must scale automatically.
* Once all requirements are met, minimize costs whenever possible.
You can configure resources for the pool based either on the DTU-based purchasing model or the vCore-based
purchasing model.
In short, for simplicity, the DTU model has an advantage. Plus, if you're just getting started with Azure SQL
Database, the DTU model offers more options at the lower end of performance, so you can get started at a
lower price point than with vCore.
Box 2: An Azure SQL database elastic pool
Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple
databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a
single server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable
SaaS developers to optimize the price performance for a group of databases within a prescribed budget while
delivering performance elasticity for each database.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview
https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview
Question Set 2

Comment: *

Name: *

Email: *

Verification: *

You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
The database role membership for a user named User1 is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: delete a row from Table1
Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.
Box 2: db_datareader
Members of the db_datareader fixed database role can read all data from all user tables.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles

Comment: *

Name: *

Email: *

Verification: *

You have 10 Azure virtual machines that have SQL Server installed.
You need to implement a backup strategy to ensure that you can restore specific databases to other SQL
Server instances. The solution must provide centralized management of the backups.
What should you include in the backup strategy?

• A.Automated Backup in the SQL virtual machine settings
• B.Azure Backup
• C.Azure Site Recovery
• D.SQL Server Agent jobs

Comment: *

Name: *

Email: *

Verification: *

You create five Azure SQL Database instances on the same logical server.
In each database, you create a user for an Azure Active Directory (Azure AD) user named User1.
User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error.
You need to ensure that when User1 connects to the logical server by using Azure Data Studio, User1 can see all the databases.
What should you do?

• A.Create User1 in the master database.
• B.Assign User1 the db_datareader role for the master database.
• C.Assign User1 the db_datareader role for the databases that Userl creates.
• D.Grant select on sys.databases to public in the master database.

Comment: *

Name: *

Email: *

Verification: *

You have an Azure virtual machine based on a custom image named VM1.
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
* Automate the patching of SQL Server and Windows Server.
* Automate full database backups and transaction log backups of the databases on VM1.
* Minimize administrative effort.
What should you do first?

• A.Enable a system-assigned managed identity for VM1
• B.Register VM1 to the Microsoft.Sql resource provider
• C.Install an Azure virtual machine Desired State Configuration (DSC) extension on VM1
• D.Register VM1 to the Microsoft.SqlVirtualMachine resource provider

Comment: *

Name: *

Email: *

Verification: *