Certified Data Architect Practice Test practice questions, page 4 of 6, with answer review and explanations.
Question 16
A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems: 1. Salesforce CRM 2. Custom billing solution 3. Customer master data management (MDM) 4. Contract management system 5. Marketing solution What should a data architect recommend that would help uniquely identify the customer across multiple systems?
Store the Salesforce ID in all the solutions to identify the customer.
Create a custom field as external ID to maintain the customer ID from the MDM solution.
Create a custom object that will serve as a cross-reference for the customer ID.
Create a customer database, and use this ID in all systems.
Question 17
Northern Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly. Which two native tools should a data architect recommend to achieve this reporting requirement? (Choose two.)
Standard SOQL queries
Async SOQL with a custom object
Standard reports and dashboards
Einstein Analytics
Question 18
To address different compliance requirements such as General Data Protection Regulation (GDPR), personally identifiable information (PII), Health Insurance Portability and Accountability Act (HIPPA) and others, a Salesforce customer decided to categorize each data element in Salesforce with the following: 1. Data owner 2. Security level (i.e. confidential) 3. Compliance type (i.e. GDPR. PII, HIPAA) A compliance audit would require Salesforce admins to generate reports to manage compliance. What should a data architect recommend to address this requirement?
Build reports for field Information, then export the information to classify and report for audits.
Create a custom object and field to capture necessary compliance information and build custom reports.
Use the Metadata API to extract field attribute information and use the extract to classify and build reports.
Use field metadata attributes for compliance categorization, data owner, and data sensitivity level.
Question 19
Universal Containers (UC) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW. What data extraction strategy should a data architect use for maximum performance?
Utilize PK Chunking with the Bulk API.
Install a third-party AppExchange tool.
Use the Bulk API in parallel mode.
Call the REST API in successive queries.
Question 20
Northern Trail Outfitters (NTO) has the following systems: Customer master—source of truth for customer information Service cloud—customer support - Marketing cloud—marketing communications Enterprise data warehouse-business reporting The customer data is duplicated across all these systems and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call in to update their information. NTO is planning to implement a master data management (MDM) solution across the enterprise. Which three data issues will an MDM tool solve? (Choose three.)