Online Access Free 70-450 Practice Test

You administer a SQL Server 2008 infrastructure.
You implement log shipping for several databases on three SQL Server instances. The logs are shipped to a fourth SQL Server instance. You plan a manual failover.
You need to ensure that the database applications use the secondary server after failover. You also need to ensure that users can access the most recent data.
Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

• A.Redirect client computers to the secondary instance.
• B.Copy all log shipping network shares to the secondary instance.
• C.Apply any unapplied transaction log backups in sequence to each secondary database by using the WITH RECOVERY option on the last log.
• D.Back up the tail of the transaction log of primary databases by using the WITH NORECOVERY option.
• E.Back up all databases on the secondary instance.

You administer a SQL Server 2008 infrastructure.
You plan to deploy a new SQL Server 2008 multi-node failover cluster. The failover cluster uses a storage
area network (SAN)
that will use redundant array of independent disks (RAID) level 5.
You need to format the logical unit numbers (LUNs) for optimal performance of the database data files.
Which of the following is the best allocation unit size you should use?

• A.64-KB
• B.8-KB
• C.156-KB
• D.32-KB

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 Encrypting File System.
• D.Use Transparent Data Encryption (TDE).

You are a professional level SQL Sever 2008 Database Administrator.
Log shipping should be implemented for several databases on three SQL Server instances. The logs are
migrated
to a fourth SQL Server instance. A manual failover will be implemented.
You need to ensure that the database applications utilize the secondary server after failover.
Since you are the technical support, you are required to confirm that the latest data should be available to
users.
Which actions should you perform to achieve the goal? (Choose more than one)

• A.To achieve the goal, you should utilize the WITH NORECOVERY option to back up the tail of the transaction log of primary databases.
• B.To achieve the goal, you should replicate all log shipping network shares to the secondary instance.
• C.To achieve the goal, you should utilize the WITH RECOVERY option on the last log to apply any unapplied transaction log backups in sequence to each secondary database.
• D.To achieve the goal, you should back up all databases on the secondary instance.
• E.To achieve the goal, you should redirect client computers to the secondary instance.

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo.
A 32-bit version is utilized by the instance on a Windows Server 2008 64-bit server. You activate the awe enabled option. A predictable increase in query activity will be experienced by the instance. You are required to figure out the most proper and beneficial time to have the databases migrated to a 64-bit SQL Server 2008 server on the same hardware.
A data collector type that proper information is provided should be identified.
What kind of collector should you utilize?

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