究極のガイド準備問題NCP-DB-6.5には正確なPDF解答[2025年01月05日]
合格できるNutanixの試験問題集
質問 # 28
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?
- A. MySQL
- B. PostgreSQL
- C. Microsoft SQL
- D. Oracle
正解：A
解説：
The error message in the exhibit indicates that the operation failed during the "Create and Register Database Server VMs" step because "Provisioning of all the observers simultaneously took more than two hours." This type of error is associated with MySQL, as it involves observers which are a part of MySQL Group Replication, used for ensuring high availability1. The other options are not related to the error message, as they do not use observers or Group Replication for clustering.
Reference: 1: Nutanix Database Automation (NCP-DB) course, Module 5: Database High Availability, Lesson 5.2: MySQL Group Replication, slide 7
質問 # 29
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 be supported, but snapshot-based recovery of the databases is not supported.
- B. 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.
- C. 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
- 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.
正解：C
解説：
NDB supports two modes of log backup management for Microsoft SQL databases: NDB-managed and
3rd-party 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.
Reference: Nutanix Database Management & Automation (NDMA) course, Module 5, Lesson 5.2 - Log Backup Management Nutanix Support & Insights, Nutanix NDB User Guide v2.5, Log Backup Management
質問 # 30
What is the minimum frequency in minutes configurable for NDB Log Catch-up operation?
- A. 0
- B. 1
- C. 2
- D. 3
正解：B
解説：
The minimum frequency configurable for the NDB Log Catch-up operation is 15 minutes. This setting determines how frequently the log catch-up process runs, which is crucial for maintaining data integrity and ensuring up-to-date database states.
Reference: Nutanix Database Automation documentation, focusing on log management and catch-up operation settings.
質問 # 31
An administrator needs to provision a 3-node MSSQL Server AG with the following configuration:
* Two database server VMS including the primary replica on a local site
* A third database server VM on a remote site
How many IP addresses will the network at each site require?
- A. I Cluster VIP end I Listener IP on the local site
1 Listener IP on the local site
2 IPs in the local site and I on the remote site for the database server nodes - B. 2 Cluster VIP and 1 listener IP on the local site
- C. 1 Cluster VIP and 1 listener IP on the remote site
2 IPs in the local site and 1 on the remote site for the database server nodes
1 Cluster VIP on the local site
1 Cluster VIP and 1 Listener IP on the remote site
2 IPs in the local site and 1 on the remote site for the database server nodes - D. Cluster VIP end I Listener IP on the local site
1 Cluster VIP and 1 Listener IP on the remote site
2 IPs in the local site and 1 on the remote site for the database server nodes
正解：D
解説：
The correct answer is D.
When setting up a 3-node MSSQL Server AG with two database server VMs on a local site and a third database server VM on a remote site, the network at each site will require the following IP addresses:
1 Cluster VIP and 1 Listener IP on the local site123.
1 Cluster VIP and 1 Listener IP on the remote site123.
2 IPs in the local site and 1 on the remote site for the database server nodes123.
This configuration ensures that each node in the cluster has a unique IP address, and each cluster and listener also has a unique IP address. This is necessary for the proper functioning of the cluster and to ensure that all nodes can communicate with each other and with clients123.
質問 # 32
An administrator would like to provide a group of users the ability to add a new VLAN or IP Pool in Era.
What minimum role should the administrator assign to this group?
- A. Database Admin
- B. Database Infrastructure Admin
- C. Super Admin
- D. Infrastructure administrator
正解：D
解説：
In Nutanix Era, the ability to add a new VLAN or IP Pool is typically associated with the role of an Infrastructure Administrator12. This role has the necessary permissions to manage network configurations, including the creation of VLANs and IP Pools12. It's important to note that the exact permissions may vary depending on the specific configuration and policies of your organization12.
質問 # 33
An administrator needs to distribute NDB management plane components.
Which NDB HA VM needs to be deployed on the same L2 network?
- A. NDB Agent
- B. API Server
- C. HA Proxy VMs
- D. Repository VMs
正解：D
質問 # 34
An administrator needs to work with databases and time machines, but not database parameter profiles.
Which role satisfies this requirement?
- A. Database Infrastructure Administrator
- B. super Administrator
- C. Infrastructure Administrator
- D. Database Administrator (DBA)
正解：D
解説：
In the Nutanix Database Automation (NCP-DB) framework, the role that allows an administrator to work with databases and time machines, but not database parameter profiles, is the Database Administrator (DBA)123. This role provides the necessary permissions to manage databases and time machines, which are essential components of the Nutanix Era solution. However, it does not grant access to database parameter profiles, which are typically managed by other roles45.
質問 # 35
Which two options can NDB leverage to refresh a database clone? (Choose two.)
- A. Snapshots
- B. Cerebro logs
- C. Transaction logs
- D. Templates
正解：A、C
質問 # 36
A database administrator wants to define initialization variables for different types of database engines and workloads, like OLTP and DW.
What type of profile would be used?
- A. Compute
- B. Database Parameters
- C. Network
- D. Software Profile Version
正解：B
解説：
The database parameters profile is used to define the initialization variables for different types of database engines and workloads, such as OLTP and DW. The database parameters profile allows the database administrator to customize the configuration settings for each database engine, such as Oracle, SQL Server, PostgreSQL, and MySQL. The database parameters profile can also be applied to different database operations, such as provisioning, cloning, and patching. The database parameters profile helps to optimize the performance and functionality of the databases according to the specific requirements and best practices of each database engine and workload.
The software profile version is used to define the software version and edition for each database engine, such as Oracle 19c Enterprise Edition or SQL Server 2019 Standard Edition. The software profile version is required for provisioning new databases and patching existing databases. The software profile version helps to ensure the compatibility and compliance of the databases with the supported software versions and editions.
The network profile is used to define the network configuration and security settings for the database server VMs and the databases, such as the IP address, subnet mask, gateway, DNS, firewall rules, and SSL certificates. The network profile is required for registering new database server VMs and provisioning new databases. The network profile helps to ensure the connectivity and protection of the database server VMs and the databases within the network environment.
The compute profile is used to define the compute resources and storage policies for the database server VMs and the databases, such as the CPU, memory, disk size, disk type, compression, deduplication, and replication factor. The compute profile is required for provisioning new databases and cloning existing databases. The compute profile helps to ensure the availability and efficiency of the database server VMs and the databases within the Nutanix cluster.
Reference: Nutanix Database Management & Automation Training Course, Module 4: Nutanix Era Configuration, Lesson 4.1: Nutanix Era Configuration, slides 6-9.
Nutanix Database Management & Automation Training Course, Module 5: Nutanix Era Operations, Lesson 5.1: Nutanix Era Operations, slides 5-8, 11-12, 15-16.
質問 # 37
Which two ports can be used by external applications to make API calls to Era? (Choose two.)
- A. 0
- B. 1
- C. 2
- D. 3
正解：A、B
解説：
Nutanix Era is a database management system that provides API endpoints for automation and integration with external applications. These API calls are typically made over HTTPS for security, and the standard ports for HTTPS are 443 and 94401. Please note that the actual ports used can depend on the specific configuration of the Nutanix Era system. It's always a good idea to check the system's documentation or consult with the system administrator for the most accurate information.
質問 # 38
An administrator has configured NDB HA across multiple Nutanix clusters.
Which failure scenario will require manual interaction for the recovery?
- A. More than one API Server VM is down.
- B. One repository VM is down.
- C. More than one HA proxy VM is down.
- D. NDB Server process is down.
正解：A
質問 # 39
Which statement describes a user in Era with the Database Infrastructure Admin role?
- A. The user is able to manage software profiles, database parameter profiles and SLAs
- B. The user is able to manage database profiles, Network Profiles, database Instance parameter profiles and time machine SLA
- C. The user is able to manage software profiles, Network Profiles. database parameter profiles end Time Machine SLAs,
- D. The user is able to manage software profiles, Network Profiles. database Instance parameter profiles and time machine SLA
正解：C
解説：
The size of a database Time Machine in Nutanix Era is defined by the size of all snapshots and/or transaction logs maintained by Era1. The Time Machine leverages Nutanix's efficient snapshot technology to capture the state of the database at different points in time1. These snapshots, along with transaction logs that record changes between snapshots, constitute the data maintained by the Time Machine1. Therefore, the size of the Time Machine is determined by the total size of these snapshots and transaction logs1.
質問 # 40
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 using point in time till 10:41pm.
- B. Restore the 10:42pm snapshot.
- C. Restore using point in time till 10:42pm.
- D. Restore the 10:30pm snapshot.
正解：A
質問 # 41
An administrator needs to add a stretched VLAN across two clusters in NDB Which two prerequisites should be met prior to completing this action? (Choose two.)
- A. Both clusters must be registered in NDB.
- B. VLAN must be IPAM.
- C. Nutanix Cluster Management must be enabled.
- D. VLAN must be static.
正解：A、D
質問 # 42
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.
正解：A
質問 # 43
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?
- A. Provision a database and attach the July 31st backup from Time Machine.
- B. Restore a backup from July 31st, Recover the database to bring the database up.
- C. Create a clone from July 31st snapshot in Time Machine.
- D. Provision a database, restore the backup from Ju)' 31st, and Recover the database to bring the database up.
正解：C
解説：
Nutanix Era enables you to clone your source databases (running on Nutanix clusters) and refresh the database clones by using snapshots or transaction logs1. Era uses storage-efficient and time-efficient Nutanix snapshots, thus lowering the cost of managing multiple copies of your databases1. In this case, the administrator should create a clone from the July 31st snapshot in Time Machine to provide the legal team with the specific banking transaction event data they need for their audit1.
質問 # 44
An Era-managed production MSSQL database crashed during a busy holiday weekend and the administrator has to restore the database to the most recent timestamp with an objective to reduce the restore time and minimize data loss.
What option should the administrator do to achieve this objective?
- A. Perform Restore Source Database by selecting the current time.
- B. Perform Restore Source Database by selecting Restore time just before the database crash.
- C. Perform Restore Source Database by selecting most recent and include Tail log Backup
- D. Perform Restore Source Database by selecting the available snapshot.
正解：C
解説：
Nutanix Era is a database management solution that automates and simplifies database administration tasks such as provisioning, patching, cloning, and backup. In the event of a database crash, the most effective way to minimize data loss and reduce restore time is to perform a restore of the source database by selecting the most recent point in time and including the Tail log Backup12. The Tail log Backup includes all the transactions that have occurred since the last transaction log backup, which helps to minimize data loss. By selecting the most recent point in time for the restore, the administrator ensures that the database is restored to the state it was in just before the crash, thereby reducing the amount of data that needs to be reprocessed or reentered12. This approach aligns with the Nutanix Era's capabilities and best practices for database recovery12.
質問 # 45
An administrator needs to maintain five days of time-travel capability to any second, plus an additional seven days of discrete recovery at a daily interval.
How should the administrator define the Frequency and retention on the SLA?
- A. * Continuous log retention (days): 7
* Daily snapshot retention (days): 5 - B. * Weekly snapshot retention (weeks): 1
* Continuous log retention (days): 7 - C. * Continuous log retention (days): 5
* Weekly snapshot retention (weeks): 1 - D. * Daily snapshot retention (days): 7
* Continuous log retention (days): 5
正解：D
質問 # 46
......
Nutanix NCP-DB-6.5 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
最新NCP-DB-6.5試験問題集で有効で最新の問題集：https://jp.fast2test.com/NCP-DB-6.5-premium-file.html