DP 300 KNOWLEDGE QUIZ

The _ database stores the information about logins in SQL Server

Which role allows you to create users within a database?

• db_securityadmin

• db_datareader

• db_accessadmin

Which feature allows you to connect to Azure SQL Database using a private endpoint?

• Access Link

• Private Link

• Virtual Network

• Network Endpoint

Which database object can be granted insert access?

• Procedures

• Tables

• Functions

• Schemas

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.

Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.

You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.

What should you include in the recommendation?

• Azure Backup

• Windows Server Failover Cluster

• Azure Site Recovery

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? 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?

• Assign User1 the db_datareader role for the databases that User1 creates.

• Create User1 in the master database.

• Grant SELECT on sys.databases to public in the master database.

Which of the following threats is analyzed by Advanced Threat Protection?

• Open Firewall Rules

• SQL Injection

• Weak Passwords

Event sessions can be used to trace activity within the database which can help you with which troubleshooting issues?

• Blocking Performance Issues

• Identifying long-running queries

• Observing Memory Pressure in your database

• All of the above