Salesforce Certified Data Architect - Certified Data Architect Exam
Page: 3 / 28
Total 136 questions
Question #11 (Topic: Exam A)
Northern Trail Outfitters (NTO) runs its entire business out of an enterprise data warehouse (EDW). NTO’s sales team is starting to use Salesforce after a recent implementation, but currently lacks the data required to advance leads and opportunities to the next stage.
NTO’s management has researched Salesforce Connect and would like to use it to virtualize and report on data from the EOW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?
NTO’s management has researched Salesforce Connect and would like to use it to virtualize and report on data from the EOW within Salesforce. NTO will be running thousands of reports per day across 10 to 15 external objects.
What should a data architect consider before implementing Salesforce Connect for reporting?
A. Maximum page size for server-driven paging
B. Maximum external objects per org
C. OData callout limits per day
D. Maximum number of records returned
Answer: C
Question #12 (Topic: Exam A)
The data architect for Universal Containers has written a SOQL query that will return all records from the Task object that do not have a value in the whatID field:
SELECT ID, Description, subject FROM Task WHERE WhatID != NULL
When the data architect uses the query to select values for a process, a time-out error occurs.
What does the data architect need to change to make this query more performant?
SELECT ID, Description, subject FROM Task WHERE WhatID != NULL
When the data architect uses the query to select values for a process, a time-out error occurs.
What does the data architect need to change to make this query more performant?
A. Change the WHERE clause to filter by a deterministic defined value.
B. Change query to SOSL.
C. Remove description from the requested field set.
D. Add LIMIT 100 to the query.
Answer: C
Question #13 (Topic: Exam A)
Northern Trail Outfitters (NTO) has a variety of customers that include households, businesses, and individuals.
The following conditions exist within its system:
1. NTO has a total of five million customers.
2. Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three options should a data architect perform to resolve the Issues with the customer data? (Choose three.)
The following conditions exist within its system:
1. NTO has a total of five million customers.
2. Duplicate records exist, which is replicated across many systems, including Salesforce.
Given these conditions, there is a lack of consistent presentation and clear identification of a customer record.
Which three options should a data architect perform to resolve the Issues with the customer data? (Choose three.)
A. Invest in data duplication tool to de-dupe and merge duplicate records across all systems.
B. Use Salesforce CDC to sync customer data across all systems to keep customer record in sync.
C. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.
D. Create a unique global customer ID for each customer and store that in all systems for referential identity.
E. Duplicate customer records across the systems and provide a two-way sync of data between the systems.
Answer: ACD
Question #14 (Topic: Exam A)
Northern Trail Outfitters (NTO) wants to implement backup and restore for Salesforce data. Currently, it has data backup processes that runs weekly, which backs up all Salesforce data to an enterprise data warehouse (EDW). NTO wants to move to daily backups and provide restore capability to avoid any data loss in case of outage.
What should a data architect recommend for a daily backup and restore solution?
What should a data architect recommend for a daily backup and restore solution?
A. Change weekly backup process to daily backup, and implement a custom restore solution.
B. Use Bulk API to extract data on daily basis to EDW and REST API for restore.
C. Use ETL tool for backup and restore from EDW.
D. Use AppExchange package for backup and restore.
Answer: D
Question #15 (Topic: Exam A)
Northern Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org. NTO also owns several secondary orgs that the service, finance, and marketing teams work out of. At the moment, there is no integration between central and secondary orgs, leading to data visibility issues.
Moving forward, NTO has identified that a hub-and-spoke model is the proper architecture to manage its data, where the central org is the hub and the secondary orgs are the spokes.
Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?
Moving forward, NTO has identified that a hub-and-spoke model is the proper architecture to manage its data, where the central org is the hub and the secondary orgs are the spokes.
Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?
A. A middleware solution that extracts and distributes data across both the hub and spokes.
B. Develop custom APIs to poll the spoke org for change data and push into the hub org.
C. Develop custom APIs to poll the hub org for change data and push into the spoke orgs.
D. A backup and archive solution that extracts and restores data across orgs.
Answer: A
