Try and practice the latest Microsoft : 70-450 real questions & answers

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 snapshot replication along with each portable computer that is set up as a subscriber.
• C. Use transactional replication along with each portable computer that is set up as a publisher.
• D. Use SQL Server Integration Services (SSIS) to push data changes and pull updates to the Sales database along with the SSIS packages, on demand.

You are a professional level SQL Sever 2008 Database Administrator.
An instance runs on a computer, and the computer has eight quad-core processors and 128-GB RAM. The instance is utilized by four different applications. Not only a low number of CXPACKET waits but also a large number of lazy writer waits are experienced by the instance. The performance of the instance should be optimized.
Which action will you perform to accomplish the goal?

• A. To accomplish the goal, software non-uniform memory access (soft-NUMA) should be configured.
• B. To accomplish the goal, an increase should be configured in the maximum degree of parallelism option.
• C. To accomplish the goal, the Resource Governor should be configured.
• D. To accomplish the goal, the Windows System Resource Manager should be configured.

You administer a SQL Server 2008 infrastructure.
You plan to design a maintenance strategy for a mission-critical database that includes a large table named Orders. The design plan includes index maintenance operations.
You must design the strategy after considering the following facts:
The Orders table in the database is constantly accessed.
New rows are frequently added to the Orders table.
The average fragmentation for the clustered index of the Orders table is less than 2 percent.
The Orders table includes a column of the xml data type.
You need to implement the strategy so that the performance of the queries on the table is optimized.
What should you do?

• A. Exclude the clustered index of the Orders table from scheduled reorganizing or rebuilding operations.
• B. Rebuild the clustered index of the Orders table offline once a month.
• C. Reorganize the clustered index of the Orders table by decreasing the fill factor.
• D. Drop the clustered index of the Orders table.

You administer a SQL Server 2008 infrastructure.
An instance hosts a business-critical database that must be continuously available to the users without data loss. The database includes Filestream data.
You need to implement a high-availability solution for the site.
Which solution should you use?

• A. Database snapshot
• B. Asynchronous database mirroring
• C. Synchronous database mirroring with a witness server
• D. Failover clustering

You administer SQL Server 2008 servers on a single site.
The site contains the following two SQL Server 2008 instances:
An Enterprise Edition server on a server that has a redundant array of independent disks (RAID) 10 disk system
A Standard Edition server on a server that has a RAID 5 disk system
Each instance hosts a single application. You need to recommend a high-availability solution for the site to meet the following business requirements:
The solution can be implemented on the existing systems.
The database is available with minimal downtime.
Data loss is minimal.
There is minimal effect on the existing system.
What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.

• A. Replication
• B. Log shipping
• C. Database snapshot
• D. Failover clustering