nerdexam
Nutanix

NCP-DB-6.10 · Question #54

An administrator would like to use Era for Copy Data Management operations on an Availability Group (AG) database. The AG database is hosted on replicas with different named instances, as shown…

The correct answer is A. Register the database as an Availability database. According to the Nutanix Database Automation (NCP-DB) learning documents, when dealing with an Availability Group (AG) database, the database should be registered as an Availability database. This is because the AG database is hosted on replicas with different named instances…

Manage Database Environments

Question

An administrator would like to use Era for Copy Data Management operations on an Availability Group (AG) database. The AG database is hosted on replicas with different named instances, as shown below:

  • SQLAGNI\EMR
  • SQLAGN2\EMR
  • SQLAGN3\DW

SQLAGN3\DW is running the Analytics service that needs real-time data. How should the administrator register the database in Era?

Options

  • ARegister the database as an Availability database.
  • BRegister the database as a Standalone database,
  • CRegister the SQLAGN3 from AG cluster and register the database as Availability database,

How the community answered

(36 responses)
  • A
    61% (22)
  • B
    28% (10)
  • C
    11% (4)

Explanation

According to the Nutanix Database Automation (NCP-DB) learning documents, when dealing with an Availability Group (AG) database, the database should be registered as an Availability database. This is because the AG database is hosted on replicas with different named instances, and registering it as an Availability database allows for Copy Data Management operations to be performed across all instances. This is particularly important when services such as the Analytics service running on SQLAGN3\DW require real-time data.

Topics

#MSSQL AG#database registration#named instances#availability group

Community Discussion

No community discussion yet for this question.

Full NCP-DB-6.10 Practice