2024 Latest 100% Exam Passing Ratio - NCP-DB-6.5 Dumps PDF [Q28-Q46]

Share

2024 Latest 100% Exam Passing Ratio - NCP-DB-6.5 Dumps PDF

Pass Exam With Full Sureness - NCP-DB-6.5 Dumps with 148 Questions

NEW QUESTION # 28
Which action should be completed before updating Oracle Database software?

  • A. Download the PSU from Oracle support.
  • B. Verify the Oracle OS version is supported on AHV.
  • C. Perform rolling reboots of the Oracle Database VMs.
  • D. Verify CVMs have the required memory allocated.

Answer: A

Explanation:
Before updating Oracle Database software, you need to download the Patch Set Update (PSU) from Oracle support. A PSU is a collection of critical and security patches for Oracle products. You need to have a valid Oracle account and access to the My Oracle Support portal to download the PSU. You also need to check the compatibility and prerequisites of the PSU before applying it to your Oracle Database software. NDB uses out-of-place patching for Oracle, which means you need to create a new software profile version with the patched Oracle software and use it to update your existing databases.
Reference: Patch Oracle Database Software, Nutanix Support & Insights Nutanix Certified Professional - Database Automation (NCP-DB), Section 4 - Operate and Maintain an NDB Environment Nutanix Database Management & Automation (NDMA) course, Module 4, Lesson 4.4 - Patching Databases


NEW QUESTION # 29
Which two encryption methods can be used when configuring an SMTP server? (Choose two.)

  • A. IPsec
  • B. S/MIME
  • C. SSL
  • D. TLS

Answer: C,D


NEW QUESTION # 30
An administrator is asked to refresh a database everyday at 9:30PM with data from as close to the refresh time as possible.
What is the best way achieve this requirement?

  • A. Schedule an SLA policy to perform snapshot everyday at 9.30PM.
  • B. Schedule an SLA policy that performs a snapshot at 99M and log catchup for every 15 min.
  • C. Schedule e log catchup everyday at 9:30PM.
  • D. Schedule an SLA policy to perform snapshot everyday at 9PM.

Answer: A

Explanation:
This is because it allows the database to be refreshed at the exact time specified (9:30 PM) with the most recent data. The other options either perform the snapshot before the desired time or do not specify when the snapshot would occur. Please note that the exact answer might depend on the specific database system and its capabilities. Always refer to the database's documentation for the most accurate information.


NEW QUESTION # 31
An administrator needs to take multiple snapshots per day and retain them for one week.
How should the administrator define and schedule the SLA?

  • A. * Weekly snapshot retention: 1 week
    * Snapshots per Day: 2
  • B. * Daily snapshot retention: 7 days
    * Snapshots per Day: 2
  • C. * Daily snapshot retention: 7 days
    * Daily snapshot at: 2
  • D. * Weekly snapshot retention: 1 week
    * Daily Snapshot at: 2

Answer: B

Explanation:
The correct answer is D because it matches the requirement of taking multiple snapshots per day and retaining them for one week. Option A is incorrect because it only takes one snapshot per day, which is not enough for the administrator's need. Option B is incorrect because it only retains the snapshots for one week, which means the older snapshots will be deleted after seven days. Option C is incorrect because it only takes two snapshots per week, which is not frequent enough for the administrator's need.
Reference: The following sources provide more information about the SLA retention policies and how to create and modify them in NDB:
Nutanix Database Management & Automation (NDMA) course, Module 4: Protecting Databases Using Time Machine, Lesson 4.1: Creating and Modifying SLA Retention Policies 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.1: Creating and Modifying SLA Retention Policies


NEW QUESTION # 32
How can HA drivers for a Database VM be upgraded?

  • A. LCM driver upgrade
  • B. Database software patching
  • C. One-click software upgrade
  • D. Database VM OS patching

Answer: B


NEW QUESTION # 33
Which ports are used by the NDB database agent for API calls?

  • A. 443 and 9440
  • B. 3205 and 3260
  • C. 443 and 8080
  • D. 5985 and 9389

Answer: A


NEW QUESTION # 34
What happens to the primary member in a MongoDB Server Cluster during the NDB patching process?

  • A. It becomes a read-only member during the patching process.
  • B. It is patched last and is restored to its original state.
  • C. It is patched first and then becomes a secondary member.
  • D. It is skipped during the patching process to ensure no downtime.

Answer: C

Explanation:
According to the NDB documentation, the NDB patching process for MongoDB Server Cluster follows these steps1:
NDB identifies the primary member of the MongoDB Server Cluster and patches it first.
NDB triggers a failover to elect a new primary member from the remaining secondary members.
NDB patches the former primary member, which becomes a secondary member after the failover.
NDB patches the remaining secondary members one by one.
NDB verifies the patching status and the cluster health.
This process ensures that the MongoDB Server Cluster always has a primary member available to handle write operations, while minimizing the downtime and the impact on the cluster performance.
Reference: Nutanix Support & Insights, section "Patching a MongoDB Server Cluster"


NEW QUESTION # 35
Which two profiles are required to provision a new Oracle database through Era? (Choose two.)

  • A. Compute
  • B. Network
  • C. Memory
  • D. Storage

Answer: A,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.


NEW QUESTION # 36
An administrator is trying to register a database server VM with NDB.
Which file types will prevent the registration from being successful if located in the C:\ drive?

  • A. Page
  • B. Backup
  • C. System
  • D. Database

Answer: D


NEW QUESTION # 37
What does an NDB compute profile contain?

  • A. vCPUs, cores per vCPU, and the amount of memory for the database server VM.
  • B. Windows domain name (FQDN), domain user, and password.
  • C. VLAN that the new database server VM will use.
  • D. An image of the database and operating system generated from the registered database server VM.

Answer: A


NEW QUESTION # 38
An administrator needs to deploy a cumulative update (CU) for SQL Server.
What steps would the administrator take to prepare this deployment with NDB?

  • A. Create a new Software Profile version using the CU executable and publish that version.
  • B. Create a new Software Profile using the CU executable and publish that profile.
  • C. Apply the patch to the profile VM, then create a new Software Profile version using the profile VM as the source.
  • D. Apply the patch to the profile VM, delete the existing Software Profile and create a new Software Profile using the profile VM as the source.

Answer: A


NEW QUESTION # 39
An administrator is tasked with providing a Jr DBA with access to NBD with limited capabilities.
This user should only be able to:
* Provision Databases
* Provision Database Servers
* Create Ones
* Refresh Clones
* Patch Database Servers
How can the administrator complete this task?

  • A. Clone the Database Admin role, and add the desired privileges.
  • B. Clone the Database Admin role, and remove all but the desired privileges.
  • C. Create a user for the Jr DBA, and assign only those privileges.
  • D. Create a role with only those privileges, assign the role to the Jr DBA user.

Answer: D


NEW QUESTION # 40
What does a Time Machine frozen status indicate?

  • A. The NDB agent is stopped on the database VM.
  • B. The Time Machine is paused and all automatic snapshot and log catch-up activities are halted.
  • C. The database was de-registered from NDB without removing the associated time machine.
  • D. The database is paused on the database VM.

Answer: B


NEW QUESTION # 41
An administrator needs to take multiple snapshots per day and retain them for one week. How should the administrator define and schedule the SLA?

  • A. * Weekly snapshot retention: 1 week
    * Snapshots per Day: 2
  • B. * Daily snapshot retention: 7 days
    * Snapshots per Day: 2
  • C. * Daily snapshot retention: 7 days
    * Daily snapshot at: 2
  • D. * Weekly snapshot retention: 1 week
    * Daily Snapshot at: 2

Answer: A


NEW QUESTION # 42
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. Put the database instance into maintenance mode.
  • B. Go to the Software Profile Version widget and click update.
  • C. Migrate a new software profile.
  • D. Create a new software profile.

Answer: D

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.


NEW QUESTION # 43
Refer to the exhibit.

A request is received to provision a new Oracle SIHA DB & VM to test ASMLIB on OEL79 and Oracle
19c. When walking through the provisioning workflow, only ASMFD is available in the ASM Driver drop down.
What is necessary to provision the requested SIHA DB and DB VM with ASMLIB?

  • A. Install ASMLIB on the database server.
  • B. Update the NDB driver config to enable ASMLIB for Oracle.
  • C. Update the software profile to include the ASMLIB driver.
  • D. Install ASMLIB on the NDB server.

Answer: C

Explanation:
In the context of Nutanix Database Automation (NCP-DB), when provisioning a new Oracle SIHA DB & VM, if only ASMFD is available in the ASM Driver drop-down, it indicates that ASMLIB is not included in the current software profile. To provision the requested SIHA DB and DB VM with ASMLIB, it's essential to update the software profile to include the ASMLIB driver. This action will enable ASMLIB as an option in the ASM Driver drop-down during the provisioning workflow.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Section 2.3: Provisioning Oracle Databases Nutanix Database Automation (NCP-DB) Certification Details, Objective 2.3: Provision Oracle Databases Nutanix Database Automation (NCP-DB) YouTube Playlist, Video 2.3: Provisioning Oracle Databases
[Nutanix Database Automation (NCP-DB) User Guide], Section 2.3: Provision Oracle Databases


NEW QUESTION # 44
What must be completed within NDB before patching a Linux OS?

  • A. Update the database.
  • B. Configure the repository.
  • C. Update the software profile version.
  • D. Configure database high availability.

Answer: B

Explanation:
Before patching a Linux OS on a database server VM provisioned using NDB, you must configure the repository for the OS updates. This can be done by creating a Repository Profile in NDB and specifying the URL, username, and password for the repository. The Repository Profile can be applied to one or more database server VMs during the provisioning process or later. By configuring the repository, you ensure that NDB can access and download the latest OS patches from a trusted source.
Reference: Nutanix Database Automation (NCP-DB) Course Details, Nutanix Database Automation (NCP-DB) Certification Details, Nutanix Database Automation (NCP-DB) YouTube Playlist, Nutanix Database Automation User Guide.


NEW QUESTION # 45
When performing a SQL Server Restore Source Database operation, what is a valid reason an administrator would choose the Restore Location as New Location?

  • A. The database files are on a disk with other database files and the administrator wants to get the database restored as quickly as possible.
  • B. The administrator wants to keep the original schema in place.
  • C. The log files are needed to petform the point in time restore.
  • D. The administrator wants to restore to a new location and have Era apply Nutanix best practices.

Answer: D

Explanation:
When performing a SQL Server Restore Source Database operation in Nutanix Database Automation (NCP-DB), an administrator might choose the Restore Location as New Location if they want to restore to a new location and have Era apply Nutanix best practices1. This is because Nutanix Era automates and simplifies database management, allowing the administrator to manage databases at scale, and it applies Nutanix best practices during the restore process1. This ensures optimal performance and reliability of the restored database1.


NEW QUESTION # 46
......


Nutanix NCP-DB-6.5 Exam Syllabus Topics:

TopicDetails
Topic 1
  • Apply procedural concepts to provision databases
  • Create, delete, and modify SLA retention policies
Topic 2
  • Given a scenario, troubleshoot NDB operations
  • Determine the correct method to apply Linux OS patches
Topic 3
  • Apply procedural concepts to create Data Access Management (DAM) policies
  • Operate and Maintain an NDB Environment
Topic 4
  • Deploy and Configure an NDB Solution
  • Apply procedural concepts to restore source databases
Topic 5
  • Given business requirements, perform a database clone
  • Apply procedural concepts to register database server VMs and databases
Topic 6
  • Monitor Alerts and Storage Usage Within an NDB Implementation
  • Apply procedural concepts to add Nutanix clusters to NDB
Topic 7
  • Apply procedural concepts to test and publish database patches
  • Protect NDB-managed Databases Using Time Machine

 

Verified NCP-DB-6.5 dumps Q&As - 100% Pass from ActualVCE: https://buildazure.actualvce.com/Nutanix/NCP-DB-6.5-valid-vce-dumps.html