A transaction system reliably records completed purchases but does not include people who never bought. Which use best accounts for the source's scope?
Data Quality, Grain, and Relational Joins Online Quiz Questions
Use this free practice quiz with 20 questions to review Data Quality, Grain, and Relational Joins, test your knowledge, and prepare for your next test or exam.
Select all statements that correctly describe relational keys or a risk to check before joining tables.
- A
A primary key uniquely identifies a row.
- B
A foreign key is a value that must be unique within its own table.
- C
A foreign key can refer to a key in another table to connect related records.
- D
A join can unintentionally duplicate or drop rows if the keys or relationship are not checked.
A product code such as 00127 should be treated as a quantity because it contains digits.
- A
True
- B
False
Which data-quality dimension asks whether the required records and fields are present?
A useful quality check reports an issue and its .
A customer table is joined to an orders table in which each customer may have many orders. Explain how this join can affect the number of rows per customer and the resulting grain, and name one risk to check.
A dataset has one row per order line, and an order may contain several lines. What does counting its rows measure?
- A
The number of customers who made purchases.
- B
The number of distinct orders, regardless of how many lines each contains.
- C
The number of order lines, which may be greater than the number of orders.
Select all statements that correctly connect data types or values to their analytical meaning.
- A
A product code such as
00127can be stored as text to preserve its leading zero and identifier meaning. - B
A missing value can be treated as zero whenever a field is numeric.
- C
A date or timestamp type can support representing events and ordering them over time.
- D
A missing value, zero, and an empty string can have different meanings.
Data-quality checks are only needed at the beginning of data handling because later processing cannot introduce new problems.
- A
True
- B
False
Which data-quality dimension concerns whether values conform to expected types, formats, and business rules?
When reporting a data-quality issue, state the issue and its analytical .
A team checks whether its data is current enough for a decision and covers the correct reporting period. Which data-quality dimension is it assessing?
- A
Accuracy
- B
Timeliness
- C
Consistency
- D
Validity
Joining one customer record to that customer's many order records can produce multiple rows for the customer and change the resulting grain.
- A
True
- B
False
What term describes what one record in a dataset represents?
A product code such as 00127 is an identifier, not a quantity. Which data type is most appropriate for storing it so its leading zero is preserved?
- A
Integer
- B
Decimal
- C
Text
- D
Boolean
A missing value should not automatically be treated as equivalent to zero, an empty string, or “not applicable.”
- A
True
- B
False
What is the concise term for the effect a data-quality issue could have on an analysis?
A dataset contains every required field, but some values may not reflect the real events they describe. Which data-quality dimension still needs to be assessed?
- A
Accuracy
- B
Completeness
- C
Uniqueness
- D
Timeliness
What type of key uniquely identifies a row in a table?
A transaction system reliably records completed purchases but omits people who never bought. What is the most relevant concern when deciding whether to use it to study all potential customers?
- A
It is necessarily inaccurate because it records transactions.
- B
It is necessarily incomplete because every data source must include every person.
- C
Its scope may exclude people who never made a purchase.
- D
Its grain must be one customer because it comes from a transaction system.
Related study packs and tools
- Study guide
1 Entrepreneurship and Opportunity Recognition
Learn how entrepreneurs identify meaningful customer problems, evaluate potential solutions, and use evidence to decide whether and how to pursue a venture.
- Flashcards
1 Globalization and the International Business Environment
Review how globalization shapes international business through cross-border connections, institutions, technology, economic forces, and risks.
- Quiz
03 Employee Selection and Onboarding
A medium-difficulty quiz on applying job-related selection practices, making documented hiring decisions, and planning effective onboarding.
- Flashcards
04 Employee Training and Development
Learn how to identify employee learning needs, design and deliver suitable training, and evaluate its effects on learning and workplace performance.
- Study guide
04 Employee Training and Development
Learn how to identify employee development needs, design and deliver suitable training, and evaluate whether learning transfers to work.
- Quiz
4 Mortgages and Real Estate Finance
A 14-question quiz on mortgage structures, loan costs, amortization, and real estate financing. Questions progress from core concepts to calculations and applied analysis.
- Flashcards
6 Real Estate Development
Learn the stages of real estate development, from site selection and feasibility through construction, opening, and operations.
- Quiz
6 Real Estate Development
A medium-difficulty quiz on applying the stages, decisions, and key concepts involved in real estate development.
- Study guide
6 Transportation Management
Learn how to select transportation modes and carriers, plan shipments, compare total logistics costs, and measure transportation performance.
- Flashcards
07 Employee Relations
Review the principles and practices that support effective communication, employee engagement, fair conflict resolution, and collective labor relations.
- Study guide
8 Managing Global Operations and Responsibility
Learn how to design and coordinate international operations while balancing efficiency, local responsiveness, resilience, supply-chain risk, cross-cultural partnerships, and responsible business conduct.
- Quiz
09 Organizational Development and Change
A medium-difficulty quiz on organizational culture, change, design, and organization development. Apply the concepts to workplace situations.