Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Salesforce Certified Data Architect · Salesforce
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
D is the correct answer, as data mart is a subset of a data warehouse oriented to a specific business line. Data marts contain repositories of summarized data collected for analysis on a specific section or unit within an organization, for example, the sales department.
Not A - Data mart can provide a consolidated view, but it requires data extraction and processing. Not B - Cannot provide insights into ongoing activities. Not C - Costly, complex, and introduce performance issues. D - Real-time access, flexible and scalable.
D is the best option as Salesforce Connect would be a good way to bring this data into salesforce without actually storing it in salesforce. There doesn't sound like overlap in data so an MDM system doesn't call for an ETL tool. Not A, we don't want to replicate data if we can avoid it. Not B, this is extremely resource taxing and would run into issues with LDV. Not C, we don't want to replicate data if we can avoid it.