Page 6 out of 25 Pages ... Showing Questions in Random order from Exam |
Which default roles are available within Era for Role-Based Access Control?
A. prism Admin
• Era Super Admin
• Era Database Admin
Era Infrastructure Admin
B. Super Admin
Database Admin
Database Infrastructure Admin
• Infrastructure Admin
C. Era Oracle Admin
Era SQLServer Admin
• Era PostgreSQL Admin
Era Mariadb Admin
D. Super Admin
Database Admin
Database Infrastructure Admin
prism Infrastructure Admin
Explanation:
Nutanix Era offers Role-Based Access Control capabilities by organically embedding them in the product. It
provides the ability to add and remove users from Era, create and assign roles to users, and associate various
privileges with a role1. The default roles available within Era for Role-Based Access Control are:
An administrator has created a new SQL Server software profile version to apply the latest cumulative update. What should the administrator do to make it available to all users?
A. Set the status of the existing software profile version to Unpublished.
B. Update the software profile version and set the status to Published.
C. Deprecate the existing software profile version and use the new one.
D. Select the software profile version with the update and optimization,
Explanation:
When an administrator creates a new SQL Server software profile version to apply the latest cumulative
update, they should update the software profile version and set the status to Published1. This makes the new
profile version available to all users. NDB will show available updates for any database server using the
software profile as soon as the new profile version is published1.
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.
B. Restore using point in time till 10:41pm.
C. Restore using point in time till 10:42pm.
D. Restore the 10:30pm snapshot.
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.
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?
A. Create a new software profile.
B. Put the database instance into maintenance mode.
C. Go to the Software Profile Version widget and click update.
D. Migrate a new software profile.
Explanation:
Nutanix Database Service (NDB) supports automated minor version upgrades for PostgreSQL1. Before
applying the patch, the administrator should create a new software profile2. This is because the software
profile contains the database engine binaries and other software required to run the database
engine2. Therefore, to apply a minor version upgrade, a new software profile with the updated binaries needs
to be created2. Once the new software profile is created, it can be used to patch the PostgreSQL database2.
What is used to temporarily store the transaction logs of the source database before they are copied to the log?
A. Database Agent
B. NDB Drive
C. Time Machine
D. NDB Profiles
The Database Agent is used to temporarily store the transaction logs of the source database before they are copied to the log. This is a critical component for ensuring data consistency and recovery in database operations.References: Nutanix Database Automation documentation, focusing on database agents and their roles in transaction log management.
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.
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.
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.
Explanation:
NDB supports two modes of log backup management for Microsoft SQL databases: NDB-managed and 3rdparty
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.
Page 6 out of 25 Pages |
Previous |