Question 1: What is a database audit trail used for in a regulated environment?

• Logging who accessed or modified data, when, and what changes were made for compliance and security investigations (Correct answer)
• Tracking database license usage
• Improving query performance by tracking slow queries
• Monitoring hardware resource utilization

Correct answer: Logging who accessed or modified data, when, and what changes were made for compliance and security investigations

A database audit trail logs all access and modification events—who, what, and when—to support regulatory compliance, security investigations, and accountability.

Question 2: Which concept refers to a single, authoritative definition of a business term used consistently across an organization?

• Golden Record
• Data Dictionary (Correct answer)
• Master Data Record
• Authoritative Data Source

Correct answer: Data Dictionary

A Data Dictionary provides authoritative definitions of business terms and data elements to ensure consistent understanding across the enterprise.

Question 3: In data quality, what does 'completeness' specifically measure?

• Whether all required data values are present and not null (Correct answer)
• Whether data values are accurate and reflect reality
• Whether data is consistent across systems
• Whether data is formatted correctly

Correct answer: Whether all required data values are present and not null

Completeness measures whether all required data values are present—checking for null, missing, or empty values that should contain data.

Question 4: What is the cost of poor data quality most directly associated with in business terms?

• Increased storage costs
• Flawed business decisions, wasted effort on rework, and lost revenue opportunities (Correct answer)
• Slower database query performance
• Higher database licensing fees

Correct answer: Flawed business decisions, wasted effort on rework, and lost revenue opportunities

Poor data quality leads to flawed business decisions, costly rework, regulatory fines, lost customers, and missed revenue opportunities.

Question 5: A graph showing data set comparisons.

• Scatterplot (Correct answer)
• Bar Graph
• Correlation
• Histogram

Correct answer: Scatterplot

A scatterplot is the correct chart for comparing two data sets because it plots paired values from two variables as individual points, revealing relationships or correlations. A bar graph and histogram display single-variable distributions or category counts, and 'correlation' is a statistical measure, not a type of graph.

Question 6: During a typical sort and shuffle phase of MapReduce, how are keys and data presented and delivered to Reducers?

• Keys are presented to a Reducer in random order; values for a given key are sorted in ascending order
• Keys are presented to a Reducer in sorted order; values for a given key are sorted in ascending orde
• Keys are presented to a Reducer in sorted order; values for a given key are not sorted (Correct answer)
• Keys are presented to a Reducer in random order; values for a given key are not sorted

Correct answer: Keys are presented to a Reducer in sorted order; values for a given key are not sorted

Values for a particular key are not sorted, although keys are delivered to reducers in sorted order.

Question 7: A Hadoop cluster has frequent 'GC overhead limit exceeded' errors on the NameNode. What is the most appropriate first corrective action?

• Add more DataNodes to the cluster
• Reduce the HDFS block size
• Increase heap memory allocated to the NameNode via HADOOP_NAMENODE_OPTS (Correct answer)
• Increase dfs.namenode.handler.count

Correct answer: Increase heap memory allocated to the NameNode via HADOOP_NAMENODE_OPTS

GC overhead errors on the NameNode indicate insufficient heap memory; increasing it via HADOOP_NAMENODE_OPTS is the direct fix.

Question 8: Which data integration approach provides a virtual unified view of data across multiple sources without physically moving or copying the data?

• Data replication
• Data consolidation
• Data migration
• Data federation (Correct answer)

Correct answer: Data federation

Data federation creates a virtual unified view by querying source systems on demand, leaving the data in place rather than copying it to a central repository.

Question 9: What is a surrogate key in database design?

• A system-generated, meaningless unique identifier assigned to each row in a table (Correct answer)
• A foreign key referencing another table
• A composite key made of multiple columns
• A natural business key like a Social Security Number

Correct answer: A system-generated, meaningless unique identifier assigned to each row in a table

A surrogate key is a system-generated, meaningless numeric identifier (like an auto-increment ID) used as a primary key independent of business data.

Question 10: Which command correctly increases the replication factor of an existing HDFS file to 5?

• hdfs dfs -setrep -w 5 /path/to/file (Correct answer)
• hdfs fsck -replication 5 /path/to/file
• hdfs namenode -setReplication 5 /path/to/file
• hdfs dfs -rep 5 /path/to/file

Correct answer: hdfs dfs -setrep -w 5 /path/to/file

The hdfs dfs -setrep command changes the replication factor; -w waits for the replication to complete.

Question 11: In which of the following diagrams is correlation shown?

• Boxplot
• Histogram
• Triangle
• Corrgram (Correct answer)

Correct answer: Corrgram

The correct term for the diagram used to view correlation is a "scatterplot matrix" or "scatterplot matrix diagram." A scatterplot matrix allows you to visualize the relationships between multiple variables in a dataset by plotting scatterplots of each variable against all other variables.

Question 12: What is the primary purpose of an audit trail in financial data systems?

• To compress historical financial data to save storage costs
• To provide a chronological record of all changes to financial data for accountability and compliance (Correct answer)
• To archive old financial records that are no longer actively used
• To optimize query performance on large financial datasets

Correct answer: To provide a chronological record of all changes to financial data for accountability and compliance

An audit trail logs every insert, update, and delete action with timestamps and user identifiers, supporting regulatory compliance and fraud detection.

Question 13: In data modeling, what does cardinality describe?

• The numerical relationship between instances of two entities (e.g., one-to-many) (Correct answer)
• The size of a database in gigabytes
• The number of indexes on a table
• The number of columns in a table

Correct answer: The numerical relationship between instances of two entities (e.g., one-to-many)

Cardinality describes the quantitative relationship between entity instances, such as one-to-one, one-to-many, or many-to-many relationships.

Question 14: Which Hadoop component is responsible for storing job history and providing a REST API to query completed MapReduce jobs?

• NodeManager
• ResourceManager
• ApplicationMaster
• JobHistoryServer (Correct answer)

Correct answer: JobHistoryServer

The JobHistoryServer retains logs and metrics for completed MapReduce jobs and exposes them via a web UI and REST API.

Question 15: What is a 'junk dimension' in dimensional modeling?

• An unused dimension that should be deleted
• A dimension containing low-quality data pending cleansing
• A single dimension table that consolidates miscellaneous, low-cardinality flag and indicator fields from the fact table (Correct answer)
• A dimension storing deleted historical records

Correct answer: A single dimension table that consolidates miscellaneous, low-cardinality flag and indicator fields from the fact table

A junk dimension consolidates miscellaneous boolean flags and low-cardinality indicators into a single dimension table to reduce fact table width.

Question 16: Which technique is used in Spark to avoid full data shuffles when joining a large dataset with a small one?

• Salting
• Coalescing
• Broadcast join (Correct answer)
• Repartitioning

Correct answer: Broadcast join

A broadcast join sends the smaller dataset to all worker nodes, eliminating the costly shuffle of the large dataset.

Question 17: Which financial data standard defines a common language for electronic communication of business and financial data?

• CSV
• XBRL (Correct answer)
• EDI
• JSON-LD

Correct answer: XBRL

XBRL (eXtensible Business Reporting Language) is the global standard for exchanging business and financial information.

Question 18: In the context of streaming analytics, what is 'watermarking' used for?

• Marking data lineage across distributed pipelines
• Handling late-arriving data by defining a threshold for event-time delays (Correct answer)
• Compressing stream checkpoints to reduce storage
• Encrypting data streams for security compliance

Correct answer: Handling late-arriving data by defining a threshold for event-time delays

Watermarking sets a maximum tolerated delay for late data, allowing the system to finalize window computations despite out-of-order events.

Question 19: What does 'data lineage' mean in the context of data governance?

• Defining data retention periods
• Tracking the age of data records
• Classifying data by sensitivity level
• Documenting the origin, movement, and transformation of data over time (Correct answer)

Correct answer: Documenting the origin, movement, and transformation of data over time

Data lineage tracks where data originated, how it has moved through systems, and what transformations it has undergone.

Question 20: The difference between a collection of data's top and lowest scores. Answer: Range

• TRUE (Correct answer)
• FALSE

Correct answer: TRUE

In statistics, the range refers to the difference between the highest and lowest values in a set of data. It provides a measure of the spread or variability of the data. To calculate the range, you subtract the lowest value from the highest value in the dataset.

Question 21: Which architectural pattern separates compute from storage to allow independent scaling in cloud data platforms?

• Lambda Architecture
• Federated Architecture
• Decoupled Storage-Compute Architecture (Correct answer)
• Shared-Nothing Architecture

Correct answer: Decoupled Storage-Compute Architecture

Decoupled Storage-Compute Architecture allows storage (e.g., S3) and compute (e.g., query engines) to scale independently, reducing costs and improving flexibility.

Question 22: Which data quality dimension measures whether data values conform to the correct format, type, and range?

• Completeness
• Timeliness
• Accuracy
• Validity (Correct answer)

Correct answer: Validity

Validity measures whether data values conform to defined formats, data types, and allowable ranges or domain values.

Question 23: What does the P/E ratio measure in equity financial data?

• Profit margin relative to total equity
• Portfolio exposure relative to equity capital
• Price volatility relative to earnings growth
• Price per share relative to earnings per share (Correct answer)

Correct answer: Price per share relative to earnings per share

The Price-to-Earnings ratio divides a stock's current share price by its earnings per share to indicate valuation.

Question 24: Which regulation specifically governs how healthcare organizations in the US must handle patient data?

• CCPA
• HIPAA (Correct answer)
• GDPR
• SOX

Correct answer: HIPAA

HIPAA (Health Insurance Portability and Accountability Act) sets US federal standards for protecting sensitive patient health information.

Question 25: Which of the following is a primary output of a data stewardship program?

• Faster ETL processing
• Improved data quality and trusted data assets (Correct answer)
• Reduced storage costs
• Faster query execution

Correct answer: Improved data quality and trusted data assets

Data stewardship programs primarily aim to improve data quality and create trusted, authoritative data assets for business use.

Question 26: What is a data catalog's primary function in a modern data architecture?

• Execute ETL jobs and data transformations
• Manage database user permissions
• Provide a searchable inventory of data assets with metadata, lineage, and business context (Correct answer)
• Store and process raw data at scale

Correct answer: Provide a searchable inventory of data assets with metadata, lineage, and business context

A data catalog acts as an organized inventory of data assets, providing metadata, lineage, and business context to help users discover and understand available data.

Question 27: A CDP candidate is building a data pipeline for SEC 10-K filings. Which identifier uniquely distinguishes each SEC registrant?

• LEI
• CIK (Central Index Key) (Correct answer)
• CUSIP
• ISIN

Correct answer: CIK (Central Index Key)

The SEC assigns every registrant a unique Central Index Key (CIK) used to identify filers in EDGAR.

Question 28: You are creating a combiner that receives input in text keys and IntWritable values and outputs text keys and IntWritable values. Which interface ought to be implemented by your class?

• Combiner <Text, Text, IntWritable, IntWritable>
• Reducer <Text, Text, IntWritable, IntWritable>
• Reducer <Text, IntWritable, Text, IntWritable>
• Combiner <Text, IntWritable, Text, IntWritable>

Reducer <Text, IntWritable, Text, IntWritable> is the correct syntax to implement the class.

Question 29: What does 'data deduplication' specifically address?

• Identifying and removing or merging duplicate records representing the same real-world entity (Correct answer)
• Encrypting duplicate copies of data for security
• Creating backup copies of critical data
• Compressing redundant data blocks in storage systems

Correct answer: Identifying and removing or merging duplicate records representing the same real-world entity

Data deduplication identifies records that represent the same entity (e.g., the same customer) and removes or merges them to create a single, accurate record.

Question 30: Which type of data governance maturity model stage describes ad hoc, undocumented data management with no formal policies?

• Initial/Reactive (Correct answer)
• Managed
• Defined
• Optimized

Correct answer: Initial/Reactive

The Initial or Reactive stage of data governance maturity is characterized by ad hoc, informal, and undocumented data management practices.

Question 31: What is 'data provenance'?

• The documented history of data's origin and transformations over its lifecycle (Correct answer)
• A method for encrypting sensitive data
• The geographic origin of data storage servers
• The process of archiving old data

Correct answer: The documented history of data's origin and transformations over its lifecycle

Data provenance documents the origin, custody, and transformations of data throughout its lifecycle to ensure trustworthiness and traceability.

Question 32: What is 'transparent data encryption' (TDE) in databases?

• Making encryption keys visible to database administrators
• Encrypting only specific sensitive columns in a table
• Encrypting data during transmission over the network
• Encrypting the entire database storage files at rest so data is protected if storage media is stolen (Correct answer)

Correct answer: Encrypting the entire database storage files at rest so data is protected if storage media is stolen

TDE encrypts database storage files at rest, protecting data if physical storage media is stolen or accessed without authorization, transparently to applications.

Question 33: In a Kerberos-secured Hadoop cluster, what artifact does a service use to authenticate without a human entering a password?

• LDAP token
• Knox gateway token
• SSL certificate
• Keytab file (Correct answer)

Correct answer: Keytab file

A keytab file contains encrypted Kerberos principal credentials, allowing services to obtain Kerberos tickets automatically.

Question 34: In financial data quality management, what does 'referential integrity' ensure for trade data linked to instrument master data?

• Every trade record references a valid, existing instrument in the security master (Correct answer)
• Trade timestamps are consistent across all source systems
• All trade amounts are within predefined thresholds
• Counterparty names are spelled consistently across records

Correct answer: Every trade record references a valid, existing instrument in the security master

Referential integrity enforces that foreign key values in trade records correspond to actual records in the referenced security master table.

Question 35: What distinguishes OLTP systems from OLAP systems in terms of design purpose?

• OLTP uses columnar storage; OLAP uses row-based storage
• OLTP is for complex analytics; OLAP is for simple transactions
• OLTP supports historical data; OLAP supports only current data
• OLTP is optimized for high-volume, short transactions; OLAP is optimized for complex analytical queries (Correct answer)

Correct answer: OLTP is optimized for high-volume, short transactions; OLAP is optimized for complex analytical queries

OLTP systems are designed for high-volume, short-duration transactions (insert/update/delete), while OLAP systems are designed for complex, read-heavy analytical queries.

Question 36: In a Lambda architecture, what is the primary role of the speed layer?

• Store historical batch data for long-term queries
• Provide low-latency views of recent data not yet processed by the batch layer (Correct answer)
• Merge batch and serving layer outputs into a unified view
• Compress and archive incoming streaming data

Correct answer: Provide low-latency views of recent data not yet processed by the batch layer

The speed layer processes recent data in real-time to compensate for the high latency of the batch layer.

Question 37: Which file format is optimized for columnar storage and is widely used in big data ecosystems for analytical queries?

• Parquet (Correct answer)
• Avro
• JSON
• CSV

Correct answer: Parquet

Parquet is a columnar storage format that enables efficient compression and encoding schemes, significantly improving analytical query performance.

Question 38: Under GDPR, what is the maximum time an organization typically has to report a data breach to authorities?

• 48 hours
• 72 hours (Correct answer)
• 24 hours
• 7 days

Correct answer: 72 hours

GDPR requires organizations to notify supervisory authorities of a personal data breach within 72 hours of becoming aware of it.

Question 39: What is the primary purpose of an Operational Data Store (ODS) in a data architecture?

• Providing a near-real-time, integrated view of current operational data from multiple source systems (Correct answer)
• Long-term historical reporting
• Storing raw unstructured data
• Running batch ETL processes

Correct answer: Providing a near-real-time, integrated view of current operational data from multiple source systems

An ODS integrates current operational data from multiple source systems to support short-term operational reporting and decision-making with near-real-time data.

Question 40: What is a key advantage of ELT over traditional ETL in a cloud data warehouse environment?

• ELT leverages the target system's massively parallel processing power for transformations (Correct answer)
• ELT only supports structured relational data sources
• ELT eliminates the need for any data quality checks
• ELT requires significantly less storage space in the cloud

Correct answer: ELT leverages the target system's massively parallel processing power for transformations

ELT loads raw data first, then uses the cloud data warehouse's powerful parallel processing to perform transformations, taking advantage of scalable compute resources.

Question 41: What is a Data Governance Council primarily responsible for?

• Performing daily data backups
• Writing ETL scripts
• Overseeing enterprise data governance policies and resolving data conflicts (Correct answer)
• Managing database server hardware

Correct answer: Overseeing enterprise data governance policies and resolving data conflicts

A Data Governance Council oversees the implementation of data governance policies and arbitrates disputes over data ownership and definitions.

Question 42: What is the purpose of a 'wash sale rule' in financial data compliance?

• Prevent double-counting of dividend income
• Disallow a tax loss deduction if the same security is repurchased within 30 days (Correct answer)
• Mandate daily reconciliation of trading accounts
• Require immediate settlement of all equity trades

Correct answer: Disallow a tax loss deduction if the same security is repurchased within 30 days

The IRS wash sale rule disallows claiming a capital loss if a substantially identical security is bought within 30 days before or after the sale.

Question 43: What is a conceptual data model?

• A high-level representation of business concepts and relationships without technical detail (Correct answer)
• A diagram showing ETL data flows
• A detailed physical design of database tables and indexes
• A model that defines data types and constraints

Correct answer: A high-level representation of business concepts and relationships without technical detail

A conceptual data model provides a high-level, business-focused representation of key entities and relationships without technical implementation details.

Question 44: What is the primary purpose of data skew mitigation techniques like 'salting' in distributed big data joins?

• To convert wide joins into narrow transformations
• To encrypt sensitive join keys before transmission
• To distribute data more evenly across partitions and reduce hotspots (Correct answer)
• To cache frequently joined datasets in memory

Correct answer: To distribute data more evenly across partitions and reduce hotspots

Salting adds a random prefix to skewed keys to distribute them across multiple partitions, reducing the load on overloaded nodes.

Question 45: A dot-based data graph.

• Line Plot
• Bar Graph
• Stem and leaf Plot
• Dot Plot (Correct answer)

Correct answer: Dot Plot

A dot plot is a graph that displays data using dots. It is also known as a dot chart or dot diagram. In a dot plot, each data point is represented by a dot above the corresponding value on a number line or axis.

Question 46: What is the primary goal of a Master Data Management (MDM) program?

• Automate ETL workflows
• Manage database licenses
• Create a single, consistent, authoritative view of key business entities like customers and products (Correct answer)
• Optimize database query performance

Correct answer: Create a single, consistent, authoritative view of key business entities like customers and products

MDM creates a single, trusted, authoritative record (golden record) for key business entities to eliminate duplicates and inconsistencies across systems.

Question 47: Which financial statement reports a company's revenues, expenses, and net income over a specific period?

• Statement of Retained Earnings
• Balance Sheet
• Income Statement (Correct answer)
• Statement of Cash Flows

Correct answer: Income Statement

The Income Statement (Profit & Loss Statement) summarizes revenues and expenses over a defined reporting period.

Question 48: What is a Slowly Changing Dimension (SCD) Type 2?

• A dimension where old values are overwritten with new values
• A dimension that keeps only the original value forever
• A dimension with no historical tracking
• A dimension that tracks history by adding new rows with effective date ranges when attributes change (Correct answer)

Correct answer: A dimension that tracks history by adding new rows with effective date ranges when attributes change

SCD Type 2 tracks historical changes by adding new rows with start/end dates, allowing analysis of both current and historical dimension attribute values.

Question 49: What is the purpose of normalization in relational database design?

• Eliminate data redundancy and ensure data integrity by organizing data into related tables (Correct answer)
• Create indexes for faster retrieval
• Increase storage capacity
• Improve query performance by adding redundancy

Correct answer: Eliminate data redundancy and ensure data integrity by organizing data into related tables

Normalization organizes data into related tables to eliminate redundancy, reduce anomalies, and ensure data integrity in relational databases.

Question 50: Which role is primarily responsible for defining data policies and standards within an organization?

• Database Administrator
• ETL Developer
• Data Analyst
• Data Steward (Correct answer)

Correct answer: Data Steward

Data Stewards are responsible for defining and enforcing data policies, standards, and procedures across the organization.

Question 51: What does 'grain' mean in the context of a data warehouse fact table?

• The number of rows in the fact table
• The level of detail that each row in the fact table represents (Correct answer)
• The type of aggregation applied to measures
• The number of dimensions linked to the fact table

Correct answer: The level of detail that each row in the fact table represents

The grain of a fact table defines the most atomic level of detail that each row represents, such as one row per individual sales transaction line item.

Question 52: Which technique uses statistical analysis to identify records that deviate significantly from expected patterns, indicating potential quality issues?

• Record Linkage
• Outlier Detection / Anomaly Analysis (Correct answer)
• Data Masking
• Data Standardization

Correct answer: Outlier Detection / Anomaly Analysis

Outlier and anomaly detection uses statistical methods to identify data values or records that fall outside expected ranges, signaling potential quality issues.

Question 53: What is 'goodwill' in financial data, and when does it appear on a balance sheet?

• The excess purchase price paid over the fair value of net identifiable assets in an acquisition (Correct answer)
• The estimated future earning potential of a company's brand
• The present value of future cash flows from operations
• The accumulated depreciation on all intangible assets

Correct answer: The excess purchase price paid over the fair value of net identifiable assets in an acquisition

Goodwill arises in a business combination when the acquirer pays more than the fair value of the target's identifiable net assets.

Question 54: Which approach to fixing data quality issues addresses the root cause in source systems rather than cleansing data downstream?

• Deduplication
• Data Masking
• Upstream Fix / Prevention at Source (Correct answer)
• Reactive Cleansing

Correct answer: Upstream Fix / Prevention at Source

Fixing quality issues at the source prevents them from propagating downstream, which is more effective and efficient than repeatedly cleansing after the fact.

Question 55: Which data quality dimension refers to data being available when needed for decision-making?

• Completeness
• Timeliness (Correct answer)
• Consistency
• Accuracy

Correct answer: Timeliness

Timeliness measures whether data is available and up-to-date when needed by business processes and decision-makers.

Question 56: What is the primary role of a message broker in a data integration architecture?

• Generating business intelligence reports from integrated data
• Permanently storing integrated data for analytics
• Routing messages between producers and consumers while decoupling them (Correct answer)
• Encrypting all data in transit between systems

Correct answer: Routing messages between producers and consumers while decoupling them

A message broker decouples producers and consumers by receiving messages from producers and routing them to the appropriate consumers, enabling asynchronous communication.

Question 57: Which financial data concept describes the process of matching trade confirmations between a buyer and seller to verify terms?

• Settlement finality
• Netting
• Trade confirmation/affirmation (matching) (Correct answer)
• Novation

Correct answer: Trade confirmation/affirmation (matching)

Trade matching compares buyer and seller confirmations to verify that both parties agree on the trade terms before settlement.

Question 58: What is the role of metadata in data governance?

• It performs data transformations
• It stores the actual business data
• It replaces the need for data documentation
• It provides context and information about data assets to aid in discovery and management (Correct answer)

Correct answer: It provides context and information about data assets to aid in discovery and management

Metadata provides context about data assets—such as structure, origin, and usage—enabling better discovery, understanding, and management of data.

Question 59: Which risk measure expresses the maximum expected loss over a given time period at a specified confidence level?

• Standard Deviation
• Beta
• Sharpe Ratio
• Value at Risk (VaR) (Correct answer)

Correct answer: Value at Risk (VaR)

VaR quantifies the potential loss in value of a portfolio over a defined period for a given confidence interval (e.g., 95% or 99%).

Question 60: In enterprise data architecture, what is a 'Data Domain'?

• A database server hostname
• A logical grouping of related data assets under a common subject area or business function (Correct answer)
• A network partition for data storage
• A type of data encryption algorithm

Correct answer: A logical grouping of related data assets under a common subject area or business function

A Data Domain is a logical grouping of related data (e.g., Customer, Product, Finance) organized around a common business subject area or function.

Question 61: What is the primary advantage of a Data Vault modeling approach over traditional star/snowflake schemas?

• Faster OLAP query performance
• Better auditability, flexibility for change, and support for loading from multiple source systems (Correct answer)
• Simpler queries for end users
• Reduced storage requirements

Correct answer: Better auditability, flexibility for change, and support for loading from multiple source systems

Data Vault modeling excels at auditability, handles source system changes gracefully, and supports parallel loading from multiple sources using its Hub-Satellite-Link structure.

Question 62: Which normal form requires that every non-key attribute be fully dependent on the entire primary key?

• Second Normal Form (2NF) (Correct answer)
• Boyce-Codd Normal Form (BCNF)
• Third Normal Form (3NF)
• First Normal Form (1NF)

Correct answer: Second Normal Form (2NF)

Second Normal Form (2NF) requires that a table be in 1NF and that every non-key attribute be fully functionally dependent on the entire composite primary key.

Question 63: In the context of NoSQL databases, what does 'eventual consistency' mean?

• The database schema will eventually be normalized
• Data updates will propagate to all replicas eventually, but replicas may temporarily serve stale data (Correct answer)
• All queries will eventually be optimized automatically
• The database will eventually be shut down for maintenance

Correct answer: Data updates will propagate to all replicas eventually, but replicas may temporarily serve stale data

Eventual consistency means that after an update, all replicas will eventually receive it and be consistent, but in the short term, different nodes may return slightly different values.

Question 64: In a logical data model, what is the difference from a physical data model?

• Logical models are used only by developers; physical models are for business users
• Logical models include hardware specifications; physical models do not
• Logical models define business entities and relationships without platform specifics; physical models include DBMS-specific implementation details (Correct answer)
• Logical models always use star schemas

Correct answer: Logical models define business entities and relationships without platform specifics; physical models include DBMS-specific implementation details

Logical models define entities, attributes, and relationships in business terms without DBMS specifics, while physical models include tables, data types, indexes, and storage details.

Question 65: What does ROLAP stand for in OLAP technology?

• Rapid OLAP
• Replicated OLAP
• Relational OLAP — storing OLAP data in relational database tables rather than multidimensional cubes (Correct answer)
• Remote OLAP

Correct answer: Relational OLAP — storing OLAP data in relational database tables rather than multidimensional cubes

ROLAP (Relational OLAP) generates analytical queries dynamically against relational database tables rather than pre-computing and storing results in multidimensional cubes.

Question 66: A place-valued data visualization graph.

• Frequency table
• Dot plot
• Stem and leaf plot (Correct answer)
• Bar Graph

Correct answer: Stem and leaf plot

A stem-and-leaf plot is actually a type of graph that displays data using place value. In a stem-and-leaf plot, each data point is divided into a "stem" (usually the leftmost digit(s)) and a "leaf" (the rightmost digit). The stems are listed vertically, and the corresponding leaves are placed next to their respective stems.

Question 67: What is denormalization in database design?

• Converting a relational model to a document model
• Intentionally introducing redundancy into a database to improve read performance (Correct answer)
• Removing unused tables from a schema
• The process of converting ER diagrams to physical tables

Correct answer: Intentionally introducing redundancy into a database to improve read performance

Denormalization intentionally adds redundant data to a normalized schema to reduce joins and improve query read performance, often used in data warehouses.

Question 68: In a star schema, what does the 'fact table' contain?

• Configuration settings for the data warehouse
• User access permissions
• Measurable, quantitative business metrics and foreign keys to dimension tables (Correct answer)
• Descriptive attributes about business entities

Correct answer: Measurable, quantitative business metrics and foreign keys to dimension tables

The fact table in a star schema contains quantitative business metrics (measures) and foreign keys linking to surrounding dimension tables.

Question 69: In data governance, what is a 'data steward' most likely NOT responsible for?

• Physically administering database servers (Correct answer)
• Maintaining data definitions in the business glossary
• Defining data quality rules
• Resolving data quality issues

Correct answer: Physically administering database servers

Physical database server administration is the responsibility of Database Administrators, not Data Stewards, who focus on policy, quality, and definitions.

Question 70: Why is Machine Learning Used in Data Science?

• For Visualization
• For Prediction (Correct answer)
• All the above
• For Cleaning

Correct answer: For Prediction

Machine learning plays a crucial role in data science, particularly in the context of prediction.

Question 71: What is 'data classification' in the context of information security governance?

• Sorting data alphabetically in a database
• Indexing data for faster retrieval
• Categorizing data by sensitivity level to determine appropriate security controls (Correct answer)
• Archiving old data records

Correct answer: Categorizing data by sensitivity level to determine appropriate security controls

Data classification categorizes data by sensitivity (e.g., public, internal, confidential, restricted) to apply appropriate security and handling controls.

Question 72: What is the purpose of a 'reference data' table in a database?

• Archive historical transaction data
• Store large binary files
• Provide a controlled set of valid values for data fields, such as country codes or status types (Correct answer)
• Link two fact tables together

Correct answer: Provide a controlled set of valid values for data fields, such as country codes or status types

Reference data tables store stable, controlled sets of valid values (like country codes, currency codes, or status enumerations) used to ensure data consistency.

Question 73: What is 'slowly changing dimension Type 1' (SCD Type 1)?

• Creating a separate history table for changed attributes
• Flagging changed records with an 'is_current' indicator
• Overwriting the old attribute value with the new value, losing historical data (Correct answer)
• Adding new rows for each change to track history

Correct answer: Overwriting the old attribute value with the new value, losing historical data

SCD Type 1 simply overwrites the old attribute value with the new value, keeping only the current state and losing the history of previous values.

Question 74: In data integration, what does 'data latency' refer to?

• The delay between when source data changes and when it becomes available in the target system (Correct answer)
• The encryption strength applied during data transfer
• The volume of data processed per hour by the integration pipeline
• The number of transformation steps applied to data

Correct answer: The delay between when source data changes and when it becomes available in the target system

Data latency is the time delay between a change occurring in the source system and that change being reflected and available in the destination system.

Question 75: What is the key difference between a data policy and a data standard in governance?

• Policies are technical, standards are business-focused
• Standards are mandatory; policies are optional
• Policies apply to databases only; standards apply to all systems
• Policies state what must be done; standards specify how to do it (Correct answer)

Correct answer: Policies state what must be done; standards specify how to do it

Data policies state high-level requirements and what must be achieved, while data standards specify the detailed, measurable methods for meeting those policies.

Question 76: Which data modeling technique uses entities, attributes, and relationships to represent business concepts?

• Physical Data Modeling
• Entity-Relationship (ER) Modeling (Correct answer)
• Object-Oriented Modeling
• Dimensional Modeling

Correct answer: Entity-Relationship (ER) Modeling

Entity-Relationship modeling represents data as entities (business objects), attributes (properties), and relationships (associations) between entities.

Question 77: What does 'right to erasure' (also called 'right to be forgotten') under GDPR mean?

• Individuals can request that their personal data be deleted under certain conditions (Correct answer)
• Data must be erased after 5 years
• Organizations can delete any data at will
• Employees can delete business records

Correct answer: Individuals can request that their personal data be deleted under certain conditions

Under GDPR, individuals have the right to request deletion of their personal data when it's no longer necessary for the purpose it was collected.

Question 78: Which tool enables you to use any executable script as the Mapper or Reducer to generate and run MapReduce jobs?

• Sqoop
• Hadoop Streaming (Correct answer)
• Flume
• Oozie

Correct answer: Hadoop Streaming

MapReduce tasks may be created and executed using any executable script as the Mapper or Reducer by using Hadoop streaming.

Question 79: Which data integration pattern is best suited for near-real-time data movement requirements?

• Manual CSV imports by data stewards
• Event-driven streaming integration (Correct answer)
• Monthly batch file transfers via SFTP
• Quarterly data migration projects

Correct answer: Event-driven streaming integration

Event-driven streaming integration processes and delivers data as events occur, making it ideal for near-real-time requirements where low latency is critical.

Question 80: Using a weighted average in

• Forecasting (Correct answer)
• Classification
• Above All
• Regression

Correct answer: Forecasting

Weighted average is indeed used in forecasting. In forecasting, a weighted average is used to assign different weights or importance to different data points or periods based on their significance or relevance to the forecasted value.

Question 81: Which messaging standard is most commonly used to ensure interoperability between healthcare information systems?

• ISO 20022
• FIX Protocol
• HL7 (Correct answer)
• SWIFT MT messages

Correct answer: HL7

HL7 (Health Level 7) is the dominant standard for exchanging clinical and administrative data between healthcare applications and systems.

Question 82: What is the purpose of a Business Glossary in data governance?

• Track ETL job schedules
• Provide standardized business term definitions used across the enterprise (Correct answer)
• Store raw transactional data
• Monitor database performance

Correct answer: Provide standardized business term definitions used across the enterprise

A Business Glossary provides a common vocabulary with standardized definitions to ensure consistent communication across business units.

Question 83: What is 'connection pooling' in database applications?

• Distributing database load across multiple storage pools
• Pooling query results for caching purposes
• Combining multiple database servers into a cluster
• Reusing a pool of pre-established database connections to reduce the overhead of creating new connections for each request (Correct answer)

Correct answer: Reusing a pool of pre-established database connections to reduce the overhead of creating new connections for each request

Connection pooling maintains a pool of reusable database connections, avoiding the costly overhead of establishing a new connection for each application request.

Question 84: Which data architecture style uses a central repository where raw data is stored in its native format until needed?

• Operational Data Store (ODS)
• Data Lake (Correct answer)
• Data Vault
• Data Mart

Correct answer: Data Lake

A Data Lake stores raw data in its native format at scale, allowing flexible analysis later, unlike data warehouses that require structure upfront.

Question 85: What is database partitioning and what problem does it solve?

• Splitting a database into multiple files for backup purposes
• Dividing a large table into smaller, more manageable segments to improve query performance and manageability (Correct answer)
• Encrypting parts of a database with different keys
• Creating separate databases for each user

Correct answer: Dividing a large table into smaller, more manageable segments to improve query performance and manageability

Partitioning divides large tables into smaller segments (by range, hash, or list) so queries can scan only relevant partitions, improving performance and manageability.

Question 86: A graph that displays data using horizontal or vertical bars.

• Line Graph
• Bar Graph (Correct answer)
• Pie chart
• Histogram

Correct answer: Bar Graph

A bar graph is a type of chart that uses horizontal or vertical bars to represent and compare data categories. The length or height of each bar corresponds to the value or quantity being represented. Bar graphs are commonly used to display categorical data and make it easy to visualize comparisons between different categories or groups.

Question 87: Which of the following traits best describes processed data?

• None of the mentioned (Correct answer)
• Hard to use for data analysis
• All steps should be noted
• Data is not ready for analysis

Correct answer: None of the mentioned

The correct answer is "None of the mentioned." The characteristics listed do not accurately describe processed data.

Question 88: What does ETL stand for in the context of data integration?

• Encode, Transform, Load
• Extract, Transfer, Load
• Extract, Transfer, Link
• Extract, Transform, Load (Correct answer)

Correct answer: Extract, Transform, Load

ETL stands for Extract, Transform, Load — the core three-step process of moving data from source systems to a target system.

Question 89: What is SQL injection and why is it a database security concern?

• A database replication method
• An attack where malicious SQL code is inserted into input fields to manipulate or access unauthorized database data (Correct answer)
• A technique for optimizing SQL queries
• A method to insert bulk data efficiently into databases

Correct answer: An attack where malicious SQL code is inserted into input fields to manipulate or access unauthorized database data

SQL injection occurs when attackers insert malicious SQL code through user input fields, potentially allowing them to read, modify, or delete database data without authorization.

Question 90: Which data governance framework component assigns formal accountability for data assets?

• Data Profiling
• Data Masking
• Data Ownership (Correct answer)
• Data Cataloging

Correct answer: Data Ownership

Data Ownership assigns formal accountability to individuals or teams for the quality, access, and proper use of specific data assets.

Question 91: What does the 'safe mode' state in HDFS prevent?

• Any modifications to the file system namespace (Correct answer)
• Execution of MapReduce jobs
• DataNodes from registering with the NameNode
• New user logins to the cluster

Correct answer: Any modifications to the file system namespace

In safe mode the NameNode is read-only; it does not allow any modifications to the HDFS namespace.

Question 92: Which cash flow category includes payments for acquiring property, plant, and equipment?

• Financing Activities
• Non-cash Activities
• Operating Activities
• Investing Activities (Correct answer)

Correct answer: Investing Activities

Capital expenditures on long-term assets like PP&E are classified under Investing Activities in the cash flow statement.

Question 93: What does 'database replication' achieve?

• Synchronizes data from a primary database to one or more secondary databases for availability and read scaling (Correct answer)
• Validates database backup integrity
• Creates duplicate copies of database schemas in documentation
• Compresses database tables to reduce storage

Correct answer: Synchronizes data from a primary database to one or more secondary databases for availability and read scaling

Database replication copies and maintains data from a primary server to one or more replicas, providing high availability, disaster recovery, and read scalability.

Question 94: What does EBITDA stand for and why is it commonly used in financial analysis?

• Estimated Base Income Tax, Depreciation, and Adjustment; used for tax planning
• Earnings Before Income Tax, Dividend, and Amortization; used for dividend coverage analysis
• Earnings Before Interest, Taxes, Depreciation, and Amortization; used as a proxy for operating cash flow (Correct answer)
• Equity Balance Including Total Debt and Assets; used for balance sheet analysis

Correct answer: Earnings Before Interest, Taxes, Depreciation, and Amortization; used as a proxy for operating cash flow

EBITDA removes non-cash charges and financing effects to approximate the cash earnings power of a business.

Question 95: Which of the following best describes a Data Quality dimension?

• A type of ETL transformation
• A database index type
• A measurable characteristic of data such as accuracy, completeness, or timeliness (Correct answer)
• A storage format for data files

Correct answer: A measurable characteristic of data such as accuracy, completeness, or timeliness

Data Quality dimensions are measurable characteristics like accuracy, completeness, consistency, timeliness, and uniqueness used to assess data quality.

Question 96: What is the primary advantage of columnar storage over row-based storage for analytical queries?

• Simpler query syntax for developers
• Improved compression and faster reading of specific columns without scanning entire rows (Correct answer)
• Faster inserts and updates for transactional workloads
• Better support for ACID transactions

Correct answer: Improved compression and faster reading of specific columns without scanning entire rows

Columnar storage stores data by column rather than row, enabling better compression of similar values and faster reads for analytics that access only specific columns.

Question 97: In a snowflake schema, how do dimension tables differ from those in a star schema?

• They contain fact data instead of descriptive data
• They store historical data using SCD techniques
• They do not have primary keys
• They are normalized into multiple related tables rather than a single denormalized table (Correct answer)

Correct answer: They are normalized into multiple related tables rather than a single denormalized table

In a snowflake schema, dimension tables are normalized into multiple related sub-tables, reducing redundancy compared to the denormalized dimension tables in a star schema.

Question 98: Which data quality practice involves monitoring data quality metrics continuously and alerting stakeholders when thresholds are breached?

• Data Auditing
• Data Cleansing
• Data Profiling
• Data Quality Monitoring / Alerting (Correct answer)

Correct answer: Data Quality Monitoring / Alerting

Data quality monitoring continuously tracks quality metrics against defined thresholds and triggers alerts when data quality degrades below acceptable levels.

Question 99: What is a data quality scorecard used for?

• Evaluating ETL tool vendors
• Tracking and communicating the status of data quality metrics against defined targets over time (Correct answer)
• Scoring candidates in data entry job interviews
• Ranking database performance metrics

Correct answer: Tracking and communicating the status of data quality metrics against defined targets over time

A data quality scorecard tracks key quality metrics against targets and communicates trends over time to stakeholders and governance teams.

Question 100: Which of the following is a measure of spread for a random variable?

• Variance
• Standard deviation (Correct answer)
• All of the mentioned
• Empirical mean

Correct answer: Standard deviation

The standard deviation is indeed a measure of spread for a random variable. It quantifies the amount of variation or dispersion in a set of data. A higher standard deviation indicates a greater spread of values, while a lower standard deviation suggests that the data points are closer to the mean.