70-450 무료 덤프문제 온라인 액세스

You are a professional level SQL Sever 2008 Database Administrator.
There is a database in the instance, and the day-to-day business of your company requires the database. When reports are executed, slow response time is experienced by Users.
A performance monitoring strategy will be implemented by you so as to have three aspects of data captured and stored:
Blocking and deadlock information
Executed Transact-SQL statements
Query activity and Counters for disk, CPU,and memory.
You are required to utilize the least amount of administrative effort to implement the monitoring process.
Which action will you perform to finish the task?

• A.To finish the task, the data collector should be utilized.
• B.To finish the task, the System Monitor counter log trace should be utilized.
• C.To finish the task, the client-side profiler trace should be utilized.
• D.To finish the task, the dynamic management views should be utilized.

You administer a SQL Server 2008 infrastructure.
Several production databases use Transparent database encryption.
You perform full database backups of the production databases as part of your backup strategy.
You need to ensure that the database backups can be restored on another SQL Server 2008 instance if the original host server fails.
What should you do?

• A.Back up the server master key.
• B.Back up the database master key.
• C.Back up the resource database.
• D.Ensure that the instances use the same service account.

You are a professional level SQL Sever 2008 Database Administrator.
The largest table in a database is partitioned into four equal-sized parts.
The first two partitions are seldom queried, while the third partition is regularly queried by several reports. Meanwhile, the fourth partition is heavily queried and regularly modified.
The disk space of the table should be cut to the least and the query performance should be with the least impact.
What will you do? (Choose more than one.)

• A.PAGE compression should be enabled for the first two partitions.
• B.PAGE compression should be enabled for the last partition.
• C.ROW compression should be enabled for the third partition.
• D.ROW compression should be enabled for the last partition.
• E.PAGE compression should be enabled for the third partition.
• F.ROW compression should be enabled for the first two partitions.

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 corporate backup and recovery strategy that has to be validated is designed.
You are required to make sure that any single database can be restored successfully from a severe failure, and during the restoration, a backup data center should not be required in a different location.
Which three actions should be contained by your solution? (Choose more than one)

• A.All SQL Server instances should be installed on a failover cluster.
• B.The administrative processes and application access requirements should be documented.
• C.SQL login accounts and credentials should be scripted.
• D.All backup media offsite should be stored.
• E.One list of all Windows logins and passwords should be sustained.

You are a professional level SQL Sever 2008 Database Administrator.
A new database application is hosted by the instance. The data security strategy should be designed for the application. The data should be duplicated to another instance of SQL Server 2008 by utilizing the Snapshot duplication.
Since you are the technical support of the company, you should make sure that all stored data should be
encrypted,
and the minimum amount of administrative effort should be utilized.
Which action will you perform?

• A.Transparent data encryption for the MSDB database should be enabled on the two instances.
• B.Certificate-based encryption should be enabled for the Publisher, Distribution, and Subscriber databases.
• C.Transparent data encryption should be enabled for the Publisher, Distribution, and Subscriber databases
• D.Encrypted connections should be enabled between the instances.