You administer two instances of Microsoft SQL Server 2012. You deploy an application that uses a database on the named instance. The application is unable to connect to the database on the named instance. You need to ensure that the application can connect to the named instance. What should you do?

• A. Use the Data Quality Client to configure the application.
• B. Start the SQL Server Integration Services Service.
• C. Use the Master Data Services Configuration Manager to configure the application.
• D. Start the SQL Server Browser Service.

You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that meets the following requirements:
Takes an input variable
Returns a table of values
Cannot be referenced within a view
Which object should you use?

• A. User-defined data type
• B. Scalar-valued function
• C. Inline function
• D. Stored procedure

You administer a Microsoft SQL Server 2012 database. You create an availability group named haContosoDbs. Your primary replica is available at Server01\Contoso01. You need to configure the availability group to have the highest availability. You also need to ensure that no data is lost. Which Transact-SQL statement should you use?

• A. ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON 'Server01
  \Contoso01' WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = AUTOMATIC)
• B. ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON 'Server01
  \Contoso01' WITH (AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL)
• C. ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON 'Server01
  \Contoso01'
  WITH (AVAILABILITY_MODE = SYNCHRONOUS_COMMIT, FAILOVER_MODE = MANUAL)
• D. ALTER AVAILABILITY GROUP haContosoDbs MODIFY REPLICA ON 'Server01
  \Contoso01' WITH (AVAILABILITY_MODE = ASYNCHRONOUS_COMMIT, FAILOVER_MODE = AUTOMATIC)

You administer a Microsoft SQL Server 2012 environment that contains a production SQL Server 2005 instance named SQL2005 and a development SQL Server 2012 instance named SQL2012. The development team develops a new application that uses the SQL Server 2012 functionality. You are planning to migrate a database from SQL2005 to SQL2012 so that the development team can test their new application. You need to migrate the database without affecting the production environment. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Build List and Reorder:

You are developing a database application by using Microsoft SQL Server 2012. You have a query that runs slower than expected. You need to capture execution plans that will include detailed information on missing indexes recommended by the query optimizer. What should you do?

• A. Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you run the query.
• B. Include a SET FORCEPLAN ON statement before you run the query.
• C. Add an INCLUDE clause to the index.
• D. Add a FORCESEEK hint to the query.
• E. Add a columnstore index to cover the query.
• F. Include a SET STATISTICS PROFILE ON statement before you run the query.
• G. Add a FORCESCAN hint to the Attach query.
• H. Add a HASH hint to the query.
• I. Cover the unique clustered index with a columnstore index.
• J. Enable the optimize for ad hoc workloads option.
• K. Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you run the query.
• L. Add a LOOP hint to the query.
• M. Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement before you run the query.
• N. Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.