nerdexam
Nutanix

NCP-DB-6.10 · Question #98

While registering an Always on Availability Group database, an administrator selects the following option: Multiple Databases as a Group with One Time Machine Which statement is true regarding this…

The correct answer is B. PITR-based SLAs are not supported for database groups containing mixed Recovery Model. Nutanix Database Automation (NCP-DB) introduces the concept of MS SQL Server database groups, which allows multiple databases running in the same database instance to be grouped as one Time Machine entity. This applies to both single DB Server VM setups, standalone databases…

Configure and Administer Database Infrastructure

Question

While registering an Always on Availability Group database, an administrator selects the following option:

Multiple Databases as a Group with One Time Machine Which statement is true regarding this chosen option?

Options

  • APITR-based SLAs are supported for database groups containing mixed Recovery Model.
  • BPITR-based SLAs are not supported for database groups containing mixed Recovery Model
  • CPoint in Time Clones are not supported by Database Groups.
  • DPITR-based SLAs are not supported for database groups.

How the community answered

(64 responses)
  • A
    5% (3)
  • B
    72% (46)
  • C
    8% (5)
  • D
    16% (10)

Explanation

Nutanix Database Automation (NCP-DB) introduces the concept of MS SQL Server database groups, which allows multiple databases running in the same database instance to be grouped as one Time Machine entity. This applies to both single DB Server VM setups, standalone databases, as well as to Availability Group databases. However, it does not support Point In Time Recovery (PITR)-based Service Level Agreements (SLAs) for database groups containing mixed Recovery Models. This means that if the databases within the group have different recovery models, PITR-based SLAs cannot be applied to the group as a whole.

Topics

#Always On Availability Group#PITR#mixed Recovery Model#Time Machine

Community Discussion

No community discussion yet for this question.

Full NCP-DB-6.10 Practice