Online Access Free 70-450 Exam Questions

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 should be excluded from scheduled reorganizing or rebuilding operations.
• B.The clustered index of the Orders table offline should be rebuilt once a month.
• C.The clustered index of the Orders table should be reorganized by reducing the fill factor.
• D.The clustered index of the Orders table should be dropped.

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.156-KB
• B.8-KB
• C.32-KB
• D.64-KB

You are a professional level SQL Sever 2008 Database Administrator.
It is on a four-processor, quad-core server. CPU pressure is regularly experienced by the server. An extremely large mission-critical database is consisted by the instance, and it is utilized constantly. The online index rebuilds should not occupy all available CPU cycles.
From the following four configurations, which one should you utilize?

• A.You should utilize max degree of parallelism.
• B.You should utilize optimize for ad hoc workloads.
• C.You should utilize affinity mask.
• D.You should utilize affinity I/O mask.

You are a professional level SQL Sever 2008 Database Administrator.
A mission-critical database is shared by the five sites.
According to the business requirements, the users at each site should be enabled to access and change data on all sites with minimal latency. In addition, data loss should be minimized if a server fails. A high-availability solution should be designed, and the business requirements should be satisfied.
Which action should be included in your solution?

• A.Failover clustering should be included.
• B.Log shipping to servers at two of the sites to offer read-only replications of data should be included.
• C.Asynchronous database mirroring without a witness server should be included.
• D.Peer-to-Peer replication should be included.

You are configuring a new SQL Server installation.
The SQL Server instance will be used for both online analytical processing (OLAP) and relational data. The data in the server is accessed frequently. You can configure the services, startup type, and accounts used by the services that run on the server according to the following table:

You want to raise the level of security on the server. You need to minimize the surface area for potential attacks on the server.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

• A.Change the Startup type property for all the services to Manual.
• B.Create three different non-administrative local user accounts and assign them to each of the services.
• C.Change the Startup type property for all the services to Disabled.
• D.Create a single non-administrative local user account and assign it to each of the services.