Free Microsoft 070-450 Exam Dumps Questions & Answers

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.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.
• B.Two-node 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/active cluster should be utilized and a minimum of 9 processors and a 25-GB memory are contained by each node.

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named
Wiikigo.
There is a team of database administrators in your company.
SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared
project by a team of application developers. A fixed cache file is required by one of the packages.
The company will deploy the packages to the production server on completion of development.
The production server is available only to the database administrators.
Since you are the technical support, you need to confirm that the project can be deployed
successfully to the production server by the application developers.
Which action will you perform to achieve the goal?

• A.To achieve the goal, the Import and Export Wizard should be utilized to save packages.
• B.To achieve the goal, a direct package configuration should be created for each package.
• C.To achieve the goal, an indirect package configuration should be created for all packages.
• D.To achieve the goal, a deployment utility should be created for the SSIS project.

You administer a SQL Server 2008 infrastructure.
A financial application uses several instances across multiple servers. The majority of queries require distributed transactions across all servers.
The application administrator reports that the application experiences excessive deadlocks.
You need to design a data collector type that provides the appropriate information for remote servers.
What collector should you use?

• A.A custom Query collector that uses WMI
• B.T-SQL Query collector
• C.Query Activity collector
• D.Performance Counters collector

You are designing a database solution by using SQL Server 2008.
The database has a large number of tables that have columns that contain sensitive data. The sensitive data must be protected.
You need to choose an encryption strategy that has the minimum effect on the performance of the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Use Bitlocker Encryption.
• B.Use Cell-Level Encryption.
• C.Use Transparent Data Encryption (TDE).
• D.Use Encrypting File System.

You are a professional level SQL Sever 2008 Database Administrator.
A new database application is hosted by the instance. The data security strategy should be designed for the application. The data should be duplicated to another instance of SQL Server 2008 by utilizing the Snapshot duplication.
Since you are the technical support of the company, you should make sure that all stored data should be
encrypted,
and the minimum amount of administrative effort should be utilized.
Which action will you perform?

• A.Transparent data encryption should be enabled for the Publisher, Distribution, and Subscriber databases
• B.Certificate-based encryption should be enabled for the Publisher, Distribution, and Subscriber databases.
• C.Transparent data encryption for the MSDB database should be enabled on the two instances.
• D.Encrypted connections should be enabled between the instances.