Practice Free NCP-DB-6.5 Exam Online Questions
Question #41
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
Correct Answer: A
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 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.
Reference: 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]
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 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.
Reference: 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]
Question #42
An administrator needs to migrate a large 1/0-intensive database that doesn’t support multi-disk layout.
How should the storage be provisioned with Era to support the database while optimizing performance?
- A . Volume Group
- B . Volume Group with Load Balancing
- C . Storage Spaces
- D . vDisk based provisioning
Correct Answer: A
A
Explanation:
In Nutanix Era, a Volume Group is the recommended storage provisioning method for a large I/O-intensive database that doesn’t support a multi-disk layout1. A Volume Group in Nutanix Era is a collection of disks that can be managed as a single entity, providing a way to aggregate the storage capacity of multiple disks into a larger storage unit1. This allows for better performance optimization as it enables the database to leverage the combined I/O capabilities of all the disks in the group1. It’s important to note that while other options like Load Balancing, Storage Spaces, and vDisk based provisioning can also be used in certain scenarios, a Volume Group is specifically designed for situations where a single, high-performance storage unit is required1.
A
Explanation:
In Nutanix Era, a Volume Group is the recommended storage provisioning method for a large I/O-intensive database that doesn’t support a multi-disk layout1. A Volume Group in Nutanix Era is a collection of disks that can be managed as a single entity, providing a way to aggregate the storage capacity of multiple disks into a larger storage unit1. This allows for better performance optimization as it enables the database to leverage the combined I/O capabilities of all the disks in the group1. It’s important to note that while other options like Load Balancing, Storage Spaces, and vDisk based provisioning can also be used in certain scenarios, a Volume Group is specifically designed for situations where a single, high-performance storage unit is required1.
Question #43
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)
- A . Memory
- B . Compute
- C . Network
- D . Storage
Correct Answer: B, D
B, D
Explanation:
In the Nutanix Database Automation (NCP-DB) framework, provisioning a new Oracle database through Era requires the configuration of both a Compute and a Storage profile1. The Compute profile is used to define the resources allocated to the database, such as CPU and memory, while the Storage profile is used to specify the storage configuration for the database. These profiles are essential in ensuring that the database is provisioned with the necessary resources and storage configurations for optimal performance23.
B, D
Explanation:
In the Nutanix Database Automation (NCP-DB) framework, provisioning a new Oracle database through Era requires the configuration of both a Compute and a Storage profile1. The Compute profile is used to define the resources allocated to the database, such as CPU and memory, while the Storage profile is used to specify the storage configuration for the database. These profiles are essential in ensuring that the database is provisioned with the necessary resources and storage configurations for optimal performance23.
Question #43
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)
- A . Memory
- B . Compute
- C . Network
- D . Storage
Correct Answer: B, D
B, D
Explanation:
In the Nutanix Database Automation (NCP-DB) framework, provisioning a new Oracle database through Era requires the configuration of both a Compute and a Storage profile1. The Compute profile is used to define the resources allocated to the database, such as CPU and memory, while the Storage profile is used to specify the storage configuration for the database. These profiles are essential in ensuring that the database is provisioned with the necessary resources and storage configurations for optimal performance23.
B, D
Explanation:
In the Nutanix Database Automation (NCP-DB) framework, provisioning a new Oracle database through Era requires the configuration of both a Compute and a Storage profile1. The Compute profile is used to define the resources allocated to the database, such as CPU and memory, while the Storage profile is used to specify the storage configuration for the database. These profiles are essential in ensuring that the database is provisioned with the necessary resources and storage configurations for optimal performance23.
Question #45
An online retail application requires data to be synchronized between multiple SQL Server databases. This provides clearer reporting from multiple databases at the Same time for consistency at the end of each business day.
What is the best way to fulfill this requirement?
- A . Have all the databases present in the same DBVM and register databases in Era.
- B . Have all the databases present in the same DBVM and register databases in Era with Multiple Databases as a Group with one Time Machine.
- C . Have all the databases present in the same DBVM and register databases in Era with One Database with One Time Machine.
- D . Have all the databases in the same Availability Group and register databases in Era.
Correct Answer: B
B
Explanation:
Nutanix Era enables you to clone your source databases and refresh the database clones by using snapshots or transaction logs1. For an online retail application that requires data to be synchronized between multiple SQL Server databases, having all the databases present in the same Database Virtual Machine (DBVM) and registering them in Era with Multiple Databases as a Group with one Time Machine would be the most efficient way to fulfill this requirement1. This approach allows for clearer reporting from multiple databases at the same time for consistency at the end of each business day1.
B
Explanation:
Nutanix Era enables you to clone your source databases and refresh the database clones by using snapshots or transaction logs1. For an online retail application that requires data to be synchronized between multiple SQL Server databases, having all the databases present in the same Database Virtual Machine (DBVM) and registering them in Era with Multiple Databases as a Group with one Time Machine would be the most efficient way to fulfill this requirement1. This approach allows for clearer reporting from multiple databases at the same time for consistency at the end of each business day1.
Question #46
When registering SAP HANA Database and Database Server VM there are several (Linux) OS configuration requirements that must be set before registering a database Or a database server VM.
Which system file should the entry, secure_pazh be configured in?
- A . /ezc/sudores
- B . ‘etc/ profile
Correct Answer: A
Question #47
An administrator needs to provision a database for test purposes with a data protection policy that minimizes storage usage.
How should the administrator best complete this task?
- A . Disable the SLA for this database during provisioning.
- B . Create a SLA that only leverages zero-byte snapshots.
- C . Select the built-in NONE SLA that is configured for no snapshot or log backup.
- D . Create a custom SLA for this database that only retains 1 day of snapshots and bogs.
Correct Answer: C
C
Explanation:
Nutanix Database Automation (NCP-DB) allows administrators to manage Service Level Agreements (SLAs) for databases. These SLAs define the data protection policies for databases. In this case, to minimize storage usage for a test database, the administrator should select the built-in NONE SLA. This SLA is configured for no snapshot or log backup, thus minimizing storage usage1.
C
Explanation:
Nutanix Database Automation (NCP-DB) allows administrators to manage Service Level Agreements (SLAs) for databases. These SLAs define the data protection policies for databases. In this case, to minimize storage usage for a test database, the administrator should select the built-in NONE SLA. This SLA is configured for no snapshot or log backup, thus minimizing storage usage1.
Question #48
An NDB administrator has asked a database administrator to provision a new MongoDB database using an existing software profile. The database administrator is unable to complete this action.
What may be the cause?
- A . A database clone operation is in progress.
- B . The software profile was created by another user.
- C . The administrator lacks the proper permissions in Prism Element.
- D . The software profile is undergoing a patching operation.
Correct Answer: C
C
Explanation:
If a database administrator is unable to provision a new MongoDB database using an existing software profile, the most likely cause is that the administrator lacks the proper permissions in Prism Element. NDB relies on Prism Element for cluster-level operations (e.g., storage and compute resource allocation). The database administrator needs appropriate Prism Element roles (e.g., Cluster Admin) to interact with the underlying infrastructure, even if the software profile is available in NDB. Without these permissions, the provisioning action will fail.
Other options are less likely:
C
Explanation:
If a database administrator is unable to provision a new MongoDB database using an existing software profile, the most likely cause is that the administrator lacks the proper permissions in Prism Element. NDB relies on Prism Element for cluster-level operations (e.g., storage and compute resource allocation). The database administrator needs appropriate Prism Element roles (e.g., Cluster Admin) to interact with the underlying infrastructure, even if the software profile is available in NDB. Without these permissions, the provisioning action will fail.
Other options are less likely:
Question #49
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:
• SQLAGNIEMR
• SQLAGN2EMR
• SQLAGN3DW
SQLAGN3DW is running the Analytics service that needs real-time data.
How should the administrator register the database in Era?
- A . Register the database as an Availability database.
- B . Register the database as a Standalone database,
- C . Register the SQLAGN3 from AG cluster and register the database as Availability database,
Correct Answer: A
A
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 database1. 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 SQLAGN3DW require real-time data1.
A
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 database1. 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 SQLAGN3DW require real-time data1.
Question #50
When provisioning a new database, which two options are available for the target? (Choose two.)
- A . Provision database to an existing registered
- B . Provision database to an existing container.
- C . Provision databases to e new container.
- D . Provision database to a new database sendercluster.
Correct Answer: A, C
A, C
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, when provisioning a new database, there are two options available for the target12:
Provision database to an existing registered: This option allows you to provision a database to an existing registered database server. This is useful when you want to add a database to a server that is already being managed by Nutanix Era1.
Provision databases to a new container: This option allows you to provision a database to a new container. This is useful when you want to create a new isolated environment for your database1.
A, C
Explanation:
According to the Nutanix Database Automation (NCP-DB) learning documents, when provisioning a new database, there are two options available for the target12:
Provision database to an existing registered: This option allows you to provision a database to an existing registered database server. This is useful when you want to add a database to a server that is already being managed by Nutanix Era1.
Provision databases to a new container: This option allows you to provision a database to a new container. This is useful when you want to create a new isolated environment for your database1.