Get real 070-450 exam questions for better preparation

You are a professional level SQL Sever 2008 Database Administrator.
A maintenance strategy should be designed for a mission-critical database, and a large table named Orders is contained by the database. Index maintenance operations are contained in the design plan. When you design the strategy, the facts listed below should be taken into consideration.
First, the users continuously access to the Orders table in the database.
Secondly, a column of the xml data type is contained by Orders table.
Thirdly, the new rows are regularly added to the Orders table.
Fourthly, the average fragmentation for the clustered index of the Orders table is no more than 2
percent.
A strategy should be designed to have the performance of the queries on the table optimized.
Which action will you perform?

• A. The clustered index of the Orders table offline should be rebuilt once a month.
• B. The clustered index of the Orders table should be excluded from scheduled reorganizing or rebuilding operations.
• C. The clustered index of the Orders table should be dropped.
• D. The clustered index of the Orders table should be reorganized by reducing the fill factor.

You administer a SQL Server 2008 instance.
The instance hosts a database that is used by a Web-based application. The application processes 15,000 transactions every minute. A table in the database contains a column that is used only by the application. This column stores sensitive data.
You need to store the sensitive data in the most secure manner possible.
You also need to ensure that you minimize the usage of memory space and processor time.
Which encryption type should you use?

• A. Symmetric key encryption
• B. Transparent data encryption
• C. Asymmetric key encryption
• D. Certificate-based encryption

You administer a SQL Server 2008 instance.
The instance is one of three servers in a peer-to-peer transactional replication topology.
The publication contains a table named Orders. The Orders table contains 200 GB of data
across multiple partitions. A batch process bulk loads 10 GB of data to the Orders table periodically.
You need to design a replication strategy to minimize latency.
What should you do?

• A. Explanation/Reference:
  ---Jeff---
• B. Configure the Distributor agent to change the commit batch threshold.
• C. Configure the Distributor agent to replicate transactions continually.
• D. Disable the Distributor agent. Use the BULK INSERT command in the Orders table. Reinitialize the publication.
• E. Use the BULK INSERT command in multiple staging tables. Switch partitions into the Orders table.

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 back up all databases on the secondary instance.
• B. To achieve the goal, you should utilize the WITH NORECOVERY option to back up the tail of the transaction log of primary databases.
• C. To achieve the goal, you should replicate all log shipping network shares to the secondary instance.
• D. To achieve the goal, you should redirect client computers to the secondary instance.
• E. 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.

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 a filegroup that has multiple data files to create the database.
• B. You should utilize a single log file and multiple filegroups to create the database.
• C. You should utilize a single data file and multiple log files to create the database.
• D. You should utilize a single data file and a single log file to create the database.