Online Access Free 070-450 Exam Questions

You are a professional level SQL Sever 2008 Database Administrator.
A database is hosted by the instance. You can see the backup strategy utilized by the database from table listed below: A batch process is run on Saturday, and the process lasts from 21:00 hr to 23:00 hr; you find that the batch process takes no effect because certain data is modified some data by a user at 21:05 hr on the same day.

The database should be recovered to its state at the start of the batch process in the shortest time.
Which action will you perform?

• A.The full database backup that was performed on Thursday should be recovered. And then the differential backup that was performed on Friday should be recovered. At last, all transaction logs should be recovered from the time of the differential backup on Friday and should be stopped at 21:00 hr on Saturday.
• B.The full database backup that was performed on Saturday should be recovered.
• C.The full database backup that was performed on Saturday should be recovered. And then all transaction logs should be recovered from the time of the full backup on Saturday and should be stopped at 21:00 hr on Saturday.
• D.The full database backup that was performed on Thursday should be recovered. And then, all transaction logs should be recovered from the time of the full backup on Thursday and should be stopped at 21:00 hr on Saturday.

Your SQL Server 2008 server has only the SQL Server service running. All other SQL Services are disabled.
You have a user named DBReportsUser. You need to restrict DBReportsUser to login only between 17:00 hours and 22:00 hours. You want to achieve this goal by using the minimum amount of administrative effort and the least impact on the Server security.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Use SQL Profiler.
• B.Create a SQL Server Agent job.
• C.Enable login auditing.
• D.Use a logon trigger.

You are a professional level SQL Sever 2008 Database Administrator.
A large financial database is hosted by the instance. The backup strategies listed below are contained by
the database:
First, the performance of a full database backup is implemented once a week.
Secondly, the performance of a differential backup is implemented every day.
Thirdly, the performance of a transaction log backup is implemented every hour.
An end-of-year batch process should be implemented, and the process takes two hours to run.
About five percent of data within the database will be changed by the batch process.
Since you are the technical support, you are required to make sure that the batch operation can be rolled
back
in the shortest time, if the batch process is not approved by the Finance department.
What should you do first before start the batch process?

• A.You should create a database snapshot.
• B.You should create a marked transaction. And then you should perform a transaction log backup.
• C.You should perform a differential backup.
• D.You should record the time before the batch operation. And then you should perform a transaction log

You administer a SQL Server 2008 infrastructure. You plan to design an infrastructure for a new application.
The application has the following requirements:
Users can connect to an instance named SQLSERVER1.
SQLSERVER1 is linked to a server named SQLSERVER2.
SQLSERVER1 and SQLSERVER2 run on different computers.
The SQL Server instances use only Windows authentication.
You need to configure the infrastructure to ensure that the distributed queries are executed in the Windows security context of the login.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

• A.Register a server principal name (SPN) for SQLSERVER1 and SQLSERVER2.
• B.Ensure that the two instances use the same Windows account for the Microsoft SQL Service. Create the link so that each account uses the current security context.
• C.Use the local computer account as a service account for SQLSERVER1 and SQLSERVER2.
• D.Configure all servers to use the Shared Memory network protocol.
• E.Create a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the impersonate option.

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