You administer a SQL Server 2008 instance.
The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data.
You need to store the sensitive data in the most secure manner possible.
You also need to ensure that you minimize the usage of memory space and processor time.
Which encryption type should you use?

• A. Symmetric key encryption
• B. Transparent data encryption
• C. Asymmetric key encryption
• D. Certificate-based encryption

설명: (Fast2test 회원만 볼 수 있음)

You are a professional level SQL Sever 2008 Database Administrator.
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?

• A. An additional table named OrderDetailsHistory should be created for data older than four months. And then, the following Transact-SQL statement should be utilized. CREATE TRIGGER trgMoveDataON OrderDetailsAFTER INSERT ASINSERT INTO OrderDetailsHistory SELECT * FROM OrderDetailsWHERE DATEDIFF(m,OrderDate,GETDATE())>4
• B. A database snapshot should be created for the OrderDetails table every four months. And then, the queries should be changed to utilize the present snapshot.
• C. An additional table named OrderDetailsHistory should be created for data older than four months. And then, the OrderDetails and OrderDetailsHistory tables should be partitioned in two parts by utilizing the OrderDate column. At last, a SQL Server Agent job that runs every month should be created and the ALTER TABLE...SWITCH Transact-SQL statement should be utilized to remove data that is longer than four months to the OrderDetailsHistory table.
• D. An additional table named OrderDetailsHistory should be created for data longer than four months. And then, a SQL Server Agent job that runs the following Transact-SQL statement every month should be created. INSERT INTO OrderDetailsHistory SELECT * FROM OrderDetailsWHERE DATEDIFF(m, OrderDate,GETDATE())>4

설명: (Fast2test 회원만 볼 수 있음)

You administer a SQL Server 2008 instance that hosts a database.
The backup strategy used by the database is as shown in the following table: You run a batch process on Saturday that lasts from 21:00 hr to 23:00 hr. You discover that the batch process is invalidated because a user has modified some data at 21:05 hr on the same day.

You need to restore the database to its state at the start of the batch process in the least possible time.
What should you do?

• A. Restore the full database backup that was performed on Thursday Restore all transaction logs from the time of the full backup on Thursday and stop at 21:00 hr on Saturday.
• B. Restore the full database backup that was performed on Saturday. Restore all transaction logs from the time of the full backup on Saturday and stop at 21:00 hr on Saturday.
• C. Restore the full database backup that was performed on Thursday. Restore the differential backup that was performed on Friday. Restore all transaction logs from the time of the differential backup on Friday and stop at 21:00 hr on Saturday.
• D. Restore the full database backup that was performed on Saturday.

설명: (Fast2test 회원만 볼 수 있음)

You administer a SQL Server 2008 infrastructure.
You discover that an instance experiences performance degradation for the following reasons:
Excessive CPU usage
Server processes paging
Deadlocks
You need to design a monitoring solution that can provide data, including detailed deadlock information, to monitor and troubleshoot performance issues. You want to achieve this goal by using the minimum amount of administrative effort.
What tool should you use?

• A. Resource Governor
• B. Extended Events
• C. Performance Monitor (SYSMON)
• D. Database Engine Tuning Advisor

설명: (Fast2test 회원만 볼 수 있음)

You administer a SQL Server 2008 instance.
You plan to deploy a new database to the instance. The database will be subject to frequent inserts and
updates.
The database will have multiple schemas. One of the schemas will contain a large amount of read-only
reference data.
You need to design the physical database structure for optimal backup performance.
What should you do?

• A. Create the database by using a single log file and a filegroup that has multiple data files.
• B. Create the database by using a single data file and a single log file.
• C. Create the database by using a single data file and multiple log files.
• D. Create the database by using a single log file and multiple filegroups.

설명: (Fast2test 회원만 볼 수 있음)