You administer a Microsoft SQL Server 2012. A process that normally runs in less than 10 seconds
has been running for more than an hour. You examine the application log and discover that the
process is using session ID 60. You need to find out whether the process is being blocked. Which
Transact-SQL statement should you use?

You administer a Microsoft SQL Server 2012 database. You need to ensure that the size of the
transaction log file does not exceed 2GB. What should you do?

You install a SQL Server 2012 database engine instance on a production server. A month later,
you install SQL Server 2012 Integration Services (SSIS). You must develop an SSIS project and
deploy it to the server by using the Project Deployment model. Operations log records that are
outside the configured retention period must be cleaned automatically. You need to create the SSIS
catalog on the production server and ensure that the operations log cleaning requirement is met.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

You maintain a SQL Server Integration Services (SSIS) package. The package was developed by
using SQL Server 2008 Business Intelligence Development Studio (BIDS). The package includes
custom scripts that must be upgraded. You need to upgrade the package to SQL Server 2012.
Which tool should you use?

You need to extract data from a table in a SQL Server 2012 database. What connection manager
types can you use? (Choose all that apply.)

You are installing the Data Quality Server component of Data Quality Services. You need to
provision the hardware and install the software for the server that runs the Data Quality Server.
You must ensure that the minimum Data Quality Server prerequisites are met. What should you
do?

You are designing a data warehouse that uses SQL Server 2012. You are preparing to update the
contents of a fact table that contains a non-clustered columnstore index. You need to run an update
statement against the table. What should you do first?

You need to create a view named uv_CustomerFullNames. The view must prevent the underlying
structure of the customer table from being changed. Part of the correct T-SQL statement has been
provided in the answer area. Provide the complete code.

Which of the following functions would you consider using to generate surrogate keys? (Choose all
that apply.)

Why is it important to use the appropriate type for attributes?