Online NCP-DB-6.5 Exam Dumps Help You Build Confidence

1. A database administrator wants to be notified in advance before any database clones are removed using a removal schedule What is the best way to configure this notification?

2. An administrator has run into an error when provisioning a new Oracle database VM.

What is the best action that the administrator should perform in the NDB GUI to provide the most complete picture to send to Nutanix support on that specific operation?

A. From the Administration section of NDB. go to the Diagnostics section and chose Generate Bundle.

B. Copy the error message from the Operations menu.

C. In the operations menu, select the job the failed and choose Generate Bundle from the lower right.

D. Take a screen shot of the error in the Operations menu.

3. What behavior is observed when applying patch profiles as a Super Admin?

4. While using Time Machine (TM) to restore a source database, the option to restore data to Point in Time is not available.

What should an administrator do to restore databases to Point in Time?

5. Which statement is true regarding the NDB alert retention feature?

6. A Development team is asking for updated data for a cloned MongoDB instance that is being used as source data for a script.

Which task should be performed by an NDB administrator?

7. An administrator needs to make new VLANs available when provisioning a Oracle cluster database, which have been added to NDB via the Administration menu.

What needs to be done to expose the new VLANs for provisioning?

8. Exhibit.





An administrator just created the ndb_test user as shown in the exhibit.

Which two tasks can this user perform? (Choose two.)

9. An administrator is trying to register a Nutanix cluster for Multi-Cluster provisioning.

The Era cluster is setup with following configuration:

• Era Multi-Cluster is enabled.

Era Server storage container and Era provisioning container are different on the Era cluster.

What should the administrator configure?

10. An IT manager is onboarding a new Nutanix systems administrator to manage their NDB deployment. The manager would like to assign the NDB role that provides the minimum amount of permissions to allow provisioning of new databases.

Which role should be assigned to accomplish this task?

A. Infrastructure administrator

B. Super administrator

C. Database infrastructure administrator

D. Database administrator

11. What is the minimum frequency in minutes configurable for NDB Log Catch-up operation?

12. It becomes necessary to remove an existing database clone. "To minimize the impact of that removal to users, an administrator would like to schedule this operation for weekend hours.

When scheduling this removal, other than the specified date/time, which option in the Update Removal Schedule is pre-selected as non-optional?

13. While restoring a PostgreSQL HA instance, an administrator notices that the restore of a standby node has failed. The primary node is ready to seive application traffic.

In what state does NDB leave the database?

14. A legal team wants to audit a quarter end (July 31st) banking transaction event and asks the administrator to create a SQL database from the timeframe.

What action should the administrator perform within Era?

15. Which disk is omitted from a Software Profile?

16. 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?

17. An NDB environment has been deployed with three Nutanix clusters. An administrator has been asked to create a Microsoft SQL Server software profile for each of these clusters.

Which is a requirement to create the above-mentioned profiles?

18. Why are ports 3205 and 3260 important when working with Era?

19. An administrator has been asked to patch several Nutanix database server VMs.

Prior to patching, what should the administrator configure?

20. Which two network prerequisites are required to deploy an Era instance in production? (Choose two.)

21. Refer to the exhibit.





An administrator attempts to provision their first clustered database environment with NDB. The operation fails with the Operation Error shown in the exhibit.

Which database engine was being deployed during this operation?

22. Which action must an administrator take in Era Networks before using Era to provision a MSSQL AG cluster?

23. 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?

24. An administrator must be able to restore databases based on very strict SLAs, but is facing multiple bottlenecks when storing log backups of databases on NDB Agents.

What can the administrator do to alleviate these issues?

25. An administrator needs to deploy a cumulative update (CU) for SQL Server.

What steps would the administrator take to prepare this deployment with NDB?

26. An administrator is experiencing issues with NDB and some of its operations. A case has been logged with Nutanix Support and a request has been made to gather a diagnostics bundle.

Where are two valid places to generate and download a diagnostics bundle? (Choose two.)

27. When performing a SQL Server Restore Source Database operation, what is a valid reason an

administrator would choose the Restore

Location as New Location?

28. Which two profiles are required to provision a new Oracle database through Era? (Choose two.)

29. During maintenance, a team wants to power off the repository VM. The VM is not the primary or synchronized copy node.

What is the expected outcome?

30. Why would an administrator want to publish a software profile update for Microsoft SQL Server that is created in NDB?

31. When preparing to provision multiple database server VMs, an administrator is tasked with configuring this set of VMs with the same number of cores per vCPU.

What is the easiest way for the administrator to accomplish this task?

32. Which two ports can be used by external applications to make API calls to Era? (Choose two.)

33. What does an NDB compute profile contain?

34. An administrator is initially setting up Time Machine for a newly-provisioned database.

What is the maximum number of snapshots per day that can be configured in the GUI?

A. 4

B. 6

C. 8

D. 12

35. While registering an Always on Availability Group database, an administrator selects the following option:

Multiple Databases as a Group with One Time Machine

Which statement is true regarding this chosen option?

36. An administrator needs to roll back an Oracle patch on a database server VM using NDB.

What is required for this action to be successful?

37. Which default roles are available within Era for Role-Based Access Control?

38. In an Oracle upgrade scenario using Era.

If the source database is on a nor-Nutanix platform, is it possible to upgrade it with an Era workflow?

39. An administrator needs to deploy a database resilient cluster engine across three clusters.

Which database engine can be used for this scenario?

A. MariaDB

B. MysQL

C. PostgreSQL

D. Oracle

40. An administrator needs to create and refresh clones to a point in time.

NDB allows which two methods for satisfying this requirement? (Choose two.)

A. Full backups

B. Snapshots

C. VM snapshots

D. Transaction logs

41. A database is de-registered without removing the associated Time Machine.

What is the status of the Time Machine?

42. An administrator needs to perform LCM upgrades on an AHV cluster registered with NDB. The cluster hosts NDB-provisioned database server VMs that are part of a database server cluster.

What should the administrator do to allow the DB Server VMs to stay available while the cluster is being upgraded?

43. Where are two locations an administrator would find the size of a Source Database? (Choose two.)

44. An administrator has been asked to add a new Nutanix AHV cluster to the current single default container for DB provisioning.

Which configuration should be performed before enabling NDB multi-cluster?

45. An administrator needs to increase storage for a MongoDB database provisioned using NDB. After launching the NDB CLI, the administrator begins with creating the input file for this operation.

Which parameter should the administrator include within the input file?

46. 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?

47. An administrator manages an multi-cluster NDB instance with HA enabled. After failure, more than one API server VM is down.

How should the administrator restore full functionality?

A. Restart all database server VMs as NDB HA only tolerates single API server failure.

B. Manually distribute connections across remaining clusters.

C. Call Nutanix support to reset all API server connections.

D. Ensure at least one API server VM is online; the rest will recover automatically.

48. A new administrator is tasked with changing the NDB GUI password via CLl.

Which command will accomplish this task?

A. sudo passwd era

B. sudo user name admin password

C. era-server > username admin password

D. era-server > security password reset

49. When an administrator no longer wants to use a software profile version, what happens when it is deprecated?

50. How should an administrator create a database clone using the Era IJI?

51. How can NDB updates be downloaded for a dark site?

52. An administrator needs to assign a static IP address to the NDB VM using the command, shown below.

era-server > era server set ip=ip_address gateway=gatevay_address netmask=ip_J2etmas^c nameserver=nsl ntp server=ntpl

Which two parameters are optional for this command? (Choose two.)

53. Refer to the exhibit.





An administrator has configured unencrypted Active Directoiy access as shown in the exhibit.

Which port should be allowed through the firewall to ensure NDB can communicate with Active Directoiy?

A. 389

B. 636

C. 2009

D. 9440

54. What is the purpose of Data Access Management policies in NDB Multi-Cluster?

55. An administrator needs to provision multiple database clones from the same source database for different purposes, such as QA and Test/Development. To avoid resource starving, the administrator wants to differentiate VM resources for each department.

What is the most efficient way to accomplish this task?

56. NDB sends alert notifications using the configurations that were pulled from the cluster and auto-populated during the first configuration. It has been required to use a dedicated server.

Which configuration should be changed?

A. IDP configuration in Admin Center IAM page

B. Alert Email configuration in Prism Element

C. SMTP Server in NDB Service

D. SNMP configuration in Prism Central

57. An administrator was asked to change the snapshot schedule for a given database. The administrator discovered that the time machine is in a paused state.

How should the administrator change the schedule?

58. An administrator selected Bronze SLA for Era Time Machine during database registration.

Which two capabilities are supported by the Time Machine for this database? (Choose two,)

59. How is a software profile created?

60. Nutanix NDB gives an administrator the ability to create highly-available database pairs with which two databases? (Choose two.)

A. MySQL

B. PostgreSQL

C. SQL Server

D. MariaDB

61. An administrator has noticed that the automatic snapshot and log catch-up (automatic and manual) activities for a Time Machine are halted and manual snapshots cannot be created.

What status is this Time Machine in?

62. Refer to the exhibit.





An administrator is attempting to take a manual snapshot of a database in ND8 on an AHV cluster. There are multiple Nutanix clusters in this environment and the administrator would like to replicate the snapshot to one of the remote clusters. When attempting to take the snapshot, only a single cluster appears, as shown in the exhibit.

What is the most likely reason that only a single cluster is shown?

A. The remote clusters are running ESXi.

B. The snapshot will be too big to replicate to a remote cluster.

B. NDB Multi-cluster has not been enabled.

C. The remote clusters have an older version of AOS installed.

63. Refer to the exhibit.





An administrator, whose accounts are shown in the exhibit, is trying to add a new database admin as a local user to NDB, but is unable to complete the task.

What is most likely the cause of the issue?

64. An administrator needs to restore a database provisioned on Storage Spaces. The virtual disks are

shared with multiple databases.

Which restore method is supported?

65. Which file format is available when downloading a list of alerts?

A. xlsx

B. csv

C. xml D.pdf

66. 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?

67. An administrator needs to take multiple snapshots per day and retain them for one week.

How should the administrator define and schedule the SLA?

68. Which file type must be downloaded from the Nutanix Portal for NDB deployment?

69. An administrator is managing a high availability (HA) NDB environment and has been tasked to configure custom SSL certificates.

Which server instances must be updated?

70. An NDB administrator is looking to free up some space consumption in the container that NDB uses to manage a database landscape.

Where are two of the best locations within NDB that the administrator could view to see where the most storage is being consumed, in order to research for reclamation? (Choose two.)

A. NDB Dashboard and view the Clone Data Age in days.

B. View the Source Database grid to determine the size and status of registered databases.

C. View the Clone Database table to determine the Size and Last Refresh of clone databases.

D. View the Snapshot table in Time Machine to determine Reclaimable Space and Age of snapshots that have been taken.

71. What is the most efficient way to get information on REST APIs for a task in Era?

72. Where can an administrator configure a custom SSL certificate for Era?

73. An administrator has been tasked with OS and database patching in a Nutanix NDB environment. The administrator wishes to automate these activities.

What should the administrator configure to accomplish this task?

74. An administrator needs to work with databases and time machines, but not database parameter profiles.

Which role satisfies this requirement?

75. Execute: security password reset

76. Within NDB, an administrator needs to register a PostgreSQL database server VM with a database. Where should the database data and log files be located in order to successfully complete this task?