- All Exams Instant Download
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storage used by the database. Which...
What should you do?
You administer a Microsoft SQL Server 2012 instance. After a routine shutdown, the drive that contains tempdb fails. You need to be able to start the SQL Server. What should you do?A . Modify tempdb location in startup parameters.B . Start SQL Server in minimal configuration mode.C . Start SQL...
What should you do?
You administer a Microsoft SQL Server 2012 server. The MSSQLSERVER service uses a domain account named CONTOSOSQLService. You plan to configure Instant File Initialization. You need to ensure that Data File Autogrow operations use Instant File Initialization. What should you do? Choose all that apply.A . Restart the SQL Server...
What should you do?
You administer a Microsoft SQL Server 2012 server that hosts a transactional database and a reporting database. The transactional database is updated through a web application and is operational throughout the day. The reporting database is only updated from the transactional database. The recovery model and backup schedule are configured...
What should you use?
You administer a Microsoft SQL Server 2012 database. You have a SQL Server Agent job instance that runs using the service account. You have a job step within the job that requires elevated permissions. You need to ensure that the job step can run using a different user account. What...
Which four Transact-SQL statements should you use?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has a database named Contoso. The Contoso database has a table named ProductPrices in a schema named Sales. You need to create a script that writes audit events into the application log whenever data in the ProductPrices table is...
Which three actions should you perform in sequence?
DRAG DROP You administer a Microsoft SQL Server 2012 server that has multiple databases. You need to ensure that users are unable to create stored procedures that begin with sp_. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to...
Which data import command and recovery model should you choose?
DRAG DROP You administer a Microsoft SQL Server database. You want to import data from a text file to the database. You need to ensure that the following requirements are met: - Data import is performed by using a stored procedure. - Data is loaded as a unit and is...
What should you do?
You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured. When SQL Server Agent jobs fail, the error messages returned by the job steps do not provide the required detail. The following error message is an example error message: "The job failed. The Job...
You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B
DRAG DROP You administer a single Microsoft SQL Server instance on a two-node failover cluster that has nodes named Node A and Node B. The instance is currently running on NodeA . You want to patch both Node A and Node B by using the most recent SQL Server Service...
