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

Questions 6–10

1. 6foundation · easy

   On a SQL Server on Azure Virtual Machine, which authentication mode must be enabled to allow SQL logins to be used?

   • AWindows Authentication Mode
   • BMixed Mode
   • CEntra-only Authentication Mode
   • DSingle Sign-On Mode
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A junior DBA needs to grant a user SELECT permission on a specific table in Azure SQL Database using a graphical tool. The junior DBA has access to the Azure portal and SQL Server Management Studio (SSMS). The user is already a database user. What is the most efficient way to grant the permission?

   • AUse the Azure portal to add the user to the db_datareader role.
   • BUse SSMS to create a new login for the user and then grant SELECT on the table.
   • CUse SSMS to connect to the database, locate the user, open the Properties dialog, and add the SELECT permission on the table via the Permissions page.
   • DUse the Azure portal to navigate to the table and assign the SELECT permission to the user.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   You need to grant a database user named 'app_user' the ability to execute a stored procedure named 'usp_GetOrders' in the 'Sales' database. The user should not have any other permissions. What T-SQL statement should you use?

   • AGRANT SELECT ON OBJECT::dbo.usp_GetOrders TO app_user;
   • BALTER ROLE db_executor ADD MEMBER app_user;
   • CGRANT CONTROL ON SCHEMA::dbo TO app_user;
   • DGRANT EXECUTE ON OBJECT::dbo.usp_GetOrders TO app_user;
   Reveal Solution Discussion Select an answer first
5. 9expert · hard

   You are troubleshooting an authentication issue for a user who is trying to connect to an Azure SQL Database using their Microsoft Entra ID account. The user is a member of the Entra group 'DB_Admins', which has a database user mapped in the database. The user can connect to other databases on the same server, but not to this specific database. What is the most likely cause?

   • AThe user is not a member of the group in Entra ID.
   • BThe user's Entra account is disabled.
   • CThe database user for the group does not have the CONNECT permission in this database.
   • DThe server's Entra ID admin is not set.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   You are the database administrator for an Azure SQL Database. Users report they cannot connect using their Microsoft Entra ID accounts, although SQL authentication works. You verify that the Entra ID admin is set on the logical server. What is the most likely cause of the authentication failure?

   • AThe Entra ID admin is not a member of the sysadmin role.
   • BThe users have not been granted the CONNECT permission.
   • CThe users are using the wrong SQL Server name in their connection string.
   • DThe users are not members of the Entra ID group that is mapped to a database user.
   Reveal Solution Discussion Select an answer first