Quiz 2: Data Sources and Data Integration

A university combines enrollment records, grades, attendance logs, and learning management system activity into one dataset to study student performance. What process is being performed?

A. Data integration
B. Data deletion
C. Data visualization
D. Data encryption

A. Data integration

A customer appears as “Maria Santos” in one system and “M. Santos” under another account in a second system. Which integration challenge must be solved?

A. Identity matching
B. Data latency
C. API request limiting
D. Database driving

A. Identity matching

A school stores student numbers, program names, and grades in rows and columns with fixed data types. What structure does this dataset use?

A. Unstructured
B. Semi-structured
C. Structured
D. Encrypted

C. Structured

An airline retrieves booking records from Excel files, a reservation database, and an online API. Which ETL stage is occurring?

A. Extract
B. Transform
C. Load
D. Govern

A. Extract

A dashboard combines hourly sales data with supplier records updated only once a week. Users see inconsistent “latest” totals. Which challenge is most evident?

A. Data latency because sources update at different times
B. Unstructured data because suppliers are external
C. Scalability because the database has tables
D. Governance because all values are numerical

A. Data latency because sources update at different times

The airline converts ticket prices to one currency, standardizes airport codes, and removes duplicate bookings. Which ETL stage is occurring?

A. Extract
B. Transform
C. Load
D. Connect

B. Transform

An application receives JSON order records in which some orders include a discount field while others contain nested delivery details. What type of data is this?

A. Structured because all records must have identical columns
B. Semi-structured because keys organize records without a rigid table schema
C. Unstructured because JSON has no labels
D. Internal because the records contain orders

B. Semi-structured because keys organize records without a rigid table schema

An Indonesian marketplace analyzes customer review text and uploaded product photos to identify quality concerns. Which data category and methods are most appropriate?

A. Structured data using SQL joins only
B. Semi-structured data using spreadsheet formulas
C. Unstructured data using natural language processing and computer vision
D. External data using currency conversion

C. Unstructured data using natural language processing and computer vision

A team can access its cloud database only when connected to the internet. Which cloud-source limitation does this illustrate?

A. Schema matching
B. Internet dependence
C. Identity matching
D. Currency standardization

B. Internet dependence

A database administrator gives an analyst the server address and database name, but the connection still fails because the system cannot verify the user. What is most likely missing?

A. A chart title
B. Authentication credentials
C. A merged spreadsheet cell
D. A customer review

B. Authentication credentials

A Manila restaurant chain prepares branch spreadsheets for Power BI. Which practice will make the files easiest to combine?

A. Merge cells to create decorative headings
B. Use different column names in every branch
C. Keep one header row and consistent column names
D. Mix dates, text, and amounts in the same column

C. Keep one header row and consistent column names

A rice distributor combines its sales records with government agricultural statistics and weather forecasts. Which data is external?

A. The distributor's sales records only
B. The government statistics and weather forecasts
C. All data because it will be combined
D. None because the distributor can access it

B. The government statistics and weather forecasts

A Philippine supermarket analyzes its point-of-sale transactions, inventory records, and loyalty-card data. How should these sources be classified?

A. External sources because customers are involved
B. Internal sources because they originate within the organization
C. Unstructured sources because several systems are used
D. Public sources because they describe purchases

B. Internal sources because they originate within the organization

A bank combines customer data from several Asian countries. It must restrict sensitive records, standardize currencies, and identify who owns each data definition. Which set of concerns is most relevant?

A. Security and privacy, format differences, and governance
B. Computer vision, merged cells, and API limits
C. Volume, chart colors, and PDF extraction
D. Direct query, social media, and speech recognition

A. Security and privacy, format differences, and governance

An e-commerce company connects Power BI to a cloud marketing platform through a REST API. Reports stop refreshing after too many requests. Which cloud limitation is most likely responsible?

A. API request limits
B. Fixed spreadsheet schema
C. Duplicate worksheet headers
D. Computer vision requirements

A. API request limits

After cleaning its booking data, the airline stores the prepared records in a data warehouse for reporting. Which ETL stage is occurring?

A. Extract
B. Transform
C. Load
D. Authenticate

C. Load

A retail dashboard must query a central SQL database whenever a user interacts with the report instead of storing a copy in the model. Which connection mode should be used?

A. Import
B. Direct query
C. Manual entry
D. PDF export

B. Direct query

A food-delivery company wants to improve delivery-time estimates. Which combination best provides both operational and environmental information?

A. Internal order records plus external traffic and weather data
B. External weather data only
C. Internal payroll and inventory data only
D. Customer names plus employee passwords

A. Internal order records plus external traffic and weather data

Two branches record dates as MM/DD/YYYY and DD/MM/YYYY, causing incorrect monthly totals after integration. What challenge is demonstrated?

A. Data latency
B. Format differences
C. Scalability
D. Access permissions

B. Format differences

An analyst has selected an Excel connector and opened the correct workbook. What should be done before loading the data?

A. Select the required sheet, preview records, and verify column names and data types B. Delete all worksheets except the first
C. Convert every value to text
D. Publish the report without inspecting the file

A. Select the required sheet, preview records, and verify column names and data types