NCP-DB-7 5 Practice Tests - Nutanix Database Automation v7 5

Prévia do material em texto

1 / 10
Exam : NCP-DB-7.5
Title :
https://www.passcert.com/NCP-DB-7.5.html
Nutanix Certified
Professional - Database
Automation v7.5
2 / 10
1.An administrator needs to enable multi-cluster to setup NDB HA.
What should the administrator configure for the NDB Agent to satisfy this requirement?
A. Name Prefix
B. Network Profile
C. Static VLAN
D. Compute Profile
Answer: B
Explanation:
To enable multi-cluster setup for NDB High Availability (HA), the administrator must configure the NDB
Agent with a Network Profile. A Network Profile defines the networking settings (e.g., VLANs, IP ranges)
that the NDB Agent uses to communicate across clusters. This is critical for multi-cluster HA, as it
ensures consistent network configuration for replication, failover, and data synchronization between
clusters. The Network Profile must be properly configured to handle inter-cluster traffic and latency
requirements (e.g.,database. This can be achieved using native MSSQL tools (e.g., backup/restore, log shipping, or
replication) or NDB’s data migration features, such as cloning or restoring from a backup, depending on
the source environment.
Other options are incorrect or incomplete:
A. Use Nutanix Move to migrate the database server VM: Nutanix Move is designed for VM migration
between platforms, not for database-specific migrations within NDB, which requires data migration to a
new instance.
C. Create a new database server VM and database then register it with NDB: Registering an existing VM
5 / 10
with NDB does not handle data migration from the source MSSQL database.
D. Backup your database VM and import it into Nutanix: Backing up the entire VM and importing it does
not integrate the database with NDB’s management framework, and data migration would still be
required separately.
Thus, the verified answer is B, providing a structured migration process tailored to NDB’s capabilities.
Official Nutanix Database Automation References
Nutanix Database Management & Automation (NDMA) course, Module 3: Managing Database
Instances, Lesson 3.5: Migrating Databases to NDB.
Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Knowledge Objectives, Section 3:
Manage NDB Solutions, Objective 3.4: Migrate Databases (applicable to v7.5).
Nutanix NDB Administration Guide: "Migrating MSSQL Databases to NDB" section, outlining provisioning
and data migration steps.
7.An administrator successfully adds a Nutanix cluster to the NDB control plane but cannot provision a
database server VM. The provisioning wizard does not display any available networks.
Which configuration is most likely missing?
A. Network Profile for the database HA component
B. Network Profile for the specific database engine
C. Network Profile with DHCP
D. Network Profile with a static IP range
Answer: B
Explanation:
NDB profiles are scoped by database engine and deployment type. A Network Profile identifies the VLAN
and related network settings that NDB can use when creating a database server VM. Merely registering
the Nutanix cluster does not create a usable engine-specific Network Profile. If the provisioning wizard
for a particular engine displays no networks, the most likely missing object is the Network Profile created
under that database engine. DHCP or static addressing is a configuration choice inside the profile;
neither is universally required, so the absence of one addressing mode does not explain an empty list by
itself. A database HA component profile would be relevant only to the corresponding HA topology, not
ordinary engine provisioning.
Therefore, the administrator must create or make available a Network Profile for the specific database
engine. Nutanix documents this engine-specific workflow under NDB Profiles.
8.Which policies define Time Machine data availability across multiple registered clusters in NDB?
A. Recovery Plans
B. Data Access Management
C. Data Protection
D. Service Level Agreements
Answer: A
Explanation:
The recovery plans policy defines the Time Machine data availability across multiple registered clusters
in NDB. The recovery plans policy allows the database administrator to specify the source and target
clusters, the frequency and retention of the cross-cluster snapshots, and the network and compute
profiles for the recovery operations. The recovery plans policy helps to ensure the disaster recovery and
6 / 10
business continuity of the NDB-managed databases in case of a cluster failure or outage.
The data access management policy defines the access permissions and roles for the NDB users and
groups. The data access management policy allows the database administrator to grant or revoke
access to the NDB instance, the database server VMs, the databases, and the database operations. The
data access management policy helps to ensure the security and compliance of the NDB-managed
databases and users.
The data protection policy defines the backup and restore settings for the NDB-managed databases. The
data protection policy allows the database administrator to specify the frequency, retention, and
compression of the database snapshots, and the backup location and encryption for the database
backups. The data protection policy helps to ensure the backup and recovery of the NDB-managed
databases within the same cluster.
The service level agreements policy defines the performance and availability metrics for the NDB-
managed databases. The service level agreements policy allows the database administrator to monitor
and enforce the database uptime, latency, throughput, and IOPS. The service level agreements policy
helps to ensure the quality of service and performance of the NDB-managed databases.
Nutanix Database Management & Automation Training Course, Module 4: Nutanix Era Configuration,
Lesson 4.1: Nutanix Era Configuration, slide 9.
Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations,
Lesson
5.1: Nutanix Era Operations, slides 8, 12, 16, 20.
Nutanix Database Management & Automation Training Course, Module 6: Nutanix Era Disaster
Recovery, Lesson 6.1: Nutanix Era Disaster Recovery, slides 5-7.
9.How is a software profile created?
A. In the Ere IJI select Profiles Software, and then a template VM.
B. In the Ere IJI select Profiles Software, and then a database engine, OS version, and database
version, C. Create a software profile from a registered Database Server VM.
D. Clone e software profile provided by Era and modify as needed.
Answer: B
Explanation:
Nutanix Database Automation (NCP-DB) simplifies database provisioning using predefined profiles
customized to your environment. Software profiles, which are templates of the OS and database engine,
allow you to maintain consistent software versions1. You then use additional profiles to customize that
deployment1.
10.Which file format is available when downloading a list of alerts?
A. xlsx
B. csv
C. xml
D. pdf
Answer: B
Explanation:
When downloading a list of alerts from NDB, the available file format is csv (Comma-Separated Values).
NDB provides this format to export alert data (e.g., alert ID, timestamp, severity, description) in a
7 / 10
structured, machine-readable way that can be easily imported into spreadsheet applications like
Microsoft Excel or analyzed programmatically. This aligns with NDB’s focus on operational efficiency and
data portability.
Other options are not supported:
A. xlsx: Excel’s native format is not offered by NDB for alert exports.
C. xml: Not a supported format for alert downloads in NDB.
D. pdf: Used for reports, not alert list exports.
Thus, the verified answer is B, reflecting NDB’s export capabilities.
Official Nutanix Database Automation References
Nutanix Database Management & Automation (NDMA) course, Module 6: Monitoring and Alerts, Lesson
6.2: Managing Alerts.
Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Knowledge Objectives, Section 6:
Optimize NDB Solutions, Objective 6.2: Manage Alerts (applicable to v7.5).
Nutanix NDB Administration Guide: "Exporting Alerts" section, specifying CSV format.
11.While registering a database, the Group Database with One Time Machine option is selected.
What is the key architectural benefit of this option?
A. Optimized RPO and performance
B. Faster provisioning
C. Independent recovery for each database
D. Reduced storage consumption
Answer: A
Explanation:
Selecting Group Database with One Time Machine associates multiple SQL Server databases with one
protection construct rather than separate Time Machines. Nutanix explicitly recommends grouping
databases when they share protection requirements because the arrangement provides optimized RPO
and improved performance. It also lets the group be protected, cloned, and recovered consistently under
one SLA and one snapshot and log-catch-up schedule. Reduced storage consumption may occur as a
secondary operational effect, but it is not the documented key architectural benefit. Fasterprovisioning is
likewise not the principal reason for creating a database group, and independent recovery contradicts
the group model because the databases share the same Time Machine. Therefore, optimized RPO and
performance is the only option that matches Nutanix’s documented guidance for database groups.
12.An administrator needs to restore a source database from a snapshot. The database shares the
source volume with multiple other databases.
How does NDB handle this database restore operation?
A. Copies the specific database files to the source volume
B. Replaces source volume with specific db disks
C. Replaces the source volume with the snapshot volume
D. Copies all database files to the source volume
Answer: A
Explanation:
The correct answer is A because NDB handles the database restore operation by copying the specific
database files from the snapshot volume to the source volume, without affecting the other databases that
8 / 10
share the same source volume. NDB uses a copy-on-write mechanism to create snapshots and clones,
which means that only the changes made to the database files are stored in the snapshot or clone
volume, while the original files are kept in the source volume. Therefore, when restoring a source
database from a snapshot, NDB only needs to copy the specific database files that have been modified
since the snapshot was taken, and overwrite them on the source volume. The other options are not
correct because they either cause data loss or unnecessary data transfer.
Option B is not correct because replacing the source volume with specific db disks would erase the other
databases that share the same source volume, which is not desirable.
Option C is not correct because replacing the source volume with the snapshot volume would also erase
the other databases that share the same source volume, as well as any changes made to the source
database after the snapshot was taken, which is not desirable.
Option D is not correct because copying all database files to the source volume would be inefficient and
unnecessary, as only the modified files need to be copied, and the other files are already present on the
source volume. References: Nutanix Database Management & Automation (NDMA) course, Nutanix
Certified Professional - Database Automation (NCP-DB) certification, Nutanix NCP-DB Certification
Exam Syllabus and Study Guide, [Nutanix Support & Insights]
13.An administrator needs the ability to clone a source database to a point in time.
What is the lowest log frequency in minutes that can be configured in the Era IJI for log catchup
operation?
A. 30
B. 60
C. 5
D. 15
Answer: C
Explanation:
The log frequency in the Era IJI for log catchup operation can be configured to as low as 5 minutes. This
allows the system to capture changes to the database at a high frequency, enabling more precise point-
in-time recovery options. However, it’s important to note that a higher frequency of log catchup
operations can lead to increased system load.
Therefore, the optimal frequency may vary depending on the specific requirements and capabilities of
your system12. Please refer to the Nutanix Database Automation (NCP-DB) Learning documents for
more detailed information.
14.An administrator needs to capture the database transaction logs.
Which Time Machine operation does NDB use to satisfy this requirement?
A. Write-Ahead Logging
B. Log Flush
C. Log Catch-up
D. Snapshots
Answer: C
Explanation:
To capture database transaction logs in NDB, the Log Catch-up operation within the Time Machine is
used. Log Catch-up retrieves and applies transaction logs (e.g., PostgreSQL WAL, SQL Server logs) to a
9 / 10
snapshot, ensuring the database can be restored to a specific point in time. This operation bridges gaps
between snapshots by incorporating log data, maintaining a continuous recovery chain.
Other options are incorrect:
A. Write-Ahead Logging: A database feature (e.g., in PostgreSQL), not an NDB Time Machine operation.
B. Log Flush: Refers to writing logs to disk, not capturing them for recovery.
D. Snapshots: Capture the database state but do not handle transaction logs specifically.
Thus, the verified answer is C, aligning with NDB’s log management.
Official Nutanix Database Automation References
Nutanix Database Management & Automation (NDMA) course, Module 5: Data Protection and Recovery,
Lesson 5.2: Managing Time Machines.
Nutanix Certified Professional - Database Automation (NCP-DB) v7.5Knowledge Objectives, Section 5:
Protect Databases Using NDB, Objective 5.2: Manage Time Machine Operations (applicable to v7.5).
Nutanix NDB Administration Guide: "Log Catch-up Operation" section.
15.In NDB, which two Time Machine options are available when creating a database clone? {Choose
two.)
A. Point in time
B. Restore point
C. Backup
D. Snapshot
Answer: A D
Explanation:
The correct answer is A and D because these are the two Time Machine options that are available when
creating a database clone in NDB. Point in time allows the user to specify a date and time to create a
clone from a specific point in the database history. Snapshot allows the user to select a previously taken
snapshot to create a clone from a consistent state of the database.
Option B is incorrect because Restore point is not a Time Machine option, but a feature that allows the
user to restore a source database to a previous point in time.
Option C is incorrect because Backup is not a Time Machine option, but a feature that allows the user to
backup a database to a remote location.
The following sources provide more information about the Time Machine options and cloning features in
NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases Using
Time
Machine, Lesson 4.2: Cloning Databases
Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 5 -
Protect NDB-managed Databases Using Time Machine
Nutanix Database Service (NDB) User Guide, Chapter 6: Protecting Databases Using Time Machine,
Section
6.2: Cloning Databases
[Nutanix Support & Insights], NDB Time Machine Under the Hood
16.Which action can be performed on Alert Policies?
A. Disable
10 / 10
B. Delete
C. Pause
D. Publish
Answer: A
Explanation:
NDB alert policies are enabled by default and may be disabled when an administrator does not want a
particular policy to generate alerts. The policy can later be enabled again, allowing alert generation to
resume without recreating the policy or changing the monitored resource. This preserves the policy
definition while suppressing unwanted notifications and events. NDB also supports operations such as
configuring retention and resolving alerts, but those are separate alert-management functions. Pause is
terminology associated with other scheduled processes, not the alert-policy control. Publish applies to
objects such as software profile versions, and deletion is not the standard control exposed for built-in
NDB alert policies. Consequently, Disable is the valid action among the choices. The supported behavior
is described in Nutanix’s Disabling or Enabling Alert Policies procedure.
17.What are two status values that can be set within the Alerts Dashboard? (Choose two.)
A. Auto
B. Resolved
C. Data Resiliency
D. Acknowledged
Answer: B D
Explanation:
The correct answer is B and D because these are the two status values that can be set within the Alerts
Dashboard in NDB. Resolved means that the alert has been fixed and no longer requires attention.
Acknowledged means that the alert has been seen and is being worked on.
Option A is incorrect because Auto is not a status value, but a mode that automatically resolves alerts
based on predefined rules.
Option C is incorrect because Data Resiliency is not a status value, but a feature that ensures the
availability and integrity of the data in NDB.
The following sources provide more information about the Alerts Dashboard and its status values in
NDB:
Nutanix Database Management & Automation (NDMA) course, Module3: Monitoring Alerts and Storage
Usage Within an NDB Implementation, Lesson 3.1: Monitoring Alerts
Nutanix Certified Professional - Database Automation (NCP-DB) v6.5, Knowledge Objectives, Section 3 -
Monitor Alerts and Storage Usage Within an NDB Implementation
Nutanix Database Service (NDB) User Guide, Chapter 3: Monitoring Alerts and Storage Usage Within an
NDB Implementation, Section 3.1: Monitoring Alerts
[Nutanix Support & Insights], Resolving All Alerts Related to a Database or Database Server VM in NDB