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.
