Online Access Free 70-450 Exam Questions

You are a professional level SQL Sever 2008 Database Administrator.
After a regular test, you find that performance degradation is experienced by an instance for the three reasons:
Excessive CPU usage, Server 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?

• A.To finish the task, you should utilize Resource Governor.
• B.To finish the task, you should utilize Performance Monitor (SYSMON).
• C.To finish the task, you should utilize Database Engine Tuning Advisor.
• D.To finish the task, you should utilize Extended Events.

You deploy a new database application to a SQL Server 2008 instance on a server that has 4 processor
cores and 64 GB of RAM. The application uses partitioned tables.
During testing, deadlocks occasionally occur on queries that are attempting to read data.
You find out that the deadlocks are related to the table partitions.
You need to ensure that the application executes without deadlocks for the read queries.
You also need to ensure that dirty reads do not occur.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Disable partition-level lock escalation.
• B.Move the clustered indexes for the partitioned tables to a separate filegroup.
• C.Add additional database files to each partitioned table.
• D.Move each partitioned table to its own filegroup.

You administer a SQL Server 2008 infrastructure.
Your company requires capacity planning information.
You need to design a long-term infrastructure monitoring strategy.
Which two tasks should you include in your design? (Each correct answer presents part of the solution. Choose two.)

• A.Baseline the system before you deploy production databases.
• B.Backup all databases every day.
• C.Review system monitor counters on a regular basis.
• D.Clear the system log and the application log every hour.
• E.Create a maintenance plan that rebuilds indexes every week.

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

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

You are a professional level SQL Sever 2008 Database Administrator.
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.
The least amount of disk space should be utilized by the transaction log.
Which action should you perform to finish the task?

• A.To finish the task, the full-recovery model along with differential backups should be utilized.
• B.To finish the task, hourly database snapshots should be utilized.
• C.To finish the task, the simple-recovery model along with differential backups should be utilized.
• D.To finish the task, the full-recovery model along with transaction log backups should be utilized.