Exam 1z0-997-20 All Questions

View all questions & answers for the 1z0-997-20 exam

Exam 1z0-997-20 topic 1 question 19 discussion

Actual exam question from Oracle's 1z0-997-20

Question #: 19
Topic #: 1

A large London based eCommerce company is running Oracle DB Systems Virtual Machine RAC database on Oracle Cloud Infrastructure (OCI) for their eCommerce application in the uk-london-1 region. They are currently taking automatic backups of the database, as configured during the database provisioning activity. They are launching a new product soon, which is expected to sell in large quantities all over the world.
The application architecture should have minimal cost, no data loss, no performance impacts during the database backup windows and should have minimal downtime.
What is the most efficient and cost-effective mechanism of modifying the database deployment architecture to meet these application goals? (Choose the best answer.)

A. Launch a new VM RAC database in another availability domain, launch a compute instance, deploy Oracle GoldenGate on it and then configure it to replicate the data from the eCommerce Database over to the new VM RAC database using GoldenGate. Take backups from the new VM RAC database.
B. Turn off automatic backups from the eCommerce database, implement Oracle Active Data Guard with the standby database deployed on another availability domain, and take backups from the standby database.
C. Launch a new VM RAC database in another availability domain, launch a compute instance, deploy Oracle GoldenGate on it and then configure bi-directional replication from the eCommerce Database over to the new VM RAC database using GoldenDate. Take backup from the new VM RAC database.
D. Turn off automatic backups from the eCommerce database, implement Oracle Data Guard with the standby database deployed on another availability domain, take backups from the standby database.

Show Suggested Answer

Suggested Answer: B 🗳️

by fhoyos at Nov. 18, 2020, 4:37 a.m.

Comments

Submit Cancel

i_maddog_i

Highly Voted 3 years, 7 months ago

I'd say B Active Data Guard extends Data Guard capabilities by providing advanced features for data protection and availability as well as offloading read-only workload and fast incremental backups from a production database. Page. 5 https://www.oracle.com/technetwork/database/availability/hybrid-dg-to-oci-5444327.pdf

upvoted 6 times

Minghon

3 years, 6 months ago

Active Data Guard is not cost-effective...

upvoted 2 times

sortbox

3 years, 6 months ago

AFAIK cost effectiveness here is not to use symmetric RAC in another AD. As it was already mentioned below, RAC on VM has ADG licensed. Also ADG has extra benefits like offloading, auto-block repair and fast incremental backups

upvoted 4 times

...

IT_Thinker

3 years, 4 months ago

Active Data Guard starts at $11,500!!! You will lose respect if your it manager asks you for a cost effective solution and you propose spending $$$ when 'Data Guard' (answer D) will do the job for FREE. Golden Gate is the most expensive option. ADG is just an extension of Data Guard and is used primarily for running reports on NON production DBs, so as not to affect performance on the production systems/DBs. This way the bean counters can run as many reports as they want without affecting production servers or having to wait for non peak hours, blah, blah, blah...

upvoted 2 times

...

adesmaster

Highly Voted 4 years, 6 months ago

I'd say B as the company has a RAC (and then a Extreme Performance license that includes Active Data Guard)

upvoted 5 times

bilegt

4 years, 3 months ago

you cannot take backup from standby side until it becomes primary

upvoted 1 times

kevzeg

4 years, 3 months ago

AFAIK Active Data Guard supports backup from standby database.

upvoted 5 times

FPM

2 years, 1 month ago

True, it can: https://docs.oracle.com/en/database/oracle/oracle-database/19/haovw/ha-features.html#GUID-F4C51EAE-856F-4564-8C68-F3BD622AABEE

upvoted 1 times

...

Saidasa

Most Recent 3 years, 4 months ago

Namaste My opinion here would be D

upvoted 1 times

...

AJ22

3 years, 4 months ago

The question being asked is "What is the most efficient and cost-effective mechanism of modifying the database deployment architecture to meet these application goals? " Most cost effective also modifying the database deployment architecture. So the answer can modify the deployment. A. has Golden Gate No cost effective B. has active dataguard No cost effective C. RAC and Golden Gate No Cost effective D. is the answer.

upvoted 2 times

...

Daredevilforu

3 years, 4 months ago

Answer C: Active Data Guard or GoldenGate are used for disaster recovery when fast recovery times or additional levels of data protection are required. And offload queries and backup to standby system. Oracle GoldenGate to support a disaster recovery site is to have a working bi-directional data flow, from the primary system to the live-standby system and vice versa. DataGuard and Automatic Backup You can enable the Automatic Backup feature on a database with the standby role in a Data Guard association. However, automatic backups for that database will not be created until it assumes the primary role.

upvoted 1 times

...

Scipio88

3 years, 5 months ago

I have seen other discussions say it's Option C. Since the customer uses RAC, you would want RAC solution.

upvoted 1 times

...

Oraclemystic

3 years, 5 months ago

Sure B. No data loss

upvoted 2 times

...

EaglEyeZ

3 years, 5 months ago

B is the correct option in this scenario

upvoted 1 times

...

JArafat

3 years, 6 months ago

you cant take backup from a standby database until it become primay.

upvoted 1 times

...

Bibace

3 years, 6 months ago

Selected Answer: B

https://www.oracle.com/technetwork/database/availability/hybrid-dg-to-oci-5444327.pdf

upvoted 3 times

...

Desong

3 years, 6 months ago

absolutely B.

upvoted 2 times

...

skywalker

4 years, 1 month ago

D... coz is using Data Group. Cannot be C as it involve GoldenGate which is not cost effective..

upvoted 2 times

...

Rohit_B

4 years, 4 months ago

C is correct answer.

upvoted 1 times

...

ankit89

4 years, 6 months ago

D is the answer

upvoted 2 times

...

sticks4

4 years, 6 months ago

I'm now thinking 'D' also DG

upvoted 2 times

...

bpage

4 years, 6 months ago

C https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm

upvoted 2 times

fhoyos

4 years, 6 months ago

You are right.. Data Guard - You can enable the Automatic Backup feature on a database with the standby role in a Data Guard association. However, automatic backups for that database will not be created until it assumes the primary role.

upvoted 1 times

...

fhoyos

4 years, 6 months ago

I think D option is correct

upvoted 1 times

fhoyos

4 years, 6 months ago

Answer is C

upvoted 1 times

...