You develop a database application. You create four tables. Each table stores different categories
of products. You create a Primary Key field on each table. You need to ensure that the following
requirements are met.
– The fields must use the minimum amount of space.
– The fields must be an incrementing series of values.
– The values must be unique among the four tables.
What should you do?

You create a view based on the following statement.

You grant the Select permission to User1. You need to change the view so that it displays only the
records that were processed in the month prior to the current month. You need to ensure that after

the changes, the view functions correctly for User1. Which Transact-SQL statement should you
use?

You administer a Microsoft SQL Server 2012 database. Users report that an application that
accesses the database displays an error, but the error does not provide meaningful information.
No entries are found in the SQL Server log or Windows event logs related to the error. You need
to identify the root cause of the issue by retrieving the error message. What should you do?

You administer a Microsoft SQL Server 2012 server. One of the databases on the server supports
a highly active OLTP application. Users report abnormally long wait times when they submit data

into the application. You need to identify which queries are taking longer than 1 second to run over
an extended period of time. What should you do?

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?