You configure a SQL Server 2008 instance that contains a database named
AdventureWorks.

The AdventureWorks database experiences deadlock problems.
You need to capture the deadlock information to the SQL Server error log.
What should you do?

View Exhibit
Choose the correct answer.

You administer a SQL Server 2008 instance. The instance contains a database named DB1.

You plan to allow all the application developers to use SQL Server Profiler to capture traces
to troubleshoot the application that uses the database DB1.
You need to grant the minimum necessary permission to the application developers.
What should you do?

You are a database administrator for your company. The company uses a SQL Server 2008
database that includes a table named Inventory.
The table contains a column named Price. A company policy states that the value in the
Price column cannot be decreased by more than 10 percent in any single database
operation.
Updates to the Price column are made by various means, including by using ad hoc queries.
You need to ensure that this company policy is enforced. What should you do?

You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 stores
customer data for the company. The customers use a Web application to access their profile
data.

You need to protect the customer data such that data files, log files, and subsequent
backups are as secure as possible even if the backup media is lost. Your solution must not
affect the Web application or impact performance.
What should you do?

You administer two SQL Server 2008 instances named Instance 1 and Instance 2. A
database named AdventureWorks resides on Instance1. You move the AdventureWorks
database from Instance1 to Instance2.
A SQL Server login named Mary with the password “Re#99$45” is used by a user to access
the database on Instance1. You create the same SQL Server login on Instance2.
The user attempts to access the AdventureWorks database on Instance2 by using the SQL
Server login Mary. However, the user receives an error message which indicates that the
access to the AdventureWorks database is denied.
You need to ensure that the user can access the AdventureWorks database.
Which Transact-SQL statements should you execute on Instance!?

You administer a SQL Server 2008 instance that contains a database named DB1.
A table named Sales.Table1 exists in the Sales schema.
You need to move the Sales.Table1 table to a new schema named Billing.
Which Transact-SQL statement should you execute?

You are a database administrator for your company. There are four automated testing areas
for finished items in the company’s manufacturing floor. SQL Server 2008 is used to reserve
testing results for every testing area. You should create a replication method to make sure
that test results flow from the testing areas to the SQL Server quickly. The results of testing
will be used on reporting. Which is the correct answer?

You administer a SQL Server 2008 instance that contains a database named DB1.
The DB1 database contains the following stored procedure. (Line numbers are included for
reference only.)

When a user named User1 attempts to invoke Procedure1, the following exception is raised:
“Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission
denied in database ‘DB1’.”
You need to provide User1 access to execute Procedure1 by allocating only the required
permissions.
What should you do?

You administer a SQL Server 2008 instance. You need to allow users on instance to query
remote data sources by using the OPENROWSET() sp_configure configuration option
should you configure?