Instantly download 70-450 training test engine

Microsoft 70-450 Exam Overview:

Microsoft 70-450 Exam Syllabus Topics:

Microsoft PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu Sample Questions:

1. You are a professional level SQL Sever 2008 Database Administrator.
A new database will be deployed to the instance.
Regular inserts and updates should be subjected by the database. There will be multiple schemas on the
database.
A great number of read-only reference data should be contained by one of the schemas.
The physical database structure should be designed for optimal backup performance.
Which action should you perform?

A) You should utilize a single log file and multiple filegroups to create the database.
B) You should utilize a single data file and multiple log files to create the database.
C) You should utilize a single log file and a filegroup that has multiple data files to create the database.
D) You should utilize a single data file and a single log file to create the database.

2. You administer a SQL Server 2008 infrastructure.
Developers in your company have rights to author policies. A test server is used to develop and test the
policies.
The Policy-Based Management feature generates SQL Server Agent alerts when a policy is violated.
The developers are able to create and modify policies, but are unable to test policy violation alerts.
You need to grant the necessary permission to the developers to test the policies. You also need to comply
with
the least privilege principle when you grant the permission.
What should you do?

A) Grant the EXECUTE permission on the sys.sp_syspolicy_execute_policy stored procedure to the developers.
B) Add the developers to the sysadmin server role.
C) Grant the ALTER TRACE permission to the developers.
D) Add the developers to the PolicyAdministratorRole role in the MSDB database.

3. You administer a SQL Server 2008 instance named Instance1 at the New York central site. Your company has a sales team to fulfill purchase orders for customer requests.
The sales team uses portable computers to update data frequently in a local database. When the portable computers connect to the central site, the local database must be synchronized with a database named Sales.
You plan to create a replication model to replicate the local database to the Sales database.
The replication model must meet the following requirements:
Data conflicts are handled when multiple users update the same data independently.
The sales team cannot update sensitive data such as product price.
The sales team can synchronize data at scheduled times and on demand also.
You need to identify the best model to replicate data by using minimum development efforts.
What should you do?

A) Use merge replication along with each portable computer that is set up as a subscriber.
B) Use transactional replication along with each portable computer that is set up as a publisher.
C) Use SQL Server Integration Services (SSIS) to push data changes and pull updates to the Sales database along with the SSIS packages, on demand.
D) Use snapshot replication along with each portable computer that is set up as a subscriber.

4. 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, the full-recovery model along with transaction log backups should be utilized.
C) To finish the task, the simple-recovery model along with differential backups should be utilized.
D) To finish the task, hourly database snapshots should be utilized.

5. You are a professional level SQL Sever 2008 Database Administrator.
The solution is log-shipped for high-availability purposes. The data files of the database reside on drive D,
while the transaction log files of the database reside on drive E. A restoring test plan should be
implemented
to satisfy the requirements listed below for the log-shipping solution.
First, the secondary database is brought online in the shortest time.
Secondly, the data is in a consistent state.
Thirdly, the data loss is reduced to the least.
The first step for the recovery test plan should be identified in the event of drive D failure.
Which step should be performed?

A) You should execute the DBCC CHECKDB command along with the REPAIR_REBUILD option against the primary database.
B) You should execute the DBCC CHECKDB command along with the REPAIR_ALLOW_DATA_LOSS option against the primary database.
C) You should perform the tail-log backup of the primary database.
D) You should bring the secondary database online.

Solutions: