Two designs were proposed. Design A would compare relational and dimensional models. Design B would define primary keys in datasets. The team must pick the approach aligned with vendor best practices. Which choice is correct?
Multiple choice — select one answer
Answer choices
Architectural breakdown & explanation
Models affect query performance. Compare with Unique identifiers per entity grain: Keys enforce relational integrity.
Correct answer(s): a. Star/snowflake schemas for analytics
Exam domain: Domain 1: Data Concepts and Environments (25% weight on the official guide).
Official documentation & study links
Practice this certification
This page is one question from the CompTIA Data+ bank. Run a full timed practice exam with domain-weighted random questions in your browser.