You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
SQL Server 2008 instances at five sites are managed by you.
A mission-critical database is shared by the five sites. According to the business requirements,
the users at each site should be enabled to access and change data on all sites with minimal latency.
In addition, data loss should be minimized if a server fails.
A high-availability solution should be designed, and the business requirements should be satisfied.
Which action should be included in your solution?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. A database is included by an instance.
And a large table named OrderDetails is included by the database.
Only DML statements on the last three months data are executed by the application queries.
Administrative audits are managed monthly on data which is longer than four months.
The performance problems listed below are found by you in the database.
The performance of the application queries against the OrderDetail table is poor.
It takes a long time to perform the maintenance tasks against the database, index defragmentation is contained.
The performance problems should be solved with on impact on the server performance.
Which action will you perform?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle. In the company, your job is to implement solutions on security,
troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. The security requirements should be designed for a new database application,
and the application will be deployed to the instance.
A table is consisted by the new database, and the table is created by utilizing the following code segment:
TABLE EmpBonusPlan
Since you are the technical support, you should utilize the maximum secure method to protect the
BonusPlan column from the access of unauthorized users. Which action will you perform to finish the task?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. 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, and a class definition that public static fields are utilized.
SQL CLR integration is utilized by the code segment, and 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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you.
A maintenance strategy should be designed for a mission-critical database, and a large table named Orders
is contained by the database. Index maintenance operations are contained in the design plan. When you
design the strategy, the facts listed below should be taken into consideration.
First, the users continuously access to the Orders table in the database.Secondly,
a column of the xml data type is contained by Orders table.
Thirdly, the new rows are regularly added to the Orders table. Fourthly, the average fragmentation
for the clustered index of the Orders table is no more than 2 percent.
A strategy should be designed to have the performance of the queries on the table optimized.
Which action will you perform?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. a new database application is hosted by the instance.
The security requirements should be designed for the application.
A unique login to the SQL Server 2008 server is assigned to each application user.
Stored procedures are included by the application database to execute stored procedures in the MSDB database.
SQLAgent jobs are scheduled by the stored procedures in the MSDB database.
Since you are the technical support, you are required to confirm that the stored procedures in the MSDB database should be
executed by utilizing the security context of the application user.
Which action should you perform?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 instance is managed by you. A
database is utilized by the instance, and the database is utilized by a Web-based application. 15,000
transactions are processed by the application every minute.
A column is contained by a table in the database, and the column is utilized only by the application.
Sensitive data is stored in this column. The sensitive data should be stored with the highest security level.
In addition, the least amount of memory space and processor time should be utilized.
From the following four encryption types, which one should you utilize?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo. You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 database solution is managed by you.
All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE
statements are utilized by the procedures.
A backup strategy should be implemented. The business requirements listed below should be satisfied.
Point-in-time recovery for failure is supported by the backup strategy at any time of day. In addition,
the least amount of disk space should be utilized by the transaction log.
Which action should you perform to finish the task?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo.
You are experienced in managing databases in an enterprise-level organization,optimizing and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you. 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?

You are a professional level SQL Sever 2008 Database Administrator in an international corporation
named Wiikigo.
You are experienced in managing databases in an enterprise-level organization,optimizing
and sustaining the database life cycle.
In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization.
A SQL Server 2008 infrastructure is managed by you.
After a regular test, you find that performance degradation is experienced by an instance for the three reasons:
Excessive CPU, usageServer processes paging and Deadlocks A monitoring solution should be
implemented to provide data, monitor and troubleshoot performance issues.
And detailed deadlock information should be contained in the provided data.
You should utilize the least amount of administrative effort to finish the task.
Which tool will you utilize to finish the task?