Nutanix NCP-DB Exam - Topic 3 Question 35 Discussion

Actual exam question for Nutanix's NCP-DB exam

Question #: 35
Topic #: 3

A DBA executed a script which corrupted an Oracle DB managed by NDB. After few minutes, the NDB administrator has been asked to create a copy of the DB using the latest available snapshot.

Which actions should be taken?

AFail the Oracle cluster over to a surviving RAC node.

BSelect the snapshot from Time Machine and create a new clone.

CUse Time Machine to create a clone from file-level database backup.

DProvision a new Oracle DB and perform log catch-up.

Show Suggested Answer

Suggested Answer: B

After a DBA's script corrupts an Oracle DB managed by NDB, the administrator needs to restore a clean copy using the latest available snapshot. The most straightforward action is to use the NDB Time Machine feature to select the most recent uncorrupted snapshot and create a new clone. This clone can serve as a restored version of the database, bypassing the corrupted data while leveraging existing snapshots for efficiency.

Option A (Fail the Oracle cluster over to a surviving RAC node) is incorrect because RAC failover is for HA, not corruption recovery via snapshots.

Option B is correct as it uses Time Machine to create a clone from a valid snapshot, addressing the corruption.

Option C (Use Time Machine to create a clone from file-level database backup) is incorrect because NDB primarily uses snapshots, not file-level backups, for cloning.

Option D (Provision a new Oracle DB and perform log catch-up) is incorrect because provisioning a new DB is more complex and unnecessary when a snapshot-based clone suffices.

This method ensures rapid recovery with minimal disruption.

Nutanix Database Service (NDB) User Guide, Chapter 5: Configuring Time Machines, Section: Restoring and Cloning from Snapshots

Nutanix Support & Insights, Knowledge Base Article: 'Recovering from Database Corruption in NDB'

Nutanix Certified Professional - Database Automation (NCP-DB) v6.5 Blueprint, Section 5: Protect Databases Using Time Machine

by Justine at Jul 08, 2025, 04:27 AM

Limited Time Offer

25%

Off

Get Premium NCP-DB Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Tu

5 months ago

A is definitely not the right choice here.

upvoted 0 times

...

Tamra

5 months ago

I disagree, I think D is the way to go.

upvoted 0 times

...

Mendy

5 months ago

Option B sounds like a solid plan!

upvoted 0 times

...

Isabella

6 months ago

C seems like the safest bet for recovery.

upvoted 0 times

...

Dolores

6 months ago

Wait, can you really use Time Machine for this?

upvoted 0 times

...

Lucille

6 months ago

I’m a bit confused about the log catch-up option; I thought that was more for restoring from a backup rather than creating a new DB.

upvoted 0 times

...

Lili

6 months ago

I practiced a similar question where we had to choose between snapshots and backups, and I feel like creating a clone from a file-level backup might be the safest bet.

upvoted 0 times

...

Salena

7 months ago

I think failing over to a surviving RAC node could be a good option, but I need to double-check if that would actually help in this case.

upvoted 0 times

...

Marsha

7 months ago

I remember we discussed the importance of using snapshots for recovery, but I'm not sure if Time Machine is the right tool for this situation.

upvoted 0 times

...

Ben

7 months ago

This seems straightforward. The DBA corrupted the database, so we need to create a new copy from the latest snapshot. Option B is the clear choice here.

upvoted 0 times

...

Hoa

7 months ago

I'm not too familiar with NDB, so I'll need to make sure I understand how that fits into the scenario. But I think I can narrow it down to a couple of options.

upvoted 0 times

...

Antonio

7 months ago

Okay, I think I've got this. The key is to create a copy of the database using the latest available snapshot. Option B looks like the way to go.

upvoted 0 times

...

Noble

8 months ago

Hmm, I'm a bit confused by the mention of Time Machine. That's not an Oracle feature, is it? I'll have to double-check that.

upvoted 0 times

...

Quentin

8 months ago

This seems like a tricky one. I'll need to carefully read through the options and think about the context of the question.

upvoted 0 times

...

Gayla

10 months ago

I disagree with Kaycee, I believe provisioning a new Oracle DB and performing log catch-up is the way to go.

upvoted 0 times

...

Kaycee

10 months ago

I think we should use Time Machine to create a clone from file-level database backup instead.

upvoted 0 times

...

Asuncion

10 months ago

I agree with Chanel, failing over to a surviving RAC node seems like the best option.

upvoted 0 times

...

Lindsey

11 months ago

Hmm, let's see... Failing over to a RAC node doesn't sound like the right move here. I'm leaning towards option C - using Time Machine for a file-level backup. Sounds like the safest bet to me.

upvoted 0 times

...

Elenor

11 months ago

Whoa, this is a tricky one! Gotta love those Oracle database disasters, am I right? I'm going with option D - time to provision a new DB and catch up on those logs. Yee-haw!

upvoted 0 times