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 63 - NCP-DB-6.5 discussion

Report
Export

Which statement best describes what happens when a 3rd-party backup tool is chosen to manage log backups for Microsoft SQL in NDB?

A.
If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will not be supported, but snapshot-based recovery of the databases is supported.
Answers
A.
If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will not be supported, but snapshot-based recovery of the databases is supported.
B.
Third-party backups vendors can continue to backup the archived logs from the database log destination. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get backed up
Answers
B.
Third-party backups vendors can continue to backup the archived logs from the database log destination. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get backed up
C.
If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will be supported, but snapshot-based recovery of the databases is not supported.
Answers
C.
If exclusive log access is not granted to NDB, the Point-in-Time (PIT) recovery will be supported, but snapshot-based recovery of the databases is not supported.
D.
Third-party backups vendors can continue to backup the binary logs from the binary log location. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get purged.
Answers
D.
Third-party backups vendors can continue to backup the binary logs from the binary log location. NDB will still be able to capture the logs, considering the log catch-up begins before the logs get purged.
Suggested answer: B

Explanation:

NDB supports two modes of log backup management for Microsoft SQL databases: NDB-managed and 3rd-party managed. In the NDB-managed mode, NDB takes full control of the log backups and stores them in the Cerebro log location. In the 3rd-party managed mode, NDB allows the use of external backup tools to backup the logs from the database log destination. However, NDB still needs to capture the logs for its own operations, such as point-in-time recovery, clone refresh, and log catch-up. Therefore, NDB will periodically scan the database log destination and copy the logs to the Cerebro log location. This process requires that the log catch-up begins before the logs get backed up by the 3rd-party tool, otherwise NDB will miss some logs and the operations will fail. If the 3rd-party tool grants exclusive access to the logs, then NDB will not be able to capture them at all, and the operations will not be supported.Reference:

Nutanix Database Management & Automation (NDMA) course, Module 5, Lesson 5.2 - Log Backup Management

Nutanix Support & Insights, Nutanix NDB User Guide v2.5, Log Backup Management

Show Answer
asked 23/09/2024
57 Milecross Lane Jodie
41 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