Oracle Exam 1Z0-908 Topic 5 Question 69 Discussion

Actual exam question for Oracle's 1Z0-908 exam

Question #: 69
Topic #: 5

[All 1Z0-908 Questions]

Examine this command, which executes successfully on InnoDB Cluster: dba.dropMetadataSchema()

Which two statements are true? (Choose two.)

AGroup Replication will be dissolved and all metadata purged.

BGroup Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

CThe mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

DThe command drops the mysql_innodb_cluster_metadata schema and re-creates it.

EThe mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

FConnections driven by MySQL Router are not affected by the command.

Show Suggested Answer

Suggested Answer: A

by Eun at Dec 10, 2023, 05:50 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-908 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Benedict

1 months ago

Maybe I should just choose the most dramatic-sounding options to be on the safe side. That'll show them I'm a real InnoDB Cluster expert!

upvoted 0 times

...

Tequila

1 months ago

I'm pretty sure the metadata schema is important for the cluster. Dropping it could be disastrous!

upvoted 0 times

Giuseppe

3 days ago

User2: C) The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

upvoted 0 times

...

Curtis

18 days ago

User1: A) Group Replication will be dissolved and all metadata purged.

upvoted 0 times

...

Bernardo

2 months ago

I bet this is a trick question. The command must have some hidden side effects.

upvoted 0 times

Lemuel

10 days ago

I) The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

upvoted 0 times

...

Lemuel

1 months ago

C) The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

upvoted 0 times

...

Lemuel

1 months ago

B) Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

upvoted 0 times

...

Charlena

2 months ago

Wait, didn't we just create that metadata schema? Why would we want to drop it already?

upvoted 0 times

Leila

1 months ago

User3: The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

upvoted 0 times

...

Lashanda

2 months ago

User2: Group Replication will be dissolved and all metadata purged.

upvoted 0 times

...

Kattie

2 months ago

User1: Maybe we made a mistake and need to start over.

upvoted 0 times

...

Aileen

2 months ago

Hmm, this seems tricky. I'll have to think carefully about the consequences of dropping the metadata schema.

upvoted 0 times

...

Socorro

2 months ago

But if the metadata schema is dropped from all reachable members, wouldn't that mean Group Replication will be dissolved?

upvoted 0 times

...

Stephane

2 months ago

I disagree, I believe it's A and D.

upvoted 0 times

...

Socorro

2 months ago

I think the correct answers are C and E.

upvoted 0 times

...