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 10 of 15.

Question 151: You manage a SQL Server 2014 instance that contains a database named DB1. Users report that some queries to DB1 take longer than expected. Although most querie…
Question 152: You are creating a database that will store usernames and credit card numbers for an application. You need to recommend a solution to store and reuse the credi…
Question 153: Overview - You are a database administrator for a company named Litware, Inc. Litware is a book publishing house. Litware has a main office and a branch office…
Question 161: You need to ensure that a stored procedure fails if an INSERT statement within the stored procedure fails. What action should you take?
Question 162: You need to grant access to an OLTP database regardless of the user operating the application. Which strategy should you use?
Question 163: You use a contained database named ContosoDb within a domain. You need to create a user who can log on to the ContosoDb database. You also need to ensure that…
Question 164: You create an availability group that has replicas named HA/Server01 and HA/Server02. Currently, HA/Server01 is the primary replica. You have multiple queries…
Question 165: You administer a Microsoft SQL Server 2012 instance. You need to configure a new database to support FILETABLES. What should you do? Choose all that apply.
Question 166: You work as a Database Administrator (DBA) for a company named ABC.com. The company has a Windows Azure subscription. The company uses a cloud based SQL Server…
Question 167: You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. A server named ABC-SQL1 ho…