Both technologies guarantee an identical copy of data on the secondary node
Only MySQL can maintain a time-delayed copy of data on the secondary node
Both technologies use the TCP/IP stack as their primary transmission medium
DRBD uses shared-disk technology
第1题:
A.The master.info and relay.info files
B.The relay log files
C.The relay index file
D.Mysql.slave_master_info table
E.Mysql.slave_relay_log_info table
F.Mysql.slave_worker_info table
第2题:
A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_current
B.Using the statement RESET PERFORMANCE CACHE
C.Using the statement FLUSH PERFORMANCE CACHE
D.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_current
E.Disabling and re-enabling all instruments
F.Restarting Mysql
第3题:
A.Both technologies guarantee an identical copy of data on the secondary node
B.Only MySQL can maintain a time-delayed copy of data on the secondary node
C.Both technologies use the TCP/IP stack as their primary transmission medium
D.DRBD uses shared-disk technology
第4题:
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql> CALL prepare_db ( ); Mysql> LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql> SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?()
第5题:
A. Data is accessed using NFS or CIFS.
B. Data is accessed at the block level.
C. NAS is referred to as captive storage.
D. Storage devices can be shared between users.
E. A NAS implementation is not as fast as a DAS implementation.
第6题:
A.Mysql NDB Cluster
B.Mysql Replication
C.Distributed Replicated Block Device (DRBD) and Mysql
D.Windows Cluster and Mysql
E.Solaris Cluster and Mysql
第7题:
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements.You run the following statements in the mydb database: Mysql> CALL prepare_db ( );Mysql> LOAD DATA INFILE ‘/tmp/data.cav‘ INTO TABLE mytable; Mysql> SHOW TABLES;How many events are added to the audit log as a result of the preceding statements?()
A.12; only top-level statements and stored procedure events are logged
B.111; top-level statements and all lower-level statements are logged
C.3; only the top-level statements are logged
D.102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
第8题:
A.MySQL Replication
B.Distributed Replication Block Device
C.Windows Server Failover Clustering
D.MySQL Cluster
第9题:
A manufacturing company is using ProtecTIER TS7610 appliances in a spoke and hubconfiguration. ProtecTIER’s TS7610 replication technology at the hub will perform the followingaction on the replicated data being received:()
第10题:
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for a financial services company. Replication is configured between two SQL Server 2005 computers, and the servers are respectively named SQL1 and SQL2. Real-time transactional data is stored by the SQL1. And SQL2 is utilized for reporting. The data on SQL01 should not be changed by SQL2. The publication contains a large amount of data. Since you are the database administrator, you need to make sure that data is replicated from SQL1 to SQL2 in as near real-time as possible to confirm accurate reporting during replication. In addition, you need to make sure that this data is replicated securely. Which action should be performed?()