Anaconda Certified Professional (ACP) — Questions and Answers

Question 1: Which scenario would require a anaconda certified professional professional to escalate a package management & environment configuration concern?

Discouraging critical feedback to maintain team morale
Collecting feedback only during formal review periods
Using feedback solely for personnel evaluations
Creating feedback mechanisms that encourage continuous improvement (Correct answer)

Correct answer: Creating feedback mechanisms that encourage continuous improvement

Creating feedback mechanisms that encourage continuous improvement is the correct approach because effective package management & environment configuration in the anaconda certified professional field requires adherence to professional standards, evidence-based practices, and systematic methodology. This approach ensures consistent, high-quality outcomes while maintaining professional accountability.

Question 2: When building a data pipeline, what does the term 'idempotency' mean in the context of pipeline task execution?

A task automatically retries on failure
A task runs in parallel with zero overhead
A task can process data from any source format
Running a task multiple times produces the same result as running it once (Correct answer)

Correct answer: Running a task multiple times produces the same result as running it once

An idempotent pipeline task can be safely re-executed without side effects — running it once or ten times yields the same final state, which is critical for reliable data engineering.

Question 3: In a compliance-focused deployment, why is it important to set `channel_alias` in the conda configuration?

To give channels shorter names for faster typing
To enable offline mode automatically
To redirect all channel requests through an approved internal proxy or mirror (Correct answer)
To assign default environment names

Correct answer: To redirect all channel requests through an approved internal proxy or mirror

`channel_alias` redirects channel lookups to an internal server, ensuring all package traffic flows through a controlled, monitored endpoint rather than the public internet.

Question 4: Which method is used in Pandas to create summary statistics of a dataset?

merge()
head()
describe() (Correct answer)
groupby()

Correct answer: describe()

The `describe()` method in Pandas generates summary statistics, including mean, standard deviation, and percentiles of a dataset.

Question 5: In pandas, which method converts a column's data type (e.g., from object/string to numeric or datetime)?

df['col'].astype() (Correct answer)
df['col'].to_type()
df['col'].convert()
df['col'].cast()

Correct answer: df['col'].astype()

`df['col'].astype(dtype)` casts a Series to the specified dtype (e.g., `int64`, `float32`, `str`), and `pd.to_datetime()` / `pd.to_numeric()` handle specialized conversions.

Question 6: Which machine learning algorithm is best for classification tasks?

Random Forest (Correct answer)
Naïve Bayes
Linear regression
K-Means Clustering

Correct answer: Random Forest

The Random Forest algorithm is commonly used for classification problems due to its ability to handle large datasets and prevent overfitting.

Question 7: In the context of anaconda certified professional, which principle most directly governs data visualization & analysis practices?

Applying evidence-based methodologies with peer-reviewed support (Correct answer)
Using trial-and-error without systematic documentation
Following popular trends without evaluating their applicability
Relying exclusively on vendor-provided solutions

Correct answer: Applying evidence-based methodologies with peer-reviewed support

Applying evidence-based methodologies with peer-reviewed support is the correct approach because effective data visualization & analysis in the anaconda certified professional field requires adherence to professional standards, evidence-based practices, and systematic methodology. This approach ensures consistent, high-quality outcomes while maintaining professional accountability.

Question 8: In a data engineering context, what is the purpose of using Dask instead of pandas for large dataset processing in Python?

Dask replaces pandas with a SQL-only interface
Dask is only used for streaming real-time data
Dask provides faster single-threaded operations than pandas
Dask enables parallel and out-of-core computation on datasets larger than RAM (Correct answer)

Correct answer: Dask enables parallel and out-of-core computation on datasets larger than RAM

Dask partitions large datasets into chunks and processes them in parallel across cores or a cluster, handling data that exceeds available memory with a pandas-compatible API.

Question 9: In pandas, which method is used to apply a custom function to every row or column of a DataFrame?

df.apply() (Correct answer)
df.transform()
df.map()
df.execute()

Correct answer: df.apply()

`df.apply()` applies a function along an axis (rows with `axis=1`, columns with `axis=0`), enabling custom transformations across the entire DataFrame.

Question 10: Which SQLAlchemy function is used alongside pandas `read_sql()` to connect to a database and execute SQL queries into a DataFrame?

open_session()
connect_db()
create_engine() (Correct answer)
make_connection()

Correct answer: create_engine()

`create_engine('dialect+driver://user:pass@host/db')` from SQLAlchemy creates a connection engine that pandas `read_sql()` uses to execute queries and return results as a DataFrame.

Question 11: In conda packaging terminology, what is a 'noarch' package?

A package compiled without architecture-specific optimizations
A package that skips the test phase
A platform-independent package that installs on any OS/architecture (Correct answer)
A package with no dependencies

Correct answer: A platform-independent package that installs on any OS/architecture

A `noarch` package (typically `noarch: python`) contains no compiled binaries and can be installed on any platform, eliminating the need to build per-OS variants.

Question 12: When processing a large dataset in chunks to avoid memory overflow, which pandas parameter in `read_csv()` controls how many rows are loaded per iteration?

max_rows
nrows
batch_size
chunksize (Correct answer)

Correct answer: chunksize

Setting `chunksize=N` in `pd.read_csv()` returns a `TextFileReader` iterator where each iteration yields a DataFrame of N rows.

Question 13: What is a `.conda` file format compared to the older `.tar.bz2` conda package format?

A zip-based format with separate metadata and data archives for faster extraction (Correct answer)
A format that only stores pure-Python packages
An encrypted package for enterprise distribution
A format exclusive to Windows platforms

Correct answer: A zip-based format with separate metadata and data archives for faster extraction

The `.conda` format is a zip archive containing separate `pkg-*.tar.zst` (data) and `info-*.tar.zst` (metadata) components, enabling faster installs by extracting only needed parts.

Question 14: What is an advantage of using AI in data analysis?

Automates data analysis and pattern recognition (Correct answer)
Requires no computational resources
Increases manual workload
Reduces accuracy in predictions

Correct answer: Automates data analysis and pattern recognition

AI enables automation of complex data analysis, allowing for faster insights and pattern recognition across large datasets.

Question 15: In a meta.yaml recipe, where do you specify packages that are needed ONLY during the build process (e.g., compilers)?

requirements: run
requirements: host
requirements: test
requirements: build (Correct answer)

Correct answer: requirements: build

The `requirements: build` section lists cross-compilation tools and compilers that run on the build machine but are not needed in the final environment.

Question 16: Which chart type is best for showing data trends over time?

Scatter plot
Pie chart
Histogram
Line chart (Correct answer)

Correct answer: Line chart

A line chart is ideal for visualizing trends over time, showing how values change continuously.

Question 17: When a conda package recipe uses `{{ version }}` in meta.yaml, where is the value of `version` typically sourced from?

From a .version file in the source directory
Automatically from PyPI
From an environment variable named VERSION
From a set statement at the top of meta.yaml using Jinja2 templating (Correct answer)

Correct answer: From a set statement at the top of meta.yaml using Jinja2 templating

Jinja2 `{% set version = '1.2.3' %}` at the top of meta.yaml assigns the variable, which is then referenced as `{{ version }}` throughout the recipe for DRY versioning.

Question 18: Which pandas method stacks a DataFrame from wide format (one column per variable) to long format (one row per observation)?

df.melt() (Correct answer)
pd.wide_to_long()
df.stack()
df.pivot()

Correct answer: df.melt()

`df.melt()` unpivots a DataFrame from wide to long format by converting specified columns into rows, creating `variable` and `value` columns.

Question 19: Which conda command verifies the integrity of downloaded packages using cryptographic checksums?

conda verify (Correct answer)
conda package --verify
conda clean --verify
conda install --check-integrity

Correct answer: conda verify

`conda verify` checks package archives and installed packages against their expected checksums and metadata to detect tampering or corruption.

Question 20: What is the role of the `source` section in a conda meta.yaml recipe?

Configures the build machine's source environment
Specifies where to fetch the package source code (URL, git repo, or local path) (Correct answer)
Defines the Python source files to include
Lists the source channels to search for dependencies

Correct answer: Specifies where to fetch the package source code (URL, git repo, or local path)

The `source` section tells conda-build where to download or copy the package source, supporting URLs with checksums, git repositories, and local directory paths.

Question 21: In an ETL pipeline using pandas, which operation is used to combine two DataFrames based on a shared key column (similar to a SQL JOIN)?

pd.combine()
pd.concat()
pd.join_tables()
pd.merge() (Correct answer)

Correct answer: pd.merge()

`pd.merge()` performs database-style joins between DataFrames on one or more key columns, supporting inner, outer, left, and right join types.

Question 22: Which conda command exports a complete list of all packages in the current environment to a file for reproducibility?

conda env export > environment.yml (Correct answer)
conda freeze > requirements.txt
conda list --export > packages.txt
conda save environment.yml

Correct answer: conda env export > environment.yml

`conda env export > environment.yml` captures all packages, versions, and channels in the active environment into a YAML file that can recreate the environment elsewhere.

Question 23: What is the recommended practice to prevent supply chain attacks when using conda?

Always use the `--force-reinstall` flag
Pin package versions and restrict channels to trusted internal mirrors (Correct answer)
Disable SSL verification to speed up downloads
Use `conda update --all` before every project run

Correct answer: Pin package versions and restrict channels to trusted internal mirrors

Pinning exact package versions and sourcing only from vetted internal mirrors reduces the risk of a malicious package being silently introduced into the environment.

Question 24: In pandas, which method writes a DataFrame to a SQL database table using a SQLAlchemy engine?

df.to_sql() (Correct answer)
df.write_sql()
df.export_sql()
df.to_database()

Correct answer: df.to_sql()

`df.to_sql('table_name', engine, if_exists='replace')` writes DataFrame contents to a SQL table, with options to append, replace, or fail if the table exists.

Question 25: In a conda recipe, where would you add a `run_test.py` script to verify the package works after installation?

In a separate test-requirements.txt file
In the test section of meta.yaml or as a run_test.py file in the recipe directory (Correct answer)
In the source section of meta.yaml
In the build section of meta.yaml

Correct answer: In the test section of meta.yaml or as a run_test.py file in the recipe directory

The `test` section in meta.yaml (or a `run_test.py` file alongside the recipe) specifies imports, commands, and scripts that conda-build runs to validate the installed package.

Question 26: Which method in pandas handles missing values by filling them with a specified value or strategy (e.g., forward fill)?

df.impute()
df.replace_nan()
df.fillna() (Correct answer)
df.dropna()

Correct answer: df.fillna()

`df.fillna(value)` replaces NaN values with a constant or uses methods like `ffill` (forward fill) and `bfill` (backward fill) to propagate adjacent valid values.

Question 27: When configuring a conda channel with `channel_priority: strict`, what is the security benefit?

It disables third-party channel access entirely
It ensures packages are only resolved from the highest-priority channel, avoiding accidental use of untrusted channels (Correct answer)
It forces HTTPS on all channel URLs
It prevents older package versions from being installed

Correct answer: It ensures packages are only resolved from the highest-priority channel, avoiding accidental use of untrusted channels

With `channel_priority: strict`, conda resolves packages exclusively from the first matching channel in the priority list, preventing lower-priority (potentially untrusted) channels from supplying packages.

Question 28: What is an advantage of using Conda over pip?

Conda does not handle dependencies
Pip provides better dependency resolution
Conda is only for machine learning projects
Conda supports multiple programming languages (Correct answer)

Correct answer: Conda supports multiple programming languages

Conda manages packages and dependencies across multiple languages, whereas pip is limited to Python packages only.

Question 29: Which command is used to scan a conda environment for known security vulnerabilities?

conda check --vulnerabilities
conda verify --cve
conda audit (Correct answer)
conda scan --security

Correct answer: conda audit

`conda audit` is the built-in Anaconda tool that scans packages in an environment against known CVE databases.

Question 30: Which Anaconda feature allows administrators to audit which users installed or updated packages in a shared enterprise environment?

PM2 process logs
Anaconda Nucleus activity logs (Correct answer)
environment.yml diff tracking
conda history --users

Correct answer: Anaconda Nucleus activity logs

Anaconda Nucleus and enterprise repository solutions maintain activity logs that record user actions such as package installs and updates for compliance auditing.

Question 31: In pandas, what does `groupby()` followed by `agg()` allow you to do?

Filter rows based on group membership
Join two DataFrames on a common group key
Sort a DataFrame by multiple columns
Apply multiple aggregation functions to groups simultaneously (Correct answer)

Correct answer: Apply multiple aggregation functions to groups simultaneously

`df.groupby('col').agg({'col1': 'sum', 'col2': 'mean'})` groups rows and applies different aggregation functions to different columns in one vectorized operation.

Question 32: In Anaconda's role-based access control (RBAC), which role typically has permission to publish packages to a private channel?

Read-only collaborator
Contributor or higher (e.g., Owner) (Correct answer)
Viewer
Anonymous user

Correct answer: Contributor or higher (e.g., Owner)

In Anaconda's RBAC model, Contributor or Owner roles have the necessary permissions to upload and publish packages to private organizational channels.

Question 33: Which pandas method reads a CSV file into a DataFrame and can handle large files by specifying a `chunksize` parameter?

pd.from_csv()
pd.read_csv() (Correct answer)
pd.read_table()
pd.load_csv()

Correct answer: pd.read_csv()

`pd.read_csv()` is the standard function for loading CSV data into a DataFrame, and its `chunksize` parameter returns an iterator of DataFrame chunks for memory-efficient processing.

Question 34: Which tool or methodology is most appropriate for analyzing machine learning & ai integration outcomes?

Adjusting boundaries based on individual situations without guidelines
Maintaining professional boundaries while building collaborative relationships (Correct answer)
Prioritizing relationships over professional standards
Maintaining strict formality that inhibits collaboration

Correct answer: Maintaining professional boundaries while building collaborative relationships

Maintaining professional boundaries while building collaborative relationships is the correct approach because effective machine learning & ai integration in the anaconda certified professional field requires adherence to professional standards, evidence-based practices, and systematic methodology. This approach ensures consistent, high-quality outcomes while maintaining professional accountability.

Question 35: After building a conda package locally, which flag do you use with `conda install` to install it directly from the local build output directory?

--use-local (Correct answer)
--file
--local
--offline

Correct answer: --use-local

The `--use-local` flag instructs conda to search the local package cache (typically `~/anaconda3/conda-bld/`) before checking remote channels.

Question 36: What is the purpose of the `build_number` field in a meta.yaml recipe?

Specifies the conda-build version required
Sets the Python version for the build
Distinguishes multiple builds of the same package version (Correct answer)
Defines the number of parallel build jobs

Correct answer: Distinguishes multiple builds of the same package version

The `build_number` increments when a recipe is rebuilt without changing the package version, allowing conda to distinguish between different builds of the same release.

Question 37: In the context of anaconda certified professional, which principle most directly governs python programming & data science practices?

Relying exclusively on vendor-provided solutions
Using trial-and-error without systematic documentation
Following popular trends without evaluating their applicability
Applying evidence-based methodologies with peer-reviewed support (Correct answer)

Correct answer: Applying evidence-based methodologies with peer-reviewed support

Applying evidence-based methodologies with peer-reviewed support is the correct approach because effective python programming & data science in the anaconda certified professional field requires adherence to professional standards, evidence-based practices, and systematic methodology. This approach ensures consistent, high-quality outcomes while maintaining professional accountability.

Question 38: Which file format does `conda audit` primarily reference to identify vulnerable package versions?

NIST NVD / OSV database feeds (Correct answer)
environment.yml
conda-lock.yml
requirements.txt

Correct answer: NIST NVD / OSV database feeds

`conda audit` queries vulnerability databases such as the NIST National Vulnerability Database (NVD) and OSV to match installed packages against known CVEs.

Question 39: What is the recommended frequency for reviewing and updating data visualization & analysis protocols?

Reviewing results only at year-end
Relying on periodic external audits as the sole evaluation method
Monitoring outcomes through regular data collection and trend analysis (Correct answer)
Tracking activity volume without measuring quality

Correct answer: Monitoring outcomes through regular data collection and trend analysis

Monitoring outcomes through regular data collection and trend analysis is the correct approach because effective data visualization & analysis in the anaconda certified professional field requires adherence to professional standards, evidence-based practices, and systematic methodology. This approach ensures consistent, high-quality outcomes while maintaining professional accountability.

Question 40: To install a package from a private Anaconda.org channel owned by user `myorg`, which flag do you add to `conda install`?

--private myorg
--org myorg
-c myorg (Correct answer)
--repo myorg

Correct answer: -c myorg

The `-c myorg` (or `--channel myorg`) flag tells conda to search the `myorg` channel on Anaconda.org before the default channels.

Question 41: Which file is used to export a Conda environment configuration?

conda.config
requirements.txt
setup.py
environment.yml (Correct answer)

Correct answer: environment.yml

The `environment.yml` file allows users to export and share Conda environments with dependencies for consistent setups.

Question 42: Which file in a conda environment records the exact package versions and build strings for full reproducibility and security auditing?

requirements.txt
environment.yml
conda-lock.yml (Correct answer)
setup.cfg

Correct answer: conda-lock.yml

`conda-lock.yml` captures exact package versions, build strings, and hashes, making it the authoritative lockfile for both reproducibility and security auditing.

Question 43: Which conda configuration setting allows an organization to mirror Anaconda's default channel on a private server for security compliance?

channel_mirror
offline_mode
proxy_servers
default_channels (Correct answer)

Correct answer: default_channels

The `default_channels` setting can be overridden to point to an internal mirror, so all package requests go through a controlled, audited repository.

Question 44: When automating a data pipeline on a schedule using cron or a task scheduler, which Python standard library module provides programmatic access to run shell commands and subprocesses?

os.system only
threading
subprocess (Correct answer)
shutil

Correct answer: subprocess

The `subprocess` module provides `subprocess.run()` and `Popen` for launching external processes, capturing output, and handling errors within automated Python pipeline scripts.

Question 45: What command renders the final meta.yaml for a recipe after applying all variant substitutions, without actually building it?

conda inspect recipe
conda-build --render
conda render (Correct answer)
conda-build --dry-run

Correct answer: conda render

`conda render` processes all Jinja2 templating and variant configs in a recipe and outputs the fully resolved meta.yaml without triggering a build.

Question 46: Which Python library is specifically designed for defining, scheduling, and monitoring data pipeline workflows as Directed Acyclic Graphs (DAGs)?

All of the above (Correct answer)
Apache Airflow
Prefect
Luigi

Correct answer: All of the above

Luigi, Apache Airflow, and Prefect are all Python-native workflow orchestration frameworks that model pipelines as DAGs with scheduling and monitoring capabilities.

Question 47: Which Python library provides the `Pipeline` class to chain preprocessing steps and a final estimator into a single reusable workflow object?

scikit-learn (Correct answer)
numpy
scipy
pandas

Correct answer: scikit-learn

scikit-learn's `Pipeline` chains transformers and a final estimator so that `fit` and `predict` calls automatically apply all steps in sequence.

Question 48: Which Python library provides the `Parquet` file format support for high-performance columnar storage of DataFrames?

feather
h5py
openpyxl
pyarrow (Correct answer)

Correct answer: pyarrow

`pyarrow` (and `fastparquet`) enables pandas to read/write Parquet files via `df.to_parquet()` and `pd.read_parquet()`, offering efficient columnar compression for large datasets.

Question 49: In Anaconda Enterprise, which feature restricts users to installing packages only from approved internal channels?

Package allowlisting via channel configuration (Correct answer)
conda lock enforcement
Channel pinning
Namespace isolation

Correct answer: Package allowlisting via channel configuration

Package allowlisting via channel configuration ensures only vetted, approved packages from internal mirrors can be installed, enforcing compliance.

Question 50: What file is required at the root of a conda package recipe to define its build metadata and dependencies?

setup.py
conda.yaml
meta.yaml (Correct answer)
build.sh

Correct answer: meta.yaml

The meta.yaml file is the recipe descriptor that defines package name, version, source, build requirements, and runtime dependencies for conda-build.

Question 51: What is the purpose of NumPy in Python?

Performing web scraping
Handling multi-dimensional arrays (Correct answer)
Building machine learning models
Creating interactive plots

Correct answer: Handling multi-dimensional arrays

NumPy provides support for large, multi-dimensional arrays and matrices, along with a collection of mathematical functions to operate on them.

Question 52: When running `conda audit` on an environment, what output indicates that a package has a critical severity vulnerability?

A CRITICAL severity tag with the associated CVE ID (Correct answer)
A broken-pipe error in the terminal
A yellow WARNING label
An asterisk (*) next to the package name

Correct answer: A CRITICAL severity tag with the associated CVE ID

`conda audit` outputs vulnerability entries with severity labels (LOW, MEDIUM, HIGH, CRITICAL) alongside the CVE identifier for traceability.

Question 53: Which pandas method efficiently removes duplicate rows from a DataFrame, keeping only the first occurrence by default?

df.unique_rows()
df.drop_duplicates() (Correct answer)
df.remove_duplicates()
df.deduplicate()

Correct answer: df.drop_duplicates()

`df.drop_duplicates()` returns a DataFrame with duplicate rows removed, with `keep='first'` as default and options for `keep='last'` or `keep=False` to drop all duplicates.

Question 54: Which conda-build command is used to build a package from a local recipe directory called `my-package`?

conda install my-package
conda create my-package
conda-build my-package (Correct answer)
conda package my-package

Correct answer: conda-build my-package

Running `conda-build my-package` processes the recipe in that directory and produces a .tar.bz2 or .conda artifact.

Question 55: What is the purpose of the `.condarc` `allowlist_channels` (formerly `whitelist_channels`) key?

Restricts conda to only use the listed channels, blocking any others (Correct answer)
Lists channels that are always searched last
Caches the listed channels for offline use
Marks channels as read-only

Correct answer: Restricts conda to only use the listed channels, blocking any others

`allowlist_channels` enforces that conda will only communicate with the explicitly listed channels, preventing use of unauthorized or potentially malicious package sources.

Question 56: In the context of anaconda certified professional, which principle most directly governs package management & environment configuration practices?

Applying evidence-based methodologies with peer-reviewed support (Correct answer)
Following popular trends without evaluating their applicability
Using trial-and-error without systematic documentation
Relying exclusively on vendor-provided solutions

Correct answer: Applying evidence-based methodologies with peer-reviewed support

Applying evidence-based methodologies with peer-reviewed support is the correct approach because effective package management & environment configuration in the anaconda certified professional field requires adherence to professional standards, evidence-based practices, and systematic methodology. This approach ensures consistent, high-quality outcomes while maintaining professional accountability.

Question 57: Which command checks a built conda package for common packaging issues such as missing files or incorrect metadata?

conda audit
conda inspect (Correct answer)
conda verify
conda-build --check

Correct answer: conda inspect

`conda inspect` provides subcommands like `conda inspect linkages` and `conda inspect objects` to audit installed packages for linking issues and metadata correctness.

Question 58: Which Anaconda-hosted service allows you to upload and share your built conda packages publicly or within a team?

conda-forge
Binstar
PyPI
Anaconda.org (Correct answer)

Correct answer: Anaconda.org

Anaconda.org (formerly Binstar) is the cloud repository where users and organizations can upload, manage, and share conda packages and channels.

Question 59: What is the recommended frequency for reviewing and updating machine learning & ai integration protocols?

Tracking activity volume without measuring quality
Reviewing results only at year-end
Monitoring outcomes through regular data collection and trend analysis (Correct answer)
Relying on periodic external audits as the sole evaluation method

Correct answer: Monitoring outcomes through regular data collection and trend analysis

Monitoring outcomes through regular data collection and trend analysis is the correct approach because effective machine learning & ai integration in the anaconda certified professional field requires adherence to professional standards, evidence-based practices, and systematic methodology. This approach ensures consistent, high-quality outcomes while maintaining professional accountability.

Question 60: Which conda-build feature allows you to build multiple variants of a package (e.g., different Python versions) from a single recipe?

conda-matrix
variant_config.yaml
build_variants.cfg
conda_build_config.yaml (Correct answer)

Correct answer: conda_build_config.yaml

The `conda_build_config.yaml` file defines variant matrices (e.g., `python: [3.9, 3.10, 3.11]`) so conda-build automatically produces one package per combination.

Anaconda Certified Professional (ACP)

The Anaconda Certified Professional (ACP) exam validates expertise in the Anaconda data science platform, covering conda package management, data engineering and workflow automation, and machine learning and AI integration using Python.

Questions

90 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds