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

Question 54: You work as a Database Administrator (DBA) for a company named ABC.com. The company uses a Microsoft SQL Server 2012 infrastructure. Computer users use custom…
Question 57: Your company has offices in Seattle and Montreal. The network contains two servers named Server1 and Server2 that have SQL Server 2012 installed. Server1 is lo…
Question 58: You are a database administrator for a Microsoft SQL Server 2016 instance. You need to ensure that data can be replicated from a production server to two repor…
Question 62: You manage a Microsoft SQL Server environment. You plan to encrypt data when you create backups. You need to configure the encryption options for backups. What…
Question 63: You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions of requests per hour. Queries on DB1 are taking longer than n…
Question 69: You have configured Resource Governor with three resource pools. You have assigned the first resource pool a minimum CPU and memory value of 20%. You have assi…
Question 70: You administer a single server that contains a Microsoft SQL Server 2016 default instance on which several production databases have been deployed. You plan to…
Question 71: You administer a Microsoft SQL Server 2016 default instance. The instance is hosted by a server that has a local firewall configured. The firewall only allows…
Question 72: You administer all the deployments of Microsoft SQL Server 2016 in your company. You need to ensure that an OLTP database that includes up-to-the-minute report…
Question 73: You administer all the deployments of Microsoft SQL Server 2016 in your company. You need to ensure that data changes are sent to a non-SQL Server database ser…