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

A mock-up is an early sketch or wireframe of the planned layout and design, used to gather feedback before full development investment. KPIs are specific tracked business metrics, accessibility concerns usability for people with disabilities, user persona type concerns role-based content tailoring, and level of detail concerns content granularity rather than describing this early draft prototype concept.

Branding applies a company's official visual identity, such as its logo, typeface, and color palette, consistently across materials, distinct from a legend which explains symbols within a specific visual.

Data drift describes a dataset's statistical characteristics, such as null proportion or typical value range, shifting significantly over time compared to prior baselines. Data profiling generically describes the broader practice of analyzing data characteristics, of which drift detection is one specific output, a unit test checks individual code components, source control manages code versioning, and ISO compliance concerns adherence to international standards rather than describing this specific statistical shift pattern.

Role-based access control grants data access based on a defined job function or role, exactly matching access tied to being a nurse or billing clerk. Encryption in transit and at rest protect data confidentiality during movement or storage regardless of who can view it once decrypted, anonymization permanently removes identifying information, and masking obscures values reversibly rather than controlling access based on job role.

Retention specifically concerns how long data must be kept before deletion, per legal or regulatory requirements. Jurisdictional requirements generically describe location-based legal obligations broadly, replication concerns copying data across locations, audit generically describes broader compliance review activity, and classification categorizes data by sensitivity rather than defining its required keep-or-delete timeline.

Source validation specifically confirms the data is being pulled from the correct, current, and intended source system, which would have caught a report drawing from a deprecated version. Data filtering addresses which rows are shown, code and calc review check report code and formula logic respectively, and data structure changes monitoring flags schema modifications rather than confirming the source system identity itself is correct.

Specifically checking calculation logic in a formula-heavy tab is calc review, one of the three named review types alongside code and peer review. Code review examines the report-generating code itself, peer review generically describes having a colleague check work without specifying calculation logic specifically, source validation confirms the data source is correct and available, and monitoring alerts flag issues automatically rather than describing this manual formula-logic check.

A static dashboard shows a fixed, unchanging view generated once, with no live connection to the underlying data source afterward. A dynamic dashboard automatically updates as new data arrives, real-time describes continuously live data specifically, and ad hoc and recurring frequency alone describe delivery scheduling rather than whether the dashboard itself updates after generation.

A self-service portal lets business units browse approved reports and connect to pre-vetted datasets directly, reducing repeated requests to the central team. An executive summary is a condensed document, a static dashboard shows a fixed view, snapshot versioning concerns point-in-time data capture, and recurring frequency alone concerns scheduled delivery timing rather than this self-directed browsing and connection model.

Enabling logging captures detailed execution information, validating the data source confirms the upstream system itself is functioning correctly, and consulting vendor communities seeks external expertise from others who may have encountered the same issue, each addressing a different troubleshooting angle.

Garbled, unreadable characters caused by an incompatible file encoding is a corrupted data issue. Connectivity-related issues concern failed connections, user-reported generically describes how an issue was flagged rather than its root cause, basic SQL code issues concern query syntax errors, and stale data concerns outdated but otherwise correctly formatted figures rather than genuinely damaged or unreadable content.

Logical functions evaluate a true/false condition and return a corresponding result, exactly matching this threshold check returning 'Met' or 'Not Met.'

Examining how strongly two variables move together is a correlation analysis, a mathematical measure considered alongside central tendency and dispersion within basic statistical functions. Measures of central tendency describe a typical value, measures of dispersion describe spread, logical functions evaluate true/false conditions, and string functions manipulate text rather than measuring the relationship between two variables.

A slowly changing dimension preserves historical attribute values with effective date ranges rather than overwriting them, so past records remain accurate to the time they occurred. A fact table stores numeric measures, a bridge table resolves many-to-many relationships, schema alone describes overall structure, and a nested structure describes hierarchical data within semi-structured formats rather than historical attribute versioning.

Including full methodology and technical granularity for one audience while omitting it for another is the level of detail consideration. Internal versus external concerns organizational boundary, sensitive versus non-sensitive concerns confidentiality, accessibility concerns usability for people with disabilities, and a mock-up is an early draft prototype rather than describing this granularity-based content difference.

Calculating a new value like lifetime spend from existing data is creating a derived variable, specifically a calculated field, while removing an unused column entirely is deletion. Augmentation adds new external data to enrich a dataset, parsing extracts structured information from unstructured text, and scaling adjusts numeric ranges rather than describing either of these two described techniques.

Merging combines multiple fields or datasets together, such as combining first and last name columns into a single full name column. Appending adds new rows to an existing structure, parsing extracts structured information from unstructured or semi-structured text, exploding expands array fields into multiple rows, and deletion removes records or fields entirely rather than combining two existing fields into one.

Completeness confirms that all expected records and fields are present, exactly matching checking that no records were silently dropped during a merge. Duplication describes repeated entity records, redundancy describes unnecessarily repeated data, outliers describes unusual extreme values, and missing values specifically describes absent data within existing fields or records rather than entire records being absent from a merge result.

Inconsistent representations of the same value, such as 'CA,' 'California,' and 'calif.' all meaning the same state, is a validation issue specifically related to inconsistent formatting that fails to conform to a single expected standard. Missing values describes absent data, duplication describes repeated entity records, redundancy describes unnecessarily repeated data, and outliers describes unusual extreme values rather than inconsistent representations of the same underlying value.

Temporary tables store intermediate results for the duration of a session, avoiding recalculating the same subquery multiple times within a complex multi-step process. Indexing speeds up column lookups, parameterization reuses a query plan with different inputs, subsets limit the data being queried, and nested queries embed one query inside another rather than describing this session-scoped intermediate storage technique.

Grouping clusters records sharing a common value, such as region, and aggregate then calculates a single summarized value like total revenue for each group. Filter and join address row restriction and table combination respectively, union and concatenate combine rows or text strings, nested queries and subsets describe embedded queries and data limiting, and indexing and parameterization are optimization techniques rather than this group-and-summarize operation combination.

Generative AI produces entirely new content, such as written reports, images, or code, based on a prompt, rather than simply classifying or analyzing existing data.

Tableau is a business intelligence platform known for drag-and-drop visual analytics and strong data connectivity for building interactive dashboards. RStudio is an IDE for R scripting, Anaconda is a package and environment distribution, and DBeaver and Toad are database management tools rather than drag-and-drop visual analytics platforms.

A private infrastructure model runs entirely on owned servers within the organization's own facility, with no third-party cloud reliance. A public model runs on a third-party cloud provider's infrastructure, a hybrid model combines both private and public, containerization packages applications into portable units, and object storage is a storage type rather than an infrastructure deployment model.

Logs continuously record timestamped system events, such as logins, file access, and errors, generating a detailed chronological record. Databases store structured data broadly, APIs provide programmatic access to application data, web scraping extracts data from web pages, and files generically describe static documents rather than this continuous chronological event recording.