Nutanix Exam NCP-DB Topic 1 Question 4 Discussion

Actual exam question for Nutanix's NCP-DB exam

Question #: 4
Topic #: 1

A development team has requested that an administrator provide them a copy of the production Finance database. The business requires that any financial data is masked before going into development.

How should the administrator create a clone with masked data for the development environment?

AFrom the Time Machine, create a clone and paste the masking commands in the post-clone field of the Pre-Post Commands section.

B1. Create a masking script on the source DB VM, Dev VM or SW Profile VM.
2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.

C1. Create a script to mask the data.
2. Create the clone from the Time Machine and define the post-clone option with the full path\name of the masking script.

DFrom the Time Machine, create a clone and paste the masking commands in the pre-clone field of the Pre-Post Commands section.

Show Suggested Answer

Suggested Answer: B

by Iluminada at Apr 09, 2024, 06:42 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Brice

7 months ago

I see your point, Latonia. However, I think option C could also work by creating a script to mask the data and defining the post-clone option with it.

upvoted 0 times

...

Latonia

7 months ago

But what if we make a mistake in the masking script? Wouldn't it be better to paste the commands in the pre-clone field like option D?

upvoted 0 times

...

Desiree

7 months ago

I agree with Carmela. Option B seems like the most logical choice to ensure the financial data is masked properly.

upvoted 0 times

...

Carmela

7 months ago

I think option B is the best choice because we can create a masking script and define the post-clone option with the full path.

upvoted 0 times

...

Antione

7 months ago

I would prefer to create a script to mask the data and define the post-clone option with the script's full path/name. It seems more organized.

upvoted 0 times

...

Jerrod

7 months ago

Alternatively, we could paste masking commands in the pre-clone field of the Pre-Post Commands section when creating the clone.

upvoted 0 times

...

Yan

7 months ago

I agree with That sounds like the most efficient way to mask the financial data.

upvoted 0 times

...

Becky

8 months ago

I think we should create a masking script on the source DB VM and then define the post-clone option with the script path.

upvoted 0 times

...

Leah

8 months ago

How should we create a clone with masked data for the development environment?

upvoted 0 times

...

Herman

9 months ago

Alright, let's do this! I'm going with option C. Create a script, clone the database, run the script. Boom, job done. Simple as that. Now, who's ready to grab a beer after this exam?

upvoted 0 times

...

You can create a clone from a Time Machine and insert pre-post commands section for data masking. The real question is : when should you run data masking script, in pre-script or post-script section ? I think answer is post-script section. First, you have to clone your database, then you run data masking script according to this article in the section "Recommended Data Masking Workflow" : https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dmksb/data_masking.html#GUID-2B0418D5-0D85-4F9B-9A7F-53665681BE25 Therefore, answer is A.

upvoted 1 times

Yohan

9 months ago

After more research about this question, With NDB, you can create sanitized snapshots of databases to create sanitized database clones. You can achieve this in two ways: Synchronous approach: Creating a sanitized snapshot using create or refresh clone workflows where you perform sanitization using post scripts. Asynchronous approach: Creating a sanitized snapshot on an existing clone where you perform sanitization using a third-party tool or a custom script. Note : NDB does not support sanitized snapshots for the Oracle database engine. See https://portal.nutanix.com/page/documents/details?targetId=Nutanix-NDB-User-Guide-v2_5:top-sanitized-snapshots-c.html

upvoted 1 times

...

Keena

9 months ago

I think option C is the way to go. It makes the most sense to create a script to mask the data first, and then use that script to create the clone. That way, the data is guaranteed to be masked before it's copied to the development environment.

upvoted 0 times

...

Renea

9 months ago

I'm a little confused about this question. Are we supposed to create a clone of the production database and then mask the data, or create a script to mask the data and then clone the database? The options seem a bit ambiguous to me.

upvoted 0 times