Question 1 of 30
A retail company is looking to optimize its sales data model in Tableau CRM to better understand customer purchasing behavior. They have multiple data sources, including sales transactions, customer demographics, and product information. The data model needs to be designed to allow for complex queries that can analyze sales trends over time while also segmenting customers based on their purchasing patterns. Which approach should the company take to create an effective data model that supports these requirements?
Create a star schema with fact tables for sales transactions and dimension tables for customers and products, ensuring that relationships are properly defined to facilitate efficient querying.
Use a flat file structure that combines all data sources into a single table to simplify data access and reduce complexity.
Implement a snowflake schema that normalizes the data into multiple related tables, which may complicate queries but reduces data redundancy.
Develop a hybrid model that uses both star and snowflake schemas, but without clear documentation on how the tables relate to each other.

Preparing for SalesForce Certified Tableau CRM and Einstein Discovery Consultant Certified Tableau CRM and Einstein Discovery Consultant? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free