You are a professional level SQL Sever 2008 Database Administrator.
The solution is log-shipped for high-availability purposes. The data files of the database reside on drive D,
while the transaction log files of the database reside on drive E. A restoring test plan should be
implemented
to satisfy the requirements listed below for the log-shipping solution.
First, the secondary database is brought online in the shortest time.
Secondly, the data is in a consistent state.
Thirdly, the data loss is reduced to the least.
The first step for the recovery test plan should be identified in the event of drive D failure.
Which step should be performed?

• A. You should perform the tail-log backup of the primary database.
• B. You should execute the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS option against the primary database.
• C. You should bring the secondary database online.
• D. You should execute the DBCC CHECKDB command along with the REPAIR_REBUILD option against the primary database.

You are a professional level SQL Sever 2008 Database Administrator.
The security requirements should be designed for a new database application. A code segment is utilized by the application, and the code segment includes the following components:
A method that the registry is accessed on the SQL Server
A method that the file system is accessed on a network file server
A class definition that public static fields are utilized
SQL CLR integration is utilized by the code segment
The code segment is implemented as a single assembly.
Since you are the technical support, you are required to make sure that the application should be successfully deployed to the instance.
Which action will you perform?

• A. All public static fields should be utilized with public static read-only fields. And then the assembly should be registered by utilizing the regasm.exe utility before deployment.
• B. All public static fields should be replaced with public fields.
• C. All public static fields should be replaced with public static read-only fields. And then the EXTERNAL_ACCESS code access security should be utilized for the assembly.
• D. The SAFE code access security should be utilized for the assembly.

You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated.
You need to ensure the successful recovery of any single database from a catastrophic failure without requiring a backup data center in a different location.
Which three tasks should you include? (Each correct answer presents part of the solution. Choose three.)

• A. Maintain one list of all Windows logins and passwords.
• B. Document the administrative processes and application access requirements.
• C. Store all backup media offsite.
• D. Install all SQL Server instances on a failover cluster.
• E. Script SQL login accounts and credentials.

You administer a SQL Server 2008 infrastructure.
You plan to design a solution to obtain hardware configurations, such as the number of processors on a computer and the processor type of all SQL Server 2008 computers.
The solution must meet the following requirements:
It is hosted on the central computer.
It can verify hardware configurations for multiple servers.
You need to select a technology that meets the requirements by using the minimum amount of development effort.
What should you do?

• A. Use the Windows Management Instrumentation (WMI) provider for the server events.
• B. Use the Invoke-Sqlcmd cmdlet in SQL Server PowerShell cmdlet.
• C. Define policies based on conditions by using the ExecuteSql function.
• D. Define policies based on conditions by using the ExecuteWQL function.

You administer two SQL Server 2008 instances named Instance1 and Instance2. Instance1 contains the Sales database, and Instance2 contains the Accounts database.
A procedure in the Sales database starts a transaction. The procedure then updates the Sales.dbo.Order table and the Accounts.dbo.OrderHistory table through a linked server.
You need to ensure that the transaction uses a two-phase commit.
What should you do?

• A. Ensure that the linked server is appropriately configured for impersonation.
• B. Ensure that the linked server is appropriately configured for delegation.
• C. Configure a Service Broker to enable the appropriate transaction control.
• D. Configure the linked server to use distributed transactions.