nutanix‐database‐automation‐ncp‐db‐ncp‐db‐65‐exam‐questions_8 - itnett/FTD02H-N GitHub Wiki
Here's a comprehensive table focused on exam questions involving ports, limitations, resource requirements, cluster requirements, counts (snapshots, backups), versions, periods, and intervals. This table will help you easily memorize the specific numbers, values, and configurations that are often tested in the NCP-DB exam.
NCP-DB Exam Cheat Sheet: Ports, Limits, Requirements, Counts, Versions, and Intervals
| Topic Area | Do Not Answer This (Incorrect Choice) | Choosing This is the Safest Choice (Correct Answer) |
|---|---|---|
| Ports for NDB Communication | "Only port 22 is needed for NDB communication." | "Ports 443 (HTTPS), 9440 (Prism Central), 3205, 3260 (iSCSI) are required." |
| Ports for iSCSI Connections | "iSCSI uses ports 80 and 443." | "iSCSI connections use ports 3205 (iSCSI initiator) and 3260 (iSCSI target)." |
| Ports for NDB and Controller VM Communication | "NDB communicates with Controller VMs on port 8080." | "Open ports 3205 and 3260 for NDB communication with Controller VMs." |
| Ports for Active Directory Integration | "AD integration uses port 3389." | "NDB uses ports 389 (LDAP) or 636 (LDAPS) for Active Directory integration." |
| Minimum Frequency for Log Catch-Up | "The shortest interval is 5 minutes." | "The minimum configurable frequency for log catch-up is 15 minutes." |
| Alert Retention Period | "Alerts are retained for 30 days." | "Alerts are retained for a default period of 180 days." |
| Backup Retention for SLAs | "Backups are kept for a default of 7 days." | "Backup retention is defined by SLA settings (e.g., Continuous: 30 days, Daily: 90 days)." |
| Continuous Log Retention | "Continuous logs are retained indefinitely." | "Continuous logs are retained as defined in the SLA (e.g., 7 days, 30 days)." |
| Minimum Storage for Oracle Grid Home | "Only 5GB of space is needed." | "Ensure a minimum of 15GB available for Oracle Grid home." |
| Number of NDB Agents per Cluster | "Multiple NDB Agents are required per cluster." | "One NDB Agent per Nutanix cluster is sufficient." |
| NDB HA VM Deployment Requirement | "API Server can be on a different L2 network." | "Deploy the API Server on the same L2 network as other NDB components." |
| Default Number of Snapshots Retained | "Snapshots are retained indefinitely by default." | "SLAs define snapshot retention periods (e.g., Daily: 7 days, Weekly: 16 weeks)." |
| Default Alert Policies Setting | "All alert policies are disabled by default." | "All alert policies are enabled by default." |
| Repository Configuration for Patching | "Patching can be done without repository configuration." | "Configure a Repository Profile to define where OS patches are fetched." |
| Minimum Cores and Memory for NDB Installation | "NDB requires only 2 cores and 4GB of RAM." | "Minimum of 4 vCPUs, 1 core per CPU, and 16GB RAM is required." |
| Database Server VM Registration Ports | "Any open port will work for VM registration." | "Ensure TCP Port 9440 connection to Prism Element and TCP Port 5985 for WinRM." |
| Minimum NDB Agent Requirements | "NDB Agent requires 8GB of RAM." | "NDB Agent requires 16GB of RAM and 4 vCPUs for optimal performance." |
| NDB User Interface Language Options | "NDB supports all languages." | "NDB UI supports English, German, and Japanese." |
| Minimum Intervals for Database Snapshots | "Snapshots can be taken every 5 minutes." | "Snapshots can be configured at daily, weekly, or longer intervals." |
| Patching Interval Recommendations | "Patching should be done as frequently as possible." | "Schedule patching during a Maintenance Window to minimize disruptions." |
| Ports for SQL Server AG Provisioning | "Use port 443 for SQL AG provisioning." | "Use TCP port 9389 on the domain controller for SQL AG provisioning." |
| Backup Interval for Database Protection | "Backups should be taken only once a month." | "Configure backups in SLAs (e.g., daily snapshots, weekly retention)." |
| Retention Period for Resolved Alerts | "Resolved alerts are deleted after 30 days." | "By default, resolved alerts are deleted after 180 days." |
| Log Catch-Up Operation Intervals | "Logs are captured every hour by default." | "Configure log catch-up at intervals between 15 minutes and 2 hours." |
| Minimum Disk Space for Repository Profile | "Only 5GB of space is needed for the repository." | "Ensure the repository profile has sufficient space, typically at least 10GB." |
| Requirements for Patching a Linux OS | "No repository configuration is needed." | "Must configure the repository from which package managers fetch updates." |
| Snapshot Retention Settings in Time Machine | "Snapshots are retained for 7 days by default." | "Configure snapshot retention in Time Machine settings (e.g., 30 days)." |
| Patching Priority for Multi-Cluster Setup | "Patch all clusters simultaneously." | "Apply patches sequentially based on dependencies and priorities." |
| Compute Profile Requirements | "Compute Profile specifies only memory." | "Compute Profile specifies vCPUs, cores, memory, and storage configuration." |
| Minimum Retention for Database Backups | "Backups are kept indefinitely." | "Backups are retained according to SLAs, e.g., Daily: 30 days, Weekly: 16 weeks." |
| Log Drive Expansion Default Size | "Log drive expands by 50% by default." | "Log drive expands by a default value of 20% when usage reaches 80%." |
| Retention Period for Daily Snapshots | "Daily snapshots are retained for 1 week by default." | "Daily snapshots are retained based on SLA settings, e.g., 7 days." |
| Patching Oracle Databases with NDB | "Oracle patches can be applied without prerequisites." | "Ensure the Oracle OS version is supported on AHV and download PSUs." |
| Time Machine Log Retention Limitations | "Log retention is always set to 7 days." | "Log retention is set by SLAs and can vary (e.g., 7 days, 30 days)." |
| User Role Requirements for SQL Server | "Any user can register SQL Server databases." | "User must be a member of the sysadmin role for SQL Server registration." |
| Database Replication Frequency for NDB | "Replications can be done randomly." | "Follow SLAs for scheduled cross-cluster replication." |
| Frequency of NDB Maintenance Tasks | "Maintenance tasks can be run anytime." | "Automate repeated tasks using Maintenance Windows." |
| NDB Multi-Cluster Disablement | "You can disable multi-cluster anytime." | "NDB Multi-Cluster cannot be disabled once enabled." |
| Supported Database Engine Versions | "Any database version can be used." | "Use NDB-supported versions for compatibility." |
| Snapshots per Day Configuration | "Only one snapshot per day is allowed." | "Configure up to multiple snapshots per day in SLAs." |
| Oracle RAC Deployment Minimum Requirements | "No specific configuration is needed for RAC." | "Configure with adequate network, storage, and compute resources for RAC." |
| Patching Frequency for NDB Software Components | "Apply patches as frequently as possible." | "Patches should be applied during scheduled maintenance windows." |
| Resource Allocation for NDB VM Installation | "Allocate a minimum of 2GB of RAM." | "Allocate at least 16GB RAM and 4 vCPUs for NDB VM installation." |
| Log Retention for Database Cloning | "Logs can be retained indefinitely for cloning." | "Log retention is determined by the SLA settings (e.g., 7 days, 30 days)." |
| Snapshot Frequency for PITR | "PITR requires snapshots every 10 minutes." | "PITR requires continuous log retention and appropriately timed snapshots." |
Continuing with the table for "Do Not Answer This" (incorrect choices) and "Choosing This is the Safest Choice" (correct choices) focused on ports, limitations, resource requirements, counts, versions, periods, and intervals:
| Topic Area | Do Not Answer This (Incorrect Choice) | Choosing This is the Safest Choice (Correct Answer) |
|---|---|---|
| NDB Patch Upload Command | "Use any command format for uploading patches." | "Use upload upgrade_bundle path=path_to_upgrade_bundle for NDB offline upgrades." |
| Database Clone Retention Period | "Clones are kept indefinitely." | "Clones are managed and retained based on SLA settings." |
| Maximum Number of NDB Service VMs per Cluster | "Multiple NDB Service VMs are needed for each function." | "One NDB Server VM and one NDB Agent per cluster are sufficient." |
| Backup and Snapshot Frequency | "Backups and snapshots are the same." | "Configure backups and snapshots separately in SLAs." |
| Data Recovery Points for SLAs | "SLAs have no control over recovery points." | "SLAs define specific recovery points (e.g., Daily, Weekly, Continuous)." |
| Default Patching Frequency for Databases | "Databases should be patched weekly by default." | "Patching frequency depends on the SLA and maintenance window schedules." |
| Oracle Patching Workflow | "Apply patches directly without prerequisites." | "Download PSUs from Oracle and create a Software Profile version." |
| Log Catch-Up Operation Storage | "Logs are stored on the primary database server." | "Logs are stored in the Time Machine for consistency and recovery." |
| Alert Severity Levels in NDB | "All alerts have the same severity by default." | "Alert policies can be customized for different severity levels." |
| PostgreSQL HA Management Command | "HA can be managed with any standard command." | "Use Patroni commands for PostgreSQL HA management and failover." |
| Repository Profile for OS Patches | "Repository profiles are optional for OS updates." | "A Repository Profile must be configured for OS patches to ensure validity." |
| Patch Management for Multi-Cluster Setups | "Apply patches simultaneously across all clusters." | "Patch clusters in sequence, based on dependencies and priority." |
| Snapshot Retention for Daily Backups | "Daily snapshots are retained indefinitely." | "Daily snapshots can be retained for up to 30 days or as defined by the SLA." |
| Frequency of Continuous Log Retention | "Continuous logs can be retained for any duration." | "Continuous logs should be retained according to SLA settings (e.g., 7, 30 days)." |
| Backup Storage Requirements | "Backups can be stored on any available storage." | "Backups should be stored on configured storage that meets SLA criteria." |
| Port Configuration for Windows Server Registration | "Only port 443 is required." | "Ensure TCP port 9440 for Prism Element and TCP port 5985 for WinRM." |
| Minimum Time Interval for Alert Check | "Alerts should be checked every minute." | "Set alert checks based on business needs, usually at longer intervals." |
| Oracle Grid Home Storage Space | "Allocate any space available for Oracle Grid home." | "Ensure a minimum of 15GB storage is available for Oracle Grid home." |
| Snapshot Retention Settings in NDB | "Snapshots are managed without specific retention periods." | "Set specific retention periods for snapshots (e.g., 30 days, 16 weeks)." |
| NDB Software Profile Creation Requirements | "Only the patch file is needed." | "An installer package for the database software is required." |
| Alert Notification Methods | "NDB can send alerts only via SNMP." | "Alerts can be sent via email, SNMP, or APIs." |
| Minimum VM Size for NDB Installation | "Any VM size can be used for installation." | "Minimum requirement is 4 vCPUs, 16GB RAM for NDB VM installation." |
| Log Catch-Up Frequency Configuration | "Set log catch-up frequency to any arbitrary value." | "Configure log catch-up to run every 15 minutes to 2 hours." |
| Default Database Engine Version Support | "All versions of a database engine are supported." | "Only NDB-supported versions are compatible for deployment." |
| Continuous Log Retention Duration | "Continuous logs are retained for at least 1 year." | "Continuous logs are typically retained for 7 or 30 days based on SLA." |
| Backup Retention Period for High Availability | "Retain backups indefinitely for HA setups." | "Retention periods for backups should follow SLA definitions." |
| Minimum Configuration for NDB Repository Profiles | "Any repository configuration is sufficient." | "Repository profiles should define trusted sources for patches and updates." |
| Snapshot Creation for NDB Cloning | "Snapshots are not needed for cloning." | "Snapshots must be created and managed using Time Machine for cloning." |
| Interval for Alert Notifications | "Send alert notifications every minute." | "Alert notifications should be scheduled based on criticality and impact." |
| Patching Process for Multi-Cluster Environments | "Apply patches on all clusters at once." | "Patch clusters sequentially according to maintenance schedules." |
| Log Backup Retention Policy | "Logs should be retained forever." | "Retention policy for logs should align with business needs and SLA settings." |
| Database Patching Sequence | "Patch databases in any order." | "Follow a structured sequence based on dependencies and HA requirements." |
| Compute Profile Details for Database VMs | "Compute Profiles are optional." | "Compute Profiles must specify vCPUs, memory, and disk resources." |
| Snapshot Frequency Settings for Time Machine | "Snapshots can be created every 5 minutes." | "Snapshots should be scheduled for daily, weekly, or other defined intervals." |
| Default Alert Policy Settings | "Alerts do not have default policies." | "All alert policies are enabled by default; customize as needed." |
| Resource Allocation for NDB Server VM | "Allocate resources dynamically based on usage." | "Allocate fixed resources (4 vCPUs, 16GB RAM) to ensure stability." |
| Log Storage Requirements for PITR | "Logs can be stored on any disk." | "Logs should be stored on disks managed by Time Machine for PITR." |
| Patching Requirements for SQL Server AG | "SQL Server AG can be patched without special configurations." | "Ensure TCP port 9389 is open and that SQL Server is properly configured." |
| Oracle Database Patching Requirements | "Oracle can be patched without version checks." | "Verify compatibility and patch prerequisites; use PSUs from Oracle." |
| Database Registration Requirements for Oracle | "Registration can be done without checking prerequisites." | "Ensure connectivity via TCP port 9440 and that iSCSI packages are installed." |
| Maintenance Window Configuration | "Run maintenance tasks at random times." | "Use a Maintenance Window to automate and schedule repeated tasks." |
| High Availability Configuration Requirements | "HA does not require specific configurations." | "Configure HA using appropriate tools (Patroni, Replica Sets, Oracle RAC)." |
| Database Cloning Frequency | "Clones can be created anytime without restrictions." | "Schedule cloning operations in accordance with business needs and SLAs." |
| PITR Configuration Requirements | "PITR works without continuous logs." | "PITR requires continuous log retention and properly scheduled snapshots." |
| Default Port for NDB API Calls | "NDB API uses only port 8080." | "NDB API requires ports 443 and 9440 for secure communication." |
| Database Restore Operations | "Restore databases without considering dependencies." | "Plan restore operations using PITR and snapshot retention policies." |
| Cluster Requirements for NDB Deployment | "Deploy NDB without considering cluster requirements." | "Ensure clusters meet compute, network, and storage requirements." |
| Log Retention Settings for Cloning Operations | "Logs can be retained indefinitely for clones." | "Logs for cloning should be retained according to SLA settings." |
Summary of Key Points to Remember:
- Ports: Familiarize yourself with ports required for different services: 443, 9440 for API and communication, 3205, 3260