exam questions

Exam Professional Cloud Database Engineer All Questions

View all questions & answers for the Professional Cloud Database Engineer exam

Exam Professional Cloud Database Engineer topic 1 question 89 discussion

Actual exam question from Google's Professional Cloud Database Engineer
Question #: 89
Topic #: 1
[All Professional Cloud Database Engineer Questions]

Your organization is migrating 50 TB Oracle databases to Bare Metal Solution for Oracle. Database backups must be available for quick restore. You also need to have backups available for 5 years. You need to design a cost-effective architecture that meets a recovery time objective (RTO) of 2 hours and recovery point objective (RPO) of 15 minutes. What should you do?

  • A. 1 Create the database on a Bare Metal Solution server with the database running on flash storage.
    2. Keep a local backup copy on all flash storage.
    3. Keep backups older than one day stored in Actifio OnVault storage.
  • B. 1 Create the database on a Bare Metal Solution server with the database running on flash storage.
    2. Keep a local backup copy on standard storage.
    3. Keep backups older than one day stored in Actifio OnVault storage.
  • C. 1. Create the database on a Bare Metal Solution server with the database running on flash storage.
    2. Keep a local backup copy on standard storage.
    3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket.
  • D. 1. Create the database on a Bare Metal Solution server with the database running on flash storage.
    2. Keep a local backup copy on all flash storage.
    3. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an Archive Storage bucket.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
nanay
6 days, 21 hours ago
Selected Answer: B
Create the database on a Bare Metal Solution server with the database running on flash storage. Keep a local backup copy on standard storage. Keep backups older than one day stored in Actifio OnVault storage.
upvoted 1 times
...
james2033
7 months, 1 week ago
Selected Answer: D
Bare Metal --> RMAN
upvoted 2 times
...
whoosh
10 months, 2 weeks ago
Selected Answer: B
Option B is correct There are two activities: Manage incremental backup (transaction log) and manage obsolete backup (older than retention time to another backup storage (archival)). Option B make as actifio as tool to organize this two activities while Option D make RMAN as tools to organize this to activities. actifio have feature like “Incremental-forever” backups" and store in OnVault storage which is official standard for actifio and actifio in gcp which is very fast compare to option D (RMAN). RMAN will need more than 2 hours to do recovery for 50 TB.
upvoted 2 times
...
Jay_Krish
11 months, 3 weeks ago
Selected Answer: D
Keeping local storage on flash drive would meet the requirement for RTO. And moving older backups to Archival storage is the cost-effective option.
upvoted 4 times
...
Pime13
12 months ago
Selected Answer: D
https://cloud.google.com/backup-disaster-recovery/docs/concepts/backupdr-for-oracle#oracle_backup_apis
upvoted 4 times
...
learnazureportal
1 year, 1 month ago
correct answer is C. Option C aligns with the requirements for performance, cost-effectiveness, and long-term data retention while meeting the RTO and RPO objectives.
upvoted 3 times
...
pico
1 year, 2 months ago
C Creating the database on a Bare Metal Solution server with the database running on flash storage will ensure high performance and low latency, which is critical for achieving the RTO and RPO objectives. Keeping a local backup copy on standard storage will provide a quick restore option in case of any issues or failures within the Bare Metal Solution environment. This allows for faster recovery when needed. Using the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to a Coldline Storage bucket is a cost-effective solution for long-term data retention. Coldline Storage is designed for data archival and offers a lower cost compared to other storage options. By using RMAN, the backup process can be automated and scheduled, ensuring that the backups are regularly moved to the Coldline Storage bucket.
upvoted 1 times
...
abdenago
1 year, 4 months ago
Selected Answer: B
HDD (hard drive) for Local backups or archival workloads
upvoted 2 times
...
Nirca
1 year, 7 months ago
Selected Answer: B
GCP wants us to choose B
upvoted 3 times
...
PrtkKA
1 year, 8 months ago
Selected Answer: B
RMAN cannot move backups to storage buckets. B
upvoted 1 times
Nirca
1 year, 7 months ago
0 You can use gcsfuse to mount GCS bucket as file systems on your machine and use RMAN to create backups there.
upvoted 1 times
Nirca
1 year, 7 months ago
but I think you are right. and this is what GCP aiming for.
upvoted 1 times
...
...
...
openkg
1 year, 9 months ago
Selected Answer: D
D is an answer
upvoted 3 times
...
Atnafu
1 year, 10 months ago
D is an answer
upvoted 4 times
...
pk349
1 year, 10 months ago
D: Create the database on a Bare Metal Solution server with the database running on flash storage. Archive storage ARCHIVE 365 days Yes • 99.95% in multi-regions and dual-regions • 99.9% in regions Keep a local backup copy on all flash storage. Use the Oracle Recovery Manager (RMAN) backup utility to move backups older than one day to an ***** Archive Storage bucket.
upvoted 4 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago