You administer a Microsoft SQL Server 2008 R2 instance that contains two databases named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the SQL_Latin1_General_CP1_CS_AS collation.
You need to write a query that returns all customers having the same name in each database. You also need to ensure that the query is not case-sensitive.
Which Transact-SQL query should you use?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?

• A. Use the SQL Server 2008 Upgrade Advisor.
• B. Use a SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes.
• C. Use the SQL Server Profiler that captures the SQL:BatchCompleted and Exception event classes.
• D. Use a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.

You are mastering the company database; there is the transaction information which is for company's Web-based order system in the database of the company.
The database is set to utilize the full recovery model. Between the hours of 20:00 and 04:00, you get the few orders; one hour should be accepted for the risk when the system is runningDatabase backups should be run as quickly as possible. You should create the solution to avoid this kind of risk. What should you do?

• A. You should set a Back up Database task to do the whole backup of the database every day at 20:00. Configure a second Back up Database job to run differential
• B. You should set a Back up Database job to run the whole backup at 09:00 and 14:00. Set a second Back up Database task to do transaction log backups every
• C. Configure a Check Database Integrity task to run every hour.
• D. Set a third Back up Database job to run transaction log backups every hour.
• E. You should set a Back up Database job to do the whole backup of the database every day at 20:00. Set a second Back up Database task to run differential
• F. You should set a Back up Database job to run the whole backup of the database every hour. Set a Check Database Integrity task to run every day in order to

You maintain a default SQL Server 2008 instance.
You plan to configure FILESTREAM data to meet the following requirements: - Enable FILESTREAM for file I/O streaming access. - Allow remote client computers to have streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
Which service should you configure?

• A. Distributed File System
• B. SQL Server Full Text
• C. SQL Server
• D. SQL Server VSS Write

You administer a SQL Server 2008 instance that contains a database named DB1. DB1 contains a table named Table1.
The DB1 database includes a stored procedure named Procedure1. Procedure 1 uses a sp_executesql Transact-SQL statement to select data from Table1.
According to business requirements, users are not allowed to access tables directly in any database.
When a user executes Procedure1, the following exception is raised:
"Msg 229, Level 14, State 5, Line 1
The SELECT permission was denied on the object Table1', database 'DB1', schema 'dbo'."
You need to ensure that the user can successfully execute Procedure1 without violating the business requirements.
What should you do?

• A. Execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
• B. Execute the GRANT SELECT ON dbo.Table1 TO User1 Transact-SQL statement.
• C. Alter Procedure1 and add the WITH EXECUTE AS OWNER option to its header.
• D. Alter Procedure1 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.