Exam 1z0-908 topic 1 question 95 discussion

Actual exam question from Oracle's 1z0-908

Question #: 95
Topic #: 1

You have replication configured, which consists of one master and one slave on different hosts with an asynchronous replication channel between them.
Your goal is to decrease the amount of data that is transferred between these two hosts.
It is confirmed that the slave instance does not need to have data from the example database.
Which replication filter contributes to your goal?

A. on slave: --replicate-wild-ignore=example.%
B. on slave: --replicate-ignore-db=example
C. on master: --replicate-ignore-db=example
D. on master: --binlog-ignore-db=example
E. on slave: --binlog-ignore-db=example

Show Suggested Answer

Suggested Answer: C 🗳️

by Dhanushka at Aug. 2, 2023, 5:56 a.m.

Comments

Submit Cancel

marklv

11 months, 1 week ago

answer is A. Its not B because you can use database1 and still insert into another table on another database. The wild card makes it so if you use another database but insert into this table from another database, it won't happen.

upvoted 2 times

marklv

11 months, 1 week ago

https://www.alibabacloud.com/forum/read-387

upvoted 1 times

...

Dhanushka

1 year ago

Selected Answer: B

For example, if --replicate-ignore-db=nonreplicated is configured on the replica server, the following sequence of statements causes the GRANT statement to be ignored, because the default database nonreplicated is in effect:

upvoted 2 times

marklv

7 months, 4 weeks ago

With B, you can still replicate. For example, use DB2; insert into DB1.table1 values (1); Things in DB1 was still inserted in replication because you were using DB2. ignore db just ignores the base database you are in, not the statement.

upvoted 2 times

...

Exam 1z0-908 All Questions

View all questions & answers for the 1z0-908 exam

Exam 1z0-908 topic 1 question 95 discussion

Comments

marklv

marklv

Dhanushka

marklv

SY0-701