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

Question 220: 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 221: You are a database administrator for a Microsoft SQL Server 2016 environment. You want to deploy a new application that will scale out the workload to at least…
Question 223: Your company has a SQL Azure subscription. You implement a database named Database1. Database1 has two tables named Table1 and Table2. You create a stored proc…
Question 224: You administer a Microsoft SQL Server 2016 server. One of the databases on the server supports a highly active OLTP application. Users report abnormally long w…
Question 229: You need to provide a group of users from the IT and Manufacturing departments the minimum administrative rights to view database information and server state…
Question 230: You need to address the Sales Director's requirements regarding the customer classification. You need to recommend a solution for changing the classifications.…
Question 231: You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. You have a database named…
Question 232: A Microsoft SQL Server database named DB1 has two filegroups named FG1 and FG2. You implement a backup strategy that creates backups for the filegroups. DB1 ex…
Question 233: You administer all the deployments of Microsoft SQL Server 2016 in your company. You need to ensure that an OLTP database that uses a storage area network (SAN…
Question 235: You need to move a database in between servers. You need to guarantee database users will be able to login in the database with a minimum of management effort.