Data Concepts and Environments

A retail company stores customer purchase history in a relational database. The database contains a table 'transactions' with columns: transaction_id, customer_id, product_id, quantity, price, and transaction_date. A data analyst needs to create a report that shows total revenue per customer for the last quarter. Which data concept describes the relationship between customer_id and total revenue?

A healthcare database stores patient records. Each patient has a unique patient_id, and the database includes a table 'visits' with visit_id, patient_id, visit_date, and diagnosis_code. To ensure data integrity, which constraint should be applied to the patient_id column in the 'visits' table?

A data engineer is designing a data warehouse for a multinational corporation. The company has sales data from different regions with varying currencies and date formats. To ensure consistency, which data concept should be applied to standardize the data before loading into the warehouse?

An e-commerce company uses a star schema for its data warehouse. The fact table 'sales_fact' contains foreign keys to dimension tables: customer_dim, product_dim, time_dim, and store_dim. A business user wants to know the total sales for each product category in the last month. Which join operation is required to retrieve this data?

A data scientist is building a machine learning model to predict customer churn. The dataset includes both numerical features (age, income) and categorical features (gender, marital status). Which data concept describes the process of converting categorical features into numerical values that can be used by the algorithm?

A company's database has a table 'orders' with columns: order_id, customer_id, order_date, and total_amount. A data analyst needs to identify customers who have placed more than 5 orders in the past year. Which data concept should be used to group orders by customer and count them?

A data analyst receives a dataset with a column 'salary' that contains values like '45,000', '55,000', and '65,000'. The analyst notices that the values are stored as text. Which data concept should be applied to convert the salary column from text to numeric format for analysis?

Which TWO of the following are characteristics of structured data? (Choose TWO.)

Which TWO of the following are examples of data transformation? (Choose TWO.)

A financial services company is migrating its customer data from a legacy on-premises relational database to a cloud-based data warehouse. The legacy database uses a denormalized schema with a single table 'customer_master' that contains all customer attributes, including repeated groups for multiple accounts per customer (account1_type, account1_balance, account2_type, account2_balance, etc.). The data warehouse team wants to implement a normalized star schema with separate dimension and fact tables. During the ETL process, the team encounters an error: 'Data truncation: string data right truncation' when loading account_type values into the dim_account table. The account_type column in dim_account is defined as VARCHAR(10), but the source data contains account types like 'SavingsPlus' (11 characters) and 'CheckingPremium' (15 characters). The team must resolve this issue without losing data. Which course of action should the team take?

A healthcare organization maintains a database of patient records. The database has a table 'patients' with columns: patient_id (primary key), first_name, last_name, date_of_birth, gender, and last_visit_date. A data analyst is tasked with creating a report that lists all patients who have not visited in the last two years. The analyst writes a query: SELECT * FROM patients WHERE last_visit_date < DATEADD(year, -2, GETDATE()); However, the query returns zero rows, even though the analyst knows there are patients who have not visited for over two years. Upon inspection, the analyst discovers that the last_visit_date column contains NULL values for patients who have never visited. Which modification to the query should the analyst make to include patients with NULL last_visit_date?

A data analyst needs to ensure that a customer's address is stored in a consistent format across multiple databases. Which data quality dimension is the analyst primarily concerned with?

A data engineer is designing a data warehouse for a retail company. The fact table must record each sale transaction, including product ID, store ID, date, and quantity sold. The product details (name, category, price) are stored in a separate table. This design is an example of which data modeling concept?

A data analyst is troubleshooting a report that shows unusually high sales for a specific product. Upon investigation, the analyst finds that the product was returned by several customers, but the returns were recorded in a separate system and not reflected in the sales data. Which data integration concept was likely missing?

A data analyst is creating a report for a marketing campaign. The campaign data includes customer names, email addresses, and purchase history. Which of the following best describes the 'customer name' data type?

Which TWO of the following are considered structured data?

Which THREE of the following are characteristics of a relational database?

Which THREE of the following are valid methods for handling missing data?

A mid-sized e-commerce company stores customer data in a relational database. The database has a table named 'Customers' with columns: CustomerID (primary key), FirstName, LastName, Email, Phone, Address, City, State, ZipCode, and SignUpDate. The company is migrating to a new CRM system that requires a denormalized structure for performance reasons. The new system expects a single table 'CustomerDetails' with columns: CustomerID, FullName (concatenation of first and last name), ContactInfo (JSON object containing email, phone, and address), SignUpDate, and Region (derived from state). The data analyst must design an ETL process to transform the data. During a test run, the analyst notices that some records have missing Phone or Address values. Which of the following is the best approach to handle missing data in the ContactInfo JSON object?

Match each data quality dimension to its description.

A company needs to store raw, unprocessed data from IoT sensors for future machine learning experiments. The data is in various formats and schemas are not yet defined. Which storage solution is most appropriate?

A financial application requires fast query performance for aggregations on large historical datasets. The schema has many lookup tables. Which schema design is most efficient for this workload?

A database table has columns: OrderID (primary key), ProductID, CustomerID, CustomerName, OrderDate, ProductName. All products are purchased only by the customer who placed the order. Which normal form violation exists if CustomerName depends on CustomerID?

A data engineer needs to store logs from web servers that have varying fields. The logs are in JSON format. Which data type describes this JSON data?

A retail company processes daily transactions. The current system transforms data before loading it into the data warehouse. The volume is growing rapidly, and they want to load raw data first to reduce processing time. Which approach should they adopt?

A table Orders has OrderID (primary key), CustomerID, and CustomerEmail. During analysis, it is found that CustomerID uniquely identifies CustomerEmail. Which normal form is violated if both CustomerID and CustomerEmail are stored in this table?

A company requires real-time masking of credit card numbers for customer support agents while allowing full access for accountants. Which technique should be implemented?

A hospital's patient records system must process thousands of small transactions per second. Which type of database system is best suited for this workload?

A data quality report shows that 95% of records have all required fields completed, but 20% of the completed fields contain values that are outside valid ranges. Which data quality dimension is most affected?

Which THREE of the following are NoSQL database types?

A data team must implement a data retention policy to reduce storage costs while meeting legal requirements. Which TWO actions best achieve this?

Refer to the exhibit. A data analyst is trying to understand access permissions for the company data folder. Which statement accurately describes the effective permissions?

Refer to the exhibit. A database administrator notices that queries filtering on both CustomerID and OrderDate are slow. Which single change would most likely improve performance for such queries?

A retail analyst needs to determine the most popular product category. The dataset includes columns: ProductID, Category, SalesDate, QuantitySold, UnitPrice. Which column contains qualitative data?

A data scientist is building a model to predict customer churn. The company's internal CRM system provides customer demographics and transaction history. They also purchase demographic data from a third-party vendor. How should the purchased data be classified?

A logistics company is analyzing truck delivery times. Which variable is discrete?

A hospital wants to analyze patient readmission rates. The data contains daily patient visits. What is the level of granularity?

A data analyst finds that the "Age" column contains values like "N/A", "unknown", and negative numbers. Which data quality dimension is primarily affected?

An e-commerce company stores customer support emails in a text database, product images in a blob store, and sales transactions in a SQL table. Which data store holds only structured data?

A market researcher conducts a survey with questions like "What is your favorite brand?" and "How many units do you purchase per year?" Which data types correspond?

In a customer database, each row represents a customer with columns: CustomerID, Name, Address, Phone. What does the column "Name" represent?

A data audit reveals that some numbers in the "Revenue" column were manually entered from PDF invoices. This introduces potential errors. Which data concept is being addressed?

Which TWO are examples of primary data? (Select two.)

Refer to the exhibit. Which type of data is the field "region"?

Refer to the exhibit. Which data quality dimension is compromised by the missing value for Charlie's salary?

A retail company stores customer transaction data in a relational database. They want to analyze purchasing patterns over time. Which type of data structure best supports this analysis?

A data analyst receives a dataset with inconsistent date formats (e.g., "01/02/2023", "2023-01-02", "Jan 2, 2023"). Which data quality dimension is most directly affected?

A company is designing a data lake to store raw sensor data from IoT devices. The data arrives as JSON objects with varying schemas. Which storage approach is most appropriate?

A healthcare provider needs to integrate patient data from multiple clinics into a single data warehouse. Which process is used to extract, transform, and load the data?

A data analyst is working with a dataset that contains customer names and addresses. Some records have missing state codes. Which data quality issue is this?

A financial institution wants to analyze transaction networks to detect fraud rings. Which database type is best suited for this analysis?

A data architect is designing a schema for a product catalog where each product has a variable number of attributes. Which NoSQL database type is most appropriate?

A data engineer is comparing data warehouses and data lakes. Which statement accurately describes a data warehouse?

During an ETL process, a data quality check fails due to duplicate customer IDs. Which data quality dimension is violated?

Which TWO of the following are examples of semi-structured data?

Which THREE data quality dimensions are commonly assessed in a data profiling task?

Which TWO of the following are characteristics of a data lake?

Refer to the exhibit. A data analyst notices that direct S3 access to files outside the "incoming/" prefix is blocked. Which data governance principle does this policy enforce?

Refer to the exhibit. A data analyst runs this query to identify high-value customers. However, the result does not include customers with exactly 5 orders. Which data concept does the HAVING clause illustrate?

Refer to the exhibit. An Avro schema is defined as shown. Which data design concept does this represent?

A marketing team needs to store customer feedback from social media posts, including text, images, and emojis. Which data concept is most appropriate for this storage?

An organization wants to assign responsibility for data quality and metadata management. Which role is primarily accountable for defining data standards and ensuring data quality across a specific domain?

A data analyst notices that customer addresses in the database contain invalid ZIP codes. Which data quality dimension is being violated?

To consolidate data from multiple operational databases into a central repository for reporting, a company decides to transform data before loading it into the target system. Which data integration approach is being used?

A business needs to store large volumes of raw data in its native format for future analytics. Which storage architecture is most appropriate?

A data modeler is designing a dimensional model for a sales analytics system. The fact table contains sales transactions, and the dimension tables include product, customer, and time. To reduce data redundancy, the modeler normalizes the dimension tables into multiple related tables. Which schema is being implemented?

An organization has multiple systems that store customer information inconsistently. To create a single authoritative view of customer data, they implement a process that identifies and merges duplicate records. This is an example of which data management discipline?

A data governance team is drafting a policy for handling personally identifiable information (PII). According to data governance best practices, which document should define the classification levels and handling procedures?

Which TWO of the following are considered internal data sources within an organization?

Which THREE of the following are common characteristics of unstructured data?

Which TWO of the following are primary benefits of implementing a data governance program?

A market research firm collects survey responses where customers rate satisfaction on a scale of 'Very Unsatisfied', 'Unsatisfied', 'Neutral', 'Satisfied', 'Very Satisfied'. What type of data is being collected?

A data analyst needs to compare sales data from the company's internal CRM with public demographic data from a government census. Which data concept best describes this scenario?

A sensor records temperature readings in Celsius and a separate sensor records wind speed in meters per second. A data scientist wants to combine these datasets for analysis. Which statement accurately compares these data types?

A data analyst notices that a column labeled 'Income' contains values like '$50,000' and '$75,000', but also 'High' and 'Low'. What data concept issue is occurring?

Which of the following is an example of qualitative data?

A dataset contains a column 'Education Level' with values: 'High School', 'Bachelor', 'Master', 'PhD'. An analyst computes the average by assigning numbers 1-4. Which data concept is being violated?

Which THREE of the following are properties of ratio data? (Choose THREE.)

A retail company analyzes customer purchase data to improve inventory management. They store daily transaction records in a relational database and monthly aggregate reports in a data warehouse. Which difference between these storage methods best explains why the warehouse is more suitable for trend analysis?

A data analyst is evaluating data quality issues in a customer database. Which TWO actions are best practices for ensuring data consistency?

An organization is implementing a data lake to store raw data from various sources. Which THREE characteristics are typically associated with a data lake compared to a data warehouse?

A data analyst at a marketing agency is working with a dataset containing customer demographics, purchase history, and social media engagement metrics. The agency wants to perform sentiment analysis on unstructured social media comments to identify brand perception. The dataset also includes structured fields like age, income, and purchase amounts. The analyst needs to choose a storage and processing platform that can handle both structured and unstructured data efficiently without requiring extensive schema definition upfront. Which platform should the analyst recommend?

An e-commerce company wants to provide real-time personalized product recommendations based on customer browsing behavior. Currently, they have a traditional data warehouse that processes batch updates every night. The marketing team complains that recommendations are outdated within hours because customers see yesterday's data. The data engineer needs to modify the architecture to support near-real-time analytics. The budget is limited, and the existing warehouse infrastructure must be reused as much as possible. Which architectural change would best meet the requirement?

A data analyst is comparing characteristics of structured and unstructured data. Which TWO of the following are characteristics of structured data? (Choose two.)

Which of the following data types is characterized by a flexible schema and is commonly represented using JSON or XML?

An organization needs to store raw data from IoT sensors in its native format for future analysis. Which storage solution is best suited for this purpose?

A data analyst needs to combine rows from two tables based on a related column, but only wants rows that have matching values in both tables. Which join type should the analyst use?

A company is ingesting data from multiple sources into a cloud data warehouse. They decide to load the data raw and then perform transformations within the warehouse. Which approach does this describe?

A database administrator wants to ensure that every value in a column matches values in a primary key column of another table. Which constraint enforces this rule?

An analyst is reviewing a table that stores customer orders. The table contains columns: OrderID, CustomerName, Product1, Product1Qty, Product2, Product2Qty. This design violates which normal form?

A data engineer is designing a system to handle high-velocity clickstream data from a website. The system must allow low-latency writes and support key-value lookups. Which type of database is most appropriate?

Which of the following best describes a data mart?

A company wants to share a dataset with external partners via an API. Which API type is typically used for web services and uses XML or JSON for messaging?

A database has a table 'Orders' with columns OrderID (PK), CustomerID, OrderDate, and a table 'OrderDetails' with OrderID (FK), ProductID, Quantity. To ensure that every OrderID in OrderDetails exists in Orders, which integrity constraint is enforced?

A data analyst needs to extract data from a transactional database and load it into a data warehouse for reporting. Which process typically transforms the data before loading it into the warehouse?

Which of the following is an example of unstructured data?

A data governance team is defining roles and responsibilities for data management. Which TWO of the following are common data governance roles? (Select TWO).

A company is designing a data pipeline to process streaming data from social media feeds. Which THREE of the following are characteristics of streaming data? (Select THREE).

Which of the following data types best describes a JSON file containing customer orders with varying fields per record?

A company needs to store raw data from IoT sensors for future machine learning projects. The data is expected to be massive and in various formats. Which storage solution is most appropriate?

An OLTP system processes thousands of transactions per second. Which property ensures that a transaction is fully completed or fully rolled back, preventing partial updates?

A data analyst needs to combine customer data from two tables: Customers (CustomerID, Name) and Orders (OrderID, CustomerID, Amount). Only customers who have placed at least one order should be included. Which JOIN type should be used?

A company uses a data warehouse for reporting. They need to extract data from multiple sources, load it into a staging area, and then transform it before moving to the warehouse. This process is known as:

A data analyst wants to retrieve data from a REST API that returns JSON. Which step is part of the data lifecycle for this activity?

Which of the following data sources is most likely to generate streaming data?

A table named Orders has columns OrderID, CustomerID, OrderDate, and TotalAmount. Which column should be the primary key to uniquely identify each order?

A data engineer is designing a data pipeline where raw data is loaded into a cloud data warehouse (Snowflake) and then transformed using SQL. This approach is called:

Which database concept ensures that data in one table corresponds to data in another table, preventing orphan records?

A data governance team is establishing policies. Which three activities are part of data governance? (Select THREE.)

A retail company wants to analyze customer purchase patterns over time. The data is stored in a relational database with tables for Customers, Orders, and Products. Which database concept should be used to ensure that each order references a valid customer?

A data engineer needs to extract data from a REST API and load it into a data warehouse. The data is received in JSON format. Which data type best describes JSON?

A company is building a data pipeline to ingest sensor data from IoT devices. The data arrives continuously in small batches and must be processed in real-time for monitoring. Which type of data source best describes this scenario?

A data analyst is working with a relational database that contains a table of customer orders. To optimize query performance for a report that filters by order date and customer ID, the analyst wants to create an index. Which type of index would be most effective for queries that filter on both columns?

An organization uses a data warehouse for analytics. The data team wants to load data from source systems into the warehouse. They choose to load raw data first and then perform transformations within the warehouse. Which approach are they using?

A company is designing a database for an e-commerce application that requires high transaction throughput and must guarantee that each transaction is processed atomically. Which property of ACID ensures that a transaction is either fully completed or not executed at all?

A data analyst needs to combine data from two tables: one containing customer information and another containing order details. The analyst wants to include all customers, even those who have not placed any orders. Which type of join should be used?

A data governance team is establishing policies to ensure data quality. They define rules for data accuracy, completeness, and consistency. Which data governance function is primarily responsible for defining and enforcing these rules?

A data architect needs to store raw data from various sources, including social media feeds and log files, for future analysis. The data may be used for machine learning and ad-hoc queries. Which storage solution is most appropriate for storing raw data in its native format?

A database administrator is designing a normalized database to reduce data redundancy. They have a table with columns: OrderID, ProductID, ProductName, and Quantity. The table is currently in 1NF. To move to 2NF, which issue must be resolved?

A company uses a NoSQL document database to store product catalogs. Each product document includes fields like product_id, name, category, and price. The operations team frequently queries by product_id and by category. Which type of NoSQL database is being used, and what should be created to optimize queries by category?

A data analyst needs to share a weekly sales report with the marketing team. The report includes aggregated data from the data warehouse. To simplify access, the analyst creates a virtual table that encapsulates the complex query. Which database object should the analyst create?

A data analyst is extracting data from a web page using web scraping techniques. The data will be used for market research. Which TWO of the following are common challenges associated with web scraping?

A data warehouse team is considering moving from an ETL to an ELT approach. Which THREE of the following are advantages of ELT over ETL?

A data analyst is working with a dataset that includes customer names, email addresses, and purchase history. The analyst wants to ensure that each customer is uniquely identified. Which TWO database concepts should be used to enforce uniqueness and link related data?

A large online retailer stores customer orders in a PostgreSQL database. Each order has a unique order ID, and the database is normalized to 3NF. Which type of data is this?

A data analyst receives a file with the extension .json. This file contains product information with attributes that vary between records. How should this file be classified?

A company uses an OLTP system for processing customer transactions. Which characteristic is most important for this system to ensure that each transaction is processed reliably, even if multiple users access the system simultaneously?

A data engineer is designing a system to store raw sensor data from thousands of IoT devices. The data will be used later for various analytics projects, but the schema is not yet defined. Which storage solution is most appropriate?

A data analyst needs to combine customer information from a CRM table and order information from an orders table, returning only customers who have placed at least one order. Which type of join should the analyst use?

A company has a large data warehouse running on Snowflake. They receive daily CSV files from multiple sources and load them directly into the warehouse, then run SQL transformations to clean and aggregate the data. Which data integration approach does this describe?

Which database index type is most commonly used for exact-match lookups and range queries in a B-tree structure?

A data analyst needs to retrieve current weather data from a third-party service. The service provides an endpoint that returns data in JSON format over HTTP. Which data source type is being used?

A DBA wants to improve query performance on a large table that is frequently filtered on two columns: department_id and hire_date. The table has millions of rows. Which index strategy would be most effective?

Which stage of the data lifecycle involves converting raw data into a usable format, such as cleaning or validating?

A data governance team is implementing a program to ensure consistent definitions and quality of customer data across the organization. They assign a senior manager to be accountable for the data asset. Which role does this manager fulfill?

A company needs to store user session data for a web application. Each session has a unique session ID, and the data must be retrieved very quickly by session ID. The data does not require complex relationships or transactions. Which type of NoSQL database is most appropriate?

A data analyst is performing a join between two tables: 'employees' and 'departments'. The 'employees' table has a foreign key 'dept_id' referencing the 'departments' table. Which two join types would include all rows from the 'employees' table, regardless of whether there is a matching department? (Select TWO)

A data engineer is designing a data pipeline for a retail company. The source system is an OLTP database that records sales transactions. The target is a data warehouse used for reporting. The engineer is evaluating whether to use ETL or ELT. Which three factors would favor using ELT over ETL? (Select THREE)

A university database stores student information in a normalized schema. The 'students' table has a primary key 'student_id'. The 'enrollments' table has a foreign key 'student_id' referencing 'students'. Which two of the following are true about primary and foreign keys? (Select TWO)

Which of the following is a characteristic of structured data?

A company ingests customer clickstream data from its website. The data arrives continuously in JSON format and must be stored for real-time analytics. Which type of data source is being described?

A data analyst needs to combine customer data from a MySQL transactional database with product data from a MongoDB document store to create a unified view for reporting. The analyst uses a SQL query that joins the tables after extracting data from both sources. Which database concept is being applied?

An organization is implementing a data warehouse to support business intelligence reporting. The data warehouse must ensure that transactions are processed reliably. Which property guarantees that each transaction is treated as a single, indivisible unit?

Which of the following is an example of semi-structured data?

A data engineer is designing a system to store raw sensor data from thousands of IoT devices. The data is expected to be used for exploratory analytics and machine learning. Which storage solution is most appropriate?

In the data lifecycle, which phase involves converting raw data into a usable format for analysis?

Which TWO of the following are characteristics of OLTP systems? (Select 2)

Which TWO of the following are examples of unstructured data? (Select 2)

A company is migrating its data pipeline from on-premises to the cloud. The current ETL process transforms data before loading into a data warehouse. The new architecture will use ELT instead. Which THREE of the following are advantages of ELT over traditional ETL? (Select 3)

Which TWO of the following are benefits of database normalization to 3NF? (Select 2)

A data governance team is establishing policies for data quality. Which THREE of the following are common dimensions of data quality? (Select 3)

A data analyst is designing a database for a retail application. Which TWO of the following are valid reasons to use a NoSQL document database like MongoDB instead of a relational database? (Select 2)

Which THREE of the following are components of Master Data Management (MDM)? (Select 3)

A data analyst at a hospital is building a report on patient readmissions. The analyst needs to combine the patient demographics table (which uses PatientID as the primary key) with the admissions table (which uses AdmissionID as the primary key and also contains PatientID as a foreign key). Which type of operation should the analyst use to combine these two tables?

A healthcare analytics team is building a patient readmission risk model. They have a dataset containing admission date, discharge date, primary diagnosis code, and patient age. To predict readmission within 30 days, the team needs to derive a new field that represents the number of days a patient stayed in the hospital. Which data transformation technique should they apply to create this derived field?

A data analyst at a healthcare clinic is organizing patient records. The analyst needs to categorize each patient's blood pressure reading as 'Low', 'Normal', 'Elevated', or 'High' based on clinical thresholds. The categories have a clear order from lowest to highest risk. Which measurement scale best describes this classification?

A data analyst is working with a dataset that contains a column for customer satisfaction ratings on a scale of 1 to 5, where 1 means 'very dissatisfied' and 5 means 'very satisfied'. The analyst wants to calculate the median satisfaction score. Which level of measurement does this data represent?

A data engineer is designing a schema for a new application. The application will store user profiles with fields such as UserID, Email, and SignupDate. The team expects the user base to grow rapidly, and the schema may evolve to include new profile attributes like phone number or social media handles. They want to minimize downtime and avoid complex migrations when adding fields. Which data model should the engineer choose?

A data analyst is working with a dataset that contains a column for 'Order Date' stored as a string in the format 'YYYY-MM-DD'. The analyst needs to perform time-series analysis, such as calculating monthly sales trends. Which two actions should the analyst take to prepare the data for this analysis? (Choose two.)

A data analyst at a university is asked to classify the variable 'Student Classification' with possible values Freshman, Sophomore, Junior, Senior. Which measurement scale best describes this variable?

A hospital's data team is cataloging its data assets. They need to classify the blood type field stored for each patient (e.g., A+, O-). Which data type classification best describes this field?

A data engineer is designing a data lake to store raw data from multiple sources, including JSON logs, CSV files, and Parquet files. The data will be used for both batch analytics and machine learning. The engineer must choose storage and processing strategies that align with the characteristics of a data lake. Which two of the following are core characteristics of a data lake? (Choose two.)

A financial analyst is working with a dataset of stock prices. The dataset contains a column 'Price' that records the closing price of each stock in USD. The analyst wants to calculate the percentage change in price from the previous day for each stock. Which data type is most appropriate for the 'Price' column?

A data analyst is examining a dataset of customer transactions. The analyst notices that the 'TransactionAmount' column contains values like 100.50, 200.75, and 50.00. The analyst wants to determine the average transaction amount. Which type of data is 'TransactionAmount'?

A data engineer is designing a database for an online store. The database must enforce strict consistency and handle complex transactions involving multiple tables, such as orders, customers, and inventory. Which database type should the engineer choose?

An e-commerce company stores product descriptions that contain accented characters and emoji in customer reviews. The database currently fails to store these characters correctly, replacing them with question marks. Which action should the data engineer take to resolve this issue?

A data architect is designing a system to store data for a real-time analytics application. The application requires high-speed ingestion of semi-structured data with flexible schemas, and the ability to query data using SQL-like syntax. The data volume is expected to grow rapidly. Which type of database should the architect choose?

A data analyst is examining a dataset of employee records. The 'EmployeeID' column contains unique alphanumeric codes, and the 'Department' column contains values like 'Sales', 'HR', and 'IT'. The analyst needs to determine which column is a key and which is a categorical attribute. Which statement correctly identifies the data types and roles?

A data steward at a retail company is classifying data assets. The company wants to identify which data elements are considered structured data. Which two of the following are examples of structured data? (Choose two.)

A data analyst is preparing a dataset for analysis and needs to address data quality issues. The dataset contains missing values, outliers, and inconsistent formats. Which two techniques are appropriate for handling missing values? (Choose two.)

A healthcare analytics team stores patient visit records in a relational database. Each visit has a unique VisitID, and the team frequently needs to join visit data with physician and facility tables. The database must enforce referential integrity between these tables. Which data model characteristic best describes this environment?

A logistics company uses a key-value store to cache real-time shipment tracking updates. The data model has no fixed schema, and each shipment record may contain different attributes. Which data storage approach is being used?

A data architect is designing a system to store customer support tickets. The tickets are written in free-form text and include attachments such as screenshots and PDFs. The system must allow support agents to search for tickets by keywords within the text and attachments. The architect expects the volume of tickets to grow to millions and requires fast, full-text search capabilities. Which storage solution is most appropriate?

A financial services company is implementing a data governance program. The chief data officer wants to ensure that data is classified according to its sensitivity and that access is restricted accordingly. The company must comply with GDPR and internal policies. Which data governance component is primarily responsible for defining and enforcing data classification and access controls?

A data architect is designing a storage solution for a healthcare provider. The system must store patient records with varying structures, including unstructured clinical notes and semi-structured JSON data from wearables. The solution must scale horizontally and handle high write throughput. Which storage type is most appropriate?

A marketing analyst receives a dataset containing customer ages recorded as whole numbers (for example, 25, 42, 67). The analyst wants to classify the measurement scale of the age field. Which measurement scale applies?

A data analyst is profiling a dataset of employee records. The birthdate column contains values stored as text in the format YYYY-MM-DD, while the hire date column is stored as a native date type. The analyst needs to calculate employee tenure. Which action should the analyst take first?

A data analyst is working with a dataset that includes a column 'Annual Income' with values ranging from $20,000 to $500,000. The analyst wants to reduce the impact of extreme values on a machine learning model. Which technique should the analyst apply?

A data engineer is designing storage for a fraud detection system that ingests millions of transaction events per second. The system must store each event with its timestamp and support fast writes without predefined schema enforcement, while allowing later analytical queries over semi-structured payloads. Which storage approach best fits these requirements?

A data architect is designing a system to handle a workload that requires strong consistency and complex multi-table joins for financial reporting. Which two characteristics should the architect prioritize when selecting the database technology? (Choose two.)

A hospital's data team needs to choose a storage model for its new electronic health record (EHR) system. Patient records contain many nested, variable attributes such as a list of allergies, multiple insurance policies, and a changing set of lab results per visit. The schema changes frequently as new clinical fields are added, and the team wants to avoid costly migrations. Which data model should the team select?

A data analyst is profiling a dataset of customer records and discovers that 12% of the rows have missing values in the "postal_code" column, while the "customer_id" column is fully populated. The analyst needs to document this finding for a data quality report. Which data quality dimension does the missing postal code values primarily violate?

A marketing analyst is building a dashboard that groups customers by the state listed in their billing address so the sales team can compare performance across regions. The analyst retrieves the raw address data stored in a single text column. Which data type classification best describes the state field as the analyst intends to use it?

A logistics company collects GPS telemetry from delivery trucks. Each reading includes a truck identifier, a timestamp, latitude, and longitude, and the fleet generates roughly 500 million readings per day. Analysts mostly run aggregate queries such as average speed per route over the past 90 days, and they rarely update individual readings. Which storage approach best fits this workload?

A data analyst at a logistics company is designing a new database table to store shipment records. Each shipment has a unique tracking number, a weight in kilograms, a destination city, and a delivery date. The analyst needs to choose a data type for the tracking number that ensures uniqueness and efficient lookups. Which data type is most appropriate for the tracking number?

A data architect is evaluating storage engines for a new analytics platform. The platform must support storing large volumes of structured historical sales data and must efficiently handle queries that aggregate a few columns across billions of rows. The architect is considering column-oriented storage. Which two characteristics accurately describe column-oriented storage in this context? (Choose two.)

A hospital's analytics team is designing a new repository for electronic health records. The records include patient demographics, lab results, and physician notes, and the schema must remain flexible because new lab test types are added frequently. The team needs to enforce relationships between patients, encounters, and lab orders while keeping the ability to evolve the schema. Which data model best fits these requirements?

A logistics company stores shipment records in a relational database. The ShipmentID column uniquely identifies every shipment, and the CarrierName column stores the name of the carrier that moved each shipment, such as "Northwind Freight" or "Acme Logistics". Analysts frequently group shipments by carrier to compare on-time performance. Which statement correctly describes the relationship between these two columns in this table?

A data engineer loads a CSV export into a table. The source system writes the value '007' for a product code, but after loading, an analyst queries the table and sees the value 7. The analyst needs the leading zero preserved for downstream matching against another system. Which action should the engineer take?

A financial analytics team is building a data warehouse to support complex analytical queries on historical stock trades. The data volume is in terabytes, and queries frequently join multiple large tables and perform aggregations. The team needs a storage model that minimizes query latency for these read-heavy analytical workloads. Which data modeling approach is most appropriate?

A data engineer is profiling a dataset of online orders. The order_id column contains a unique value for every row, but the analyst notices that a join to the customer table unexpectedly returns fewer rows than the orders table. After investigation, the engineer finds that some customer_id values in the orders table do not exist in the customer table. Which data quality dimension is primarily violated by the customer_id values?

A data architect is designing a system for a subscription streaming service. The service must record every play, pause, and skip event from millions of concurrent viewers with very low write latency, and it must later support analytical queries over months of event history. The architect wants a single storage layer that handles both needs without a separate transformation pipeline. Which data architecture should the architect choose?

An analyst is profiling a table of laboratory test results. The ResultValue column stores numeric readings, but a subset of rows contains the literal text "N/A" in that column, and a separate ResultUnit column records units such as mg/dL or mmol/L. The analyst must compare average ResultValue across two hospital sites. Which data issue most directly prevents a valid comparison, and what is the appropriate first step?

A data engineer is ingesting streaming data from a fleet of delivery vehicles. Each vehicle sends GPS coordinates, speed, and timestamp every second. The engineer needs to store this data for real-time dashboards and also retain it for long-term historical analysis. Which data storage approach best balances real-time access and cost-effective long-term retention?

A data engineer is choosing a storage approach for a new analytics platform. The workload consists of wide, denormalized event tables with dozens of attributes, queries that scan a few columns across billions of rows, and heavy aggregation rather than single-row lookups. Which storage structure is best suited to this workload?

A logistics company collects GPS pings from delivery trucks every few seconds. Each ping includes a device identifier, a timestamp, and latitude and longitude coordinates. The analytics team wants to compute the total distance each truck traveled per day and the average speed between consecutive pings. Which characteristic of the data must the team address first to make these calculations valid?

A university is designing a data platform to consolidate student records from several departments. The data includes enrollment dates, course grades, and tuition payments. The team must classify each field correctly so that appropriate storage, aggregation, and visualization choices can be made. Which two statements correctly describe the measurement scales of these fields? (Choose two.)

A data governance committee is defining metadata standards for a new data lake. They need to distinguish between technical metadata and business metadata to ensure proper data management. Which two of the following are examples of technical metadata? (Choose two.)

A national retailer is consolidating data from 40 regional stores into a central analytics platform. Each region uses different codes for the same product categories, and store managers report sales in local currencies. Before loading the data, the integration team must resolve these inconsistencies. Which two activities are appropriate steps to standardize the data? (Choose two.)

A retail analytics team is building a data catalog and must document the metadata for a new sales fact table. The team needs to record structural metadata that describes how the data is organized. Which two items qualify as structural metadata for this table? (Choose two.)