Online Access Free 70-450 Exam Questions

You are a professional level SQL Sever 2008 Database Administrator.
They are respectively named Ins01, Ins02, Ins03 and Ins04. A single database application is hosted by each instance. All four instances should be removed to a new SQL Server failover cluster. You can see the configuration of the four instances from the table listed below:

All the four instances are sufficiently optimized, and there are no spare CPU cycles or extra memory in
the instances.
All four databases will be hosted by the new cluster on a single virtual cluster IP address.
Since you are the technical support, you are required to set the new cluster to handle the workload of all the database applications with the least amount of hardware resources.
From the four cluster configuration, which one should be utilized?

• A.Two-node active/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory are contained by each node.
• B.Four-node active/active/active/passive cluster should be utilized and a minimum of 18 processors and a 50-GB memory are contained by each node.
• C.Four-node active/active/active/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory are contained by each node.
• D.Two-node active/passive cluster should be utilized and a minimum of 18 processors and a 50-GB memory are contained by each node.

You administer a SQL Server 2008 instance.
The instance is using a 32-bit version on a Windows Server 2008 64-bit server. The awe enabled option is
enabled.
The instance will experience a predictable increase in query activity.
You plan to ascertain the appropriate time when the migration of the databases to a 64-bit SQL Server 2008
server
on the same hardware is beneficial.
You need to identify a data collector type that provides the appropriate information.
Which collector should you use?

• A.Performance Counters collector
• B.SQL Trace collector
• C.T-SQL Query collector
• D.Query Activity collector

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

You are a professional level SQL Sever 2008 Database Administrator.
Two SQL Server 2008 instances are contained by the site. One is an Enterprise Edition server, and it is on a server that has a redundant array of independent disks (RAID) 10 disk system The other is a Standard Edition server, and it is on a server that has a RAID 5 disk system. A single application is hosted by each instance. A high-availability solution should be recommended for the site to satisfy the business requirements listed below:
First, the solution can be implemented on the current systems.
Secondly, the database is available with least downtime.
Thirdly, Data loss should be cut to the least.
Fourthly, the existing system should be with least impact.
Which solutions should be utilized to finish the task? (Choose more than one)

• A.To finish the task, Replication should be utilized.
• B.To finish the task, Log shipping should be utilized.
• C.To finish the task, Failover clustering should be utilized.
• D.To finish the task, Database snapshot should be utilized.

You administer a SQL Server 2008 instance for your company. Your company has a team of database administrators.
A team of application developers create SQL Server 2008 Integration Services (SSIS) packages on the test server in a shared project. One of the packages requires a fixed cache file. On completion of development, the packages will be deployed to the production server.
Only the database administrators can access the production server.
You need to ensure that the application developers can deploy the project successfully to the production server.
What should you do?

• A.Use the Import and Export Wizard to save packages.
• B.Create an indirect package configuration for all packages.
• C.Create a direct package configuration for each package.
• D.Create a deployment utility for the SSIS project.