Configure Database Authentication and Authorization DP-300 Practice Questions (Page 1)

Questions 1–5

1. 1application · medium

   You administer a SQL Server on an Azure Virtual Machine (SQL VM). The VM is not domain-joined. You need to allow a group of users to access the SQL Server instance. The users will authenticate with SQL Server authentication. What should you do?

   • ACreate SQL Server logins for each user with strong passwords and grant them access to the databases.
   • BCreate Windows logins for each user.
   • CEnable Entra ID authentication on the SQL VM.
   • DCreate database users with passwords for each user.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which security principal is used to group permissions at the server level and can be assigned to logins?

   • ASchema
   • BServer role
   • CApplication role
   • DDatabase role
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which authentication method allows users to connect to Azure SQL Managed Instance using their Microsoft Entra credentials without providing a separate SQL password?

   • AMicrosoft Entra authentication
   • BSQL authentication
   • CWindows authentication
   • DCertificate-based authentication
   Reveal Solution Discussion Select an answer first
5. 4expert · hard

   An application using a managed identity to connect to Azure SQL Database suddenly starts failing with 'Login failed for user'. The managed identity was working previously. The database user for the managed identity exists and has the correct permissions. What should you check first?

   • AEnsure the managed identity has been added to the db_owner role.
   • BVerify that the SQL server's firewall allows the managed identity's IP address.
   • CCheck if the database user's password has expired.
   • DVerify that the managed identity is still enabled and has not been deleted or disabled.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   Your company uses Microsoft Entra ID for all identity management. You are configuring a new Azure SQL Database logical server. The database will be accessed only by a group of developers who authenticate with their Entra ID accounts. You need to create a database user for the developers group so they can be granted permissions. Which T-SQL statement should you run in the database?

   • ACREATE USER [Developers] WITH PASSWORD = '...';
   • BCREATE USER [Developers] FROM EXTERNAL PROVIDER;
   • CCREATE LOGIN [Developers] FROM EXTERNAL PROVIDER;
   • DCREATE USER [Developers] FOR LOGIN [Developers];
   Reveal Solution Discussion Select an answer first