Provisioning SQL Databases Free Practice Exam Questions

52 real Provisioning SQL Databases exam questions with answers and AI explanations. Microsoft certification prep — page 1 of 6.

Question 1: You administer a Windows 2008 server hosting an instance of Microsoft SQL Server 2012 Standard Edition. The server hosts a database named Orders. Users report…
Question 4: You administer a SQL Server 2012 server that contains a database named SalesDB. SalesDb contains a schema named Customers that has a table named Regions. A use…
Question 5: You administer a Microsoft SQL Server 2012 instance named SQL2012. You are in the process of migrating a database from a SQL Server 2008 instance named SQL2008…
Question 6: You have a database named DB1. You discover that DB1 is corrupt. You run DBCC CHECKDB and receive an error message within a few seconds. No pages are listed in…
Question 10: You have a Microsoft Azure SQL database in the US West region. You need to create a replica in the US East region. Which cmdlet should you run first?
Question 12: You are the administrator for a SQL Server 2016 instance that stores the data for an online transaction processing sales system. The company takes full backups…
Question 13: You administer a Microsoft SQL Server 2012 database. You need to ensure that the size of the transaction log file does not exceed 2 GB. What should you do?
Question 14: You administer all the deployments of Microsoft SQL Server 2012 in your company. You have two servers in the same data center that hosts your production databa…
Question 16: Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. Th…
Question 18: Note: This questions 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 i…