单选题Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）A MySQL ReplicationB Distributed Replication Block DeviceC Windows Server Failover ClusteringD MySQL Cluster

第1题：

第2题：

An enterprise has three nodes： -Node ’A’ is a production database， -Node ’B’ is a production  Application server， and -Node ’C’ is a test and development node. Node ’C’ is used by six programmers to develop and the production application as business critical and would like to make it highly available with HACMP. Application development and testing is not business critical.  Which of the following describes the best solution？（）  

• A、 There is not an adequate solution because HACMP should not be configured in this environment without a dedicated standby node.
• B、 Nodes ’A’ and ’B’ should be configured in a cluster with mutual fallover of two cascading resource groups to provide both nodes will deliver acceptable response time with both resource groups.
• C、 Nodes ’A’ and ’C’ should be configured in one cluster， and Nodes ’B’ and ’C’ in another cluster to prevent both the database and application server from falling over to Node ’C’ at the same time.
• D、 Nodes ’A’， ’B’， and ’C’ should be configured in a cluster with Node ’C’ the hot standby for both the database and application server resource groups. Workload Manager （WLM） must be configured on database and application developers from over utilizing the CPU resources.

第3题：

第4题：

A customer needs to implement a Highly Available solution for JMS that has a primary data center  and a backup. Which three steps would you perform when designing your solution?（）

• A、Store Transaction Logs in a database and use Database stores for JMS to make replication  between sites easier.
• B、Use file based Transaction Logs and JMS stores and implement a separate replication solution  for files in addition to database in case database replication fails.
• C、Implement Oracle RAC at each site to provide a highly available solution within each datacenter.
• D、Configure Whole Server Migration to migrate WebLogic Managed Servers from the primary to the secondary site.
• E、Configure Automatic Service Migration for JMS high availability within a datacenter.

第5题：

Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?（）

• A、It implements High Availability by using the .NET Connector's' load balancing capabilities
• B、It is shared-nothing architecture
• C、It is provided by means of IP- level disk replication
• D、It relies on the shared disk architecture being visible to both servers

第6题：

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. SQL Server 2008 servers on a single site are managed by you. Two SQL Server 2008 instances are contained by the site. One is an Enterprise Edition server, and it is on a server that has a redundant array of ndependent disks (RAID) 10 disk system. The other is a Standard Edition server, and it is on a server that has a RAID 5 disk system. A single application is hosted by each instance. A high-availability solution should be recommended for the site to satisfy the business requirements listed below. First, the solution can be implemented on the current systems. Secondly, the database is available with least downtime. Thirdly, Data loss should be cut to the least. Fourthly, the existing system should be with least impact.    Which solutions should be utilized to finish the task?（）

• A、To finish the task, Log shipping should be utilized. 
• B、To finish the task, Failover clustering should be utilized.
• C、To finish the task, Replication should be utilized. 
• D、To finish the task, Database snapshot should be utilized.

第7题：

A customer with three Windows servers wants to create a shared storage array. One server runs a200 GB Oracle database with high transaction rates. The second server is a file server with 3 TBof data and the third server is a mail server with 150 GB of storage. The key customer decisionmaker has only purchased EMC CX storage products in his previous employment. Cost is a keyconsideration. From the following which is a key feature that could convince the customer topurchase a DS3500 over an EMC CX storage system?（）

• A、 SATA and SAS 2.0 disk drive technology can be mixed in different enclosures 
• B、 nearline SAS 2.0 and SAS 2.0 disk drive technology can be mixed in the same enclosure
• C、 SATA disk drive technology can provide both the high transaction rates and large drive sizesneeded for this solution 
• D、 SAS 2.0 disk drive technology can provide both the high transaction rates and large drive sizesneeded for this solution

第8题：

第9题：

Which High Availability solution can provide a consistent, time-delayed (for example, one hour) snapshot of the live production database?（）

• A、MySQL Replication
• B、Distributed Replication Block Device
• C、Windows Server Failover Clustering
• D、MySQL Cluster

第10题：

You use—login-path to access a MySQL server on a Linux installation. Which statement is true about the – login-path option that is created by using mysql_config_editor?（）

• A、All system users have access to the MySQL server via—login path local
• B、login-path can be used only for MySQL servers running on a local machine
• C、login-path allows you to provide login credentials without passing clear text passwords on the command line
• D、When using – login-path to connect to a remote MySQL server, the remote server version must be 5.6 or later