Administering a SQL Database Infrastructure Free Practice Exam Questions

141 real Administering a SQL Database Infrastructure exam questions with answers and AI explanations. Microsoft certification prep — page 1 of 15.

Question 3: You administer a Windows Azure SQL Database database named Inventory that contains a stored procedure named p_AddInventory. Users need to be able to SELECT fro…
Question 9: You have two SQL Server instances named SQLDev and SQLProd that have access to various storage media. You plan to synchronize SQLDev and SQLProd. You need to r…
Question 12: Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the…
Question 13: Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in…
Question 15: You administer a Microsoft SQL Server 2016 instance that contains a financial database hosted on a storage area network (SAN). The financial database has the f…
Question 20: Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in…
Question 26: You are implementing a SQL Server 2016 five-node failover cluster. You need to choose a quorum configuration. Which configuration should you use?
Question 27: You administer a Microsoft SQL Server 2016 database named Contoso that contains a single user-defined database role namedBillingUsers. All objects in Contoso a…
Question 28: You administer a Microsoft SQL Server 2016 instance. After a routine shutdown, the drive that contains tempdb fails. You need to be able to start the SQL Serve…
Question 31: You manage a Microsoft SQL Server environment. You plan to configure Database Mail. You need to ensure that all users can access a private Database Mail profil…