| Exam Code/Number: | 70-450Join the discussion |
| Exam Name: | PRO:MS SQL Serv 08,Design,Optimize, and Maintain DB Admin Solu |
| Certification: | Microsoft |
| Question Number: | 125 |
| Publish Date: | Oct 16, 2026 |
|
Rating
100%
|
|
You administer four SQL Server 2008 instances. Each instance hosts a single database application.
You plan to migrate all four instances to a new SQL Server failover cluster. The four instances are configured as shown in the following table.
Instance Name Configuration:
Instance 1 8 processors that have 16-GB RAM Instance 2 4 processors that have 8-GB RAM Instance 3 2 processors that have 16-GB RAM Instance 4 4 Processors that have 8-GB RAM
The four instances are fully optimized and have no spare CPU cycles or extra memory. The new cluster will host all four databases on a single virtual cluster IP address. You need to ensure that the new cluster is configured to handle the workload of all the database applications by using the minimum amount of hardware resources.
Which cluster configuration should you use?
You administer SQL Server 2008 instances at three sites.
All sites share a mission-critical database. The business requirements specify that users at each site must be able to perform the following tasks:
Access and modify data on all sites with minimal latency.
Minimize data loss in the event of a server failure.
You need to provide a high-availability solution that meets the business requirements.
Which solution should you implement?
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?
You deploy a new database application to a SQL Server 2008 instance on a server that has 4 processor
cores and 64 GB of RAM. The application uses partitioned tables.
During testing, deadlocks occasionally occur on queries that are attempting to read data.
You find out that the deadlocks are related to the table partitions.
You need to ensure that the application executes without deadlocks for the read queries.
You also need to ensure that dirty reads do not occur.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
You are a professional level SQL Sever 2008 Database Administrator.
A SQL Server 2008 instance at the New York central site is managed by you, and it is called Ins01.
There is a sales team in your company, and their task is to finish purchase orders for customer requests.
The sales team updates data regularly in a local database by utilizing their portable computers.
When the central site is connected by portable computers, a database named Sales will be synchronized
with
the local database. A duplication model will be created to duplicate the local database to the Sales
database.
The requirements listed below should be satisfied by the duplication model:
First, when the same data is updated by multiple users independently, there should be no data conflicts.
Secondly, sensitive data such as product price cannot be updated by the sales team.
Thirdly, the data should be synchronized by the sales team not only at scheduled times but also on demand.
The best model should be identified to have data duplicated, and you should be reduced the development efforts to the least.
Which action will you perform?
