You are a professional level SQL Sever 2008 Database Administrator.
A business-critical database is hosted by the instance, and the database must be constantly available to the users with no data loss. Filestream data is contained by the database.
A high-availability solution should be designed for the site.
Which solution should be utilized?

• A. Synchronous database mirroring with a witness server should be utilized.
• B. Asynchronous database mirroring should be utilized.
• C. Database snapshot should be utilized.
• D. Failover clustering should be utilized.

You administer a SQL Server 2008 instance named Instance1 at the New York central site. Your company has a sales team to fulfill purchase orders for customer requests.
The sales team uses portable computers to update data frequently in a local database. When the portable computers connect to the central site, the local database must be synchronized with a database named Sales.
You plan to create a replication model to replicate the local database to the Sales database.
The replication model must meet the following requirements:
Data conflicts are handled when multiple users update the same data independently.
The sales team cannot update sensitive data such as product price.
The sales team can synchronize data at scheduled times and on demand also.
You need to identify the best model to replicate data by using minimum development efforts.
What should you do?

• A. Use SQL Server Integration Services (SSIS) to push data changes and pull updates to the Sales database along with the SSIS packages, on demand.
• B. Use snapshot replication along with each portable computer that is set up as a subscriber.
• C. Use transactional replication along with each portable computer that is set up as a publisher.
• D. Use merge replication along with each portable computer that is set up as a subscriber.

You are a professional level SQL Sever 2008 Database Administrator.
Two SQL Server 2008 instances are managed by you, and they are respectively called Ins01 and Ins02.
The Sales database is included in Ins01, while the Accounts database is contained by Ins02. A transaction
is
started by A procedure in the Sales database. And then, the Sales.dbo.Order table and the Accounts.dbo.
OrderHistory table are updated by the procedure through a linked server.
Since you are the technical support of the company, you are required to make sure that a
two-phase commit is utilized by the transaction.
Which action will you perform to finish the task?

• A. To finish the task, the linked server to utilize distributed transactions
• B. To finish the task, the linked server should be properly configured for impersonation.
• C. To finish the task, the linked server should be properly configured for delegation.
• D. To finish the task, a Service Broker should be configured to have the proper transaction control enabled.

You are a professional level SQL Sever 2008 Database Administrator.
There are 30 branch offices in DoubleSecurity Insurance, and in the branch offices, customer data are stored in SQL Server 2008 databases. Customer data should be security compliant if it is stored through multiple database instances.
You intend to utilize the Policy-Based Management feature to design a strategy for custom policies. And the format of custom policies is XML format. The requirements listed below should be satisfied.
The company distributes custom policies to all instances. In addition, the company enforces the policies on all instances. A strategy should be thought out and the minimum amount of administrative effort should be utilized.
Which action should you perform to finish the task?

• A. To finish the task, a configuration server should be utilized.
• B. To finish the task, the policies should be distributed by utilizing the Active Directory directory service.
• C. To finish the task, the Distributed File System Replication service should be utilized.
• D. To finish the task, the policies should be distributed by utilizing Group Policy Objects.

You are a professional level SQL Sever 2008 Database Administrator.
Your company wants to enforce naming standards for the database objects.
A solution should be designed by you to enforce naming standards,
and the least amount of administrative and programming efforts should be utilized.
Which action should you perform?

• A. DDL triggers should be created for one of the instances, and then SQL Server Management Objects (SMO) should be utilized to script the definition of the DDL triggers. At last, the script should be run by utilizing Microsoft Windows PowerShell on all instances.
• B. Event notifications should be utilized to handle the DDL events.
• C. DDL triggers should be created for one of the instances, and then Microsoft SQL Server Management Studio (SSMS) should be utilized to script the definition of the DDL triggers. At last, the script should be run on all instances by utilizing the registered server??s node from SSMS.
• D. Policy-Based Management policies should be created, and then the policies should be distributed by utilizing a configuration server.