ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-997-20 All Questions

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

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

Actual exam question from Oracle's 1z0-997-20
Question #: 19
Topic #: 1
[All 1z0-997-20 Questions]

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 Hide Answer
Suggested Answer: B 🗳️
by fhoyos at Nov. 18, 2020, 4:37 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
i_maddog_i
Highly Voted 3 years, 3 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, 2 months ago
Active Data Guard is not cost-effective...
upvoted 2 times
sortbox
3 years, 2 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 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, 2 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
3 years, 11 months ago
you cannot take backup from standby side until it becomes primary
upvoted 1 times
kevzeg
3 years, 11 months ago
AFAIK Active Data Guard supports backup from standby database.
upvoted 5 times
FPM
1 year, 9 months 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 ago
Namaste My opinion here would be D
upvoted 1 times
...
AJ22
3 years 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 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, 1 month 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, 1 month ago
Sure B. No data loss
upvoted 2 times
...
EaglEyeZ
3 years, 1 month ago
B is the correct option in this scenario
upvoted 1 times
...
JArafat
3 years, 2 months ago
you cant take backup from a standby database until it become primay.
upvoted 1 times
...
Bibace
3 years, 2 months ago
Selected Answer: B
https://www.oracle.com/technetwork/database/availability/hybrid-dg-to-oci-5444327.pdf
upvoted 3 times
...
Desong
3 years, 2 months ago
absolutely B.
upvoted 2 times
...
skywalker
3 years, 9 months 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 ago
C is correct answer.
upvoted 1 times
...
ankit89
4 years, 2 months ago
D is the answer
upvoted 2 times
...
sticks4
4 years, 2 months ago
I'm now thinking 'D' also DG
upvoted 2 times
...
bpage
4 years, 2 months ago
C https://docs.cloud.oracle.com/en-us/iaas/Content/Database/Tasks/backingupOS.htm
upvoted 2 times
fhoyos
4 years, 2 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, 2 months ago
I think D option is correct
upvoted 1 times
fhoyos
4 years, 2 months ago
Answer is C
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago