ExamGecko
Search Search Login
Home Home / Nutanix / NCP-DB-6.5
Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A database admin logs into Era to manage an Oracle Database VM and sees a message Update Available on the Status of the Software Profile Version. What should the database admin do?
The NDB user interface can display which language option?
An administrator needs to apply a minor version upgrade of the PostgreSQL software to an Era provisioned instance. Which step should the administrator take before applying the patch?
How is a software profile created?
When doing an Era software upgrade for a Multi-Cluster enabled installation, which component is upgraded first?
An administrator needs to work with databases and time machines, but not database parameter profiles. Which role satisfies this requirement?
Within the NDB GUI, an administrator needs to set the shortest schedule interval possible for a database log catch up. Which value, in minutes, will satisfy this requirement?
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?
Which two statements best describe the features and functionality of Era Oracle patching? (Choose two.)
A legal team wants to audit a quarter end (July 31st) banking transaction event and asks the administrator to create a SQL database from the timeframe. What action should the administrator perform within Era?

Question 90 - NCP-DB-6.5 discussion

Report
Export

A user accidentally drops a table in the database at 10:42pm and the NDB administrator is tasked with restoring the table.

The snapshot schedule is set for every 30 minutes and the log catchup is set for every 15 minutes. The last available snapshot is at 10:30pm.

What is the optimal path to restore the table back with minimum data loss?

A.
Restore the 10:42pm snapshot.
Answers
A.
Restore the 10:42pm snapshot.
B.
Restore using point in time till 10:41pm.
Answers
B.
Restore using point in time till 10:41pm.
C.
Restore using point in time till 10:42pm.
Answers
C.
Restore using point in time till 10:42pm.
D.
Restore the 10:30pm snapshot.
Answers
D.
Restore the 10:30pm snapshot.
Suggested answer: C

Explanation:

The optimal path to restore the table back with minimum data loss is to use the point in time restore feature of NDB, which allows the administrator to restore the database to a specific point in time based on the available snapshots and logs1.By restoring using point in time till 10:42pm, the administrator can recover the table just before it was dropped by the user, and minimize the data loss to the least possible amount1. The other options are not optimal, as they either involve restoring an older snapshot, which may result in more data loss, or restoring a non-existent snapshot, which is not possible.Reference:

1: Nutanix Database Automation (NCP-DB) course, Module 6: Database Recovery, Lesson 6.2: Point in Time Restore, slide 5

Show Answer
asked 23/09/2024
TienYai Ho
37 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms