Microsoft 70-462 Administering Microsoft SQL Server 2012 Databases Exam Practice Test

You plan to install a Microsoft SQL Server 2012 instance.

The instance will support a database that has the following requirements:

* Store Excel workbooks on the file system.

* Access the workbooks through Transact-SQL.

* Include the workbooks in database backups.

During installation, you need to ensure that the requirements will be met.

Which feature should you use?

Which of the following DBCC commands can you use to check the physical and logical integrity of an SQL Server 2012 database?

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 you can port the database to different database servers within the domain without additional user account configurations.

Which type of user should you create?

You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows Server 2008 R2 SP1.

Which of the following features must you install if you want to ensure that you can run packages in 32-bit mode?

You administer a Microsoft SQL Server 2012 database that contains a table named AccountTransaction.

You discover that query performance on the table is poor due to fragmentation on the IDX_AccountTransaction_AccountCode non-clustered index.

You need to defragment the index. You also need to ensure that user queries are able to use the index during the defragmenting process.

Which Transact-SQL batch should you use?

You install Microsoft SQL Server 2012 on a new server.

After setup is complete, you attempt to start the SQL Server service. After being in a starting state for a few moments, the service goes back to a stopped state.

You need to determine the cause of the failure.

Which file should you use?

You administer a Microsoft SQL Server 2012 database named Orders.

Orders contain a table named OrderShip that is defined as follows:

A NULL value represents a domestic order. Ninety percent of the values in CountryCode are NULL.

Customers require a procedure that will return orders for all customers from a specified country. You create a new procedure:

Performance on this procedure is slow.

You need to alter the schema to optimize this query. Objects created must use a minimum amount of resources.

Which Transact-SQL statement should you use?