Free Microsoft 70-450 Exam Dumps Questions & Answers

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.  Move each partitioned table to its own filegroup.
• D.  Add additional database files to each partitioned table.

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

You administer a SQL Server 2008 infrastructure . You design a corporate backup and recovery strategy that has to be validated.
You need to ensure the successful recovery of any single database from a catastrophic failure without requiring a backup data center in a different location.
Which three tasks should you include? (Each correct answer presents part of the solution. Choose three.)

• A.  Script SQL login accounts and credentials.
• B.  Store all backup media offsite.
• C.  Document the administrative processes and application access requirements.
• D.  Install all SQL Server instances on a failover cluster.
• E.  Maintain one list of all Windows logins and passwords.

You administer a SQL Server 2008 instance that will host a new database application.
You plan to design the security requirements for the application. Each application user has a unique login to
the SQL Server 2008 server.
The application database contains stored procedures to execute stored procedures in the MSDB database.
The stored procedures in the MSDB database schedule SQLAgent jobs.
You need to ensure that the stored procedures in the MSDB database are executed by using the security
context of the application user.
What should you do?

• A.  Configure the MSDB database to use the TRUSTWORTHY option, and then add each user to the MSDB database.
• B.  Add each user to the public role in the MSDB database.
• C.  Add each user to the db_dtsltduser database role in the MSDB database.
• D.  Configure the new database to use the TRUSTWORTHY option, and then add each user to the MSDB database.

You are a professional level SQL Sever 2008 Database Administrator.
It is reported by the customers that the server performance degraded due to a newly implemented process. Dynamic Management Views is utilized to confirm that no long running queries exist.
The operating system performance data should be correlated with the actual query execution trace, and the least administrative effort should be utilized.
Which action will you perform to finish the task?

• A.  To finish the task, SQL Server Profiler and System Monitor should be utilized.
• B.  To finish the task, Data Collector should be utilized.
• C.  To finish the task, the SQLdiag.exe utility should be utilized.
• D.  To finish the task, SQL Server Profiler and the tracerpt.exe utility should be utilized.