MySQL 8.0 OCP認證考試原題題庫整理(CUUG內部資料)-第10題
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢MySQL 8.0 OCP認證考試原題題庫整理(CUUG內部資料)-第10題
Choose the best answer.
Examine these commands, which execute successfully on the ic1 host:
mysqlsh> dba.createCluster( 'cluster1' , {memberWeight:35})
mysqlsh> var mycluster = dba.getCluster ()
mysqlsh> mycluster.addInstance ( 'ic@ic2' , {memberWeight:25})
mysqlsh> mycluster.addInstance( 'ic@ic3' , {memberWeight:50})
Now examine this configuration setting, which is the same on all nodes:
group_replication_consistency=BEFORE_ON_PRIMARY_FAILOVER
Which statement is true if primary node ic1 fails?
A) Node ic2 becomes the new primary and existing transactions are considered stale and rolled back.
B) Node ic3 becomes the new primary and existing transactions are considered stale and rolled back.
C) Node ic3 becomes the new primary and is ignored until any backlog of transactions is completed.
D) Only two nodes remain so the election process is uncertain and must be done manually.
E) Node ic2 becomes the new primary and is ignored until any backlog of transactions is completed.