CompTIA Data+ DA0-002 (V2) Exam Practice Test 1

Tailoring content differently for senior leadership versus individual contributors, based on their specific role and information needs, is the user persona type consideration, specifically C-suite versus individual contributor. Sensitive versus non-sensitive concerns confidentiality, internal versus external concerns organizational boundary, accessibility concerns usability for people with disabilities, and a mock-up is an early draft prototype rather than this role-based tailoring.

Anonymization permanently removes identifying information so individuals can never be re-identified, even by the organization that originally held the data. Masking obscures or substitutes sensitive values reversibly for internal use, encryption at rest and in transit protect data confidentiality without necessarily removing identifying information permanently, and role-based access control restricts who can view data rather than altering the data itself.

GDPR governs consent, data subject rights, and cross-border transfer requirements specifically for personal data of EU residents. PCI DSS addresses payment card data security, NIST provides broader US cybersecurity framework guidance, ISO provides international standards more broadly, and HIPAA governs health information privacy in the US rather than general EU personal data protection.

Data lineage tracks the full history of data from its original source through every transformation to its final form, exactly supporting this end-to-end traceability need.

Data that no longer matches the source system because a scheduled refresh silently failed is stale data. Excessive load time concerns how long the report takes to open, slow refresh rate concerns the speed of an active refresh, filter not working correctly concerns a filtering malfunction, and corrupt data concerns damaged rather than simply outdated data.

Real-time data versioning continuously reflects the current moment as new data arrives, rather than a saved point-in-time copy. A snapshot captures data at a specific point in time, recurring and ad hoc frequency describe how often a report is refreshed or requested, and a static dashboard shows a fixed view rather than continuously updating data.

A self-service portal gives users direct access to browse and query approved data themselves, without needing to request each report individually. An executive summary is a condensed high-level report, a static dashboard shows a fixed view, a recurring dashboard concerns scheduled refresh frequency, and snapshot versioning concerns point-in-time data capture rather than this self-directed access model.

Color schemes specifically address the selection and consistent application of colors, including accessibility considerations like color blindness and alignment with brand palettes.

A pivot table allows interactive summarization and reorganization of data by dragging fields to instantly recalculate totals across different breakdowns. A chart visually plots data, a map visualizes geographic data, an infographic combines visuals and text for a polished narrative, and a legend explains symbols within a visual rather than being a visual type itself.

Enabling logging captures detailed step-by-step execution information that can be reviewed after an issue occurs, providing more context than a bare error message. Validating the data source checks whether the source itself is correct and available, consulting vendor communities seeks external expertise, and basic SQL code review and corrupted data checks are specific issue categories rather than this detailed capture technique.

A reporting tool being unable to establish a connection to the database server at all is a connectivity-related issue. User-reported issues originate from an end user flagging a problem regardless of cause, basic SQL code issues concern query syntax errors, corrupted data concerns damaged values, and stale data concerns outdated but still-connected data rather than a complete connection failure.

Measures of central tendency, including mean, median, and mode, describe where data tends to cluster around a typical value. Measures of dispersion describe how spread out data is, logical functions evaluate true/false conditions, date functions manipulate date and time values, and string functions manipulate text values rather than describing central data location.

Descriptive statistics summarize what has already happened in the data, such as totals, averages, and historical trends, without forecasting the future. Prescriptive methods recommend specific actions, predictive methods forecast future outcomes, inferential methods draw conclusions about a population from a sample, and diagnostic is not one of the four basic statistical method categories in this objective.

A fact table stores the numeric, measurable data of a business process, such as sales quantity and revenue, at the center of a star schema. A dimension table stores descriptive attributes referenced by the fact table, a bridge table resolves many-to-many relationships between dimensions, a schema describes overall database structure, and a nested structure describes hierarchical data within semi-structured formats.

Adjusting language and avoiding jargon specifically because the audience lacks a technical background is the technical versus non-technical audience consideration. Level of detail concerns granularity regardless of audience expertise, internal versus external concerns organizational boundary, sensitive versus non-sensitive concerns data confidentiality, and user persona type concerns role-based tailoring more broadly rather than this specific technical-language adjustment.

Imputation fills in missing values using a calculated substitute, such as the median, rather than leaving them blank or removing records. Binning groups continuous values into categories, augmentation adds new data to enrich a dataset, deletion removes records or fields entirely, and parsing extracts structured information from unstructured text.

Binning groups continuous numeric values into a smaller number of discrete categories or ranges, exactly matching converting ages into defined brackets. Scaling adjusts the range of numeric values without categorizing them, standardization transforms values to a common statistical scale, imputation fills in missing values, and exploding expands a row containing multiple values into multiple separate rows.

An outlier is a value that falls far outside the expected or plausible range compared to the rest of the data, exactly matching this implausible age value. Duplication describes repeated entity records, redundancy describes unnecessarily repeated data, completeness describes whether all expected data is present, and validation describes the broader process of checking data against defined rules rather than this single extreme value.

The same real-world customer appearing as multiple separate records is duplication, while the same value being unnecessarily repeated across many tables instead of referenced from one place is redundancy. Missing values describes absent data in fields that should be populated, outliers describes unusual extreme values, and completeness describes whether all expected data is present rather than either of these two described patterns.

Indexing creates a special lookup structure on a column to speed up queries filtering or searching on that column, avoiding a full table scan. Parameterization reuses a query plan with different input values, temporary tables store intermediate results for a session, subsets limit the data being queried, and nested queries embed one query inside another.

A join combines columns from related tables based on a shared key, a union stacks rows from multiple queries with matching columns, a filter restricts returned rows by condition, and an aggregate summarizes multiple rows into a single calculated value, each serving a distinct role in query construction.

Natural language processing enables computers to work with and extract meaning from human language text, exactly matching this ticket analysis task. Robotic process automation automates repetitive rule-based tasks, deep learning generically describes a broader class of neural network techniques, foundational models generically describes large pretrained models broadly, and generative AI specifically creates new content rather than extracting information from existing text.

RStudio is an integrated development environment purpose-built for writing and running R scripts, combining a console, script editor, and plotting pane. Power BI and Tableau are business intelligence visualization tools, Anaconda is a package and environment distribution rather than an IDE itself, and DBeaver is a database management tool rather than a coding IDE.

A hybrid infrastructure model combines private, on-premises infrastructure with public cloud infrastructure, integrated together. Private alone keeps everything on owned servers, public alone runs everything on the cloud provider, containerization packages applications into portable units, and object storage is a storage type rather than an infrastructure deployment model.

A data lake stores massive volumes of raw, unprocessed data in its native format without requiring a schema upfront. A data mart is a smaller, already-structured subset for a specific business area, a data silo is isolated data inaccessible to other parts of the organization, a data lakehouse combines lake flexibility with warehouse structure, and a relational database requires a defined schema upfront.