Free Data Architecture And Management Designer Exam Data-Architecture-And-Management-Designer Exam Practice Test

UC migrating 100,000 Accounts from an enterprise resource planning (ERP) to salesforce and is concerned about ownership skew and performance.Which 3 recommendations should a data architect provide to prevent ownership skew?Choose 3 answers:

• Assigned a default user as owner of accounts, and assign role in hierarchy.
• Keep users out of public groups that can be used as the source for sharing rules.
• Assign a default user as owner of account and do not assign any role to default user.
• Assign ''view all'' permission on profile to give access to account.
• Assign a default user as owner of accounts and assigned top most role in hierarchy.

NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

• Define data duplication standards and rules
• Define key fields in staging database for data cleansing
• Measure data timeliness and consistency
• Finalize an extract transform load (ETL) tool for data migration
• Measure data completeness and accuracy

UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.Which design patterns should a data architect select to satisfy the requirement?

• Migrate and persist the data in SF to take advantage of native functionality.
• Use SF Connect to virtualize the data in SF and avoid storage limits.
• Develop a bidirectional integration between the on-premise system and Salesforce.
• Build a UI for the on-premise system and iframe it in Salesforce

Universal Containers (UC) is going thought major reorganization of their sales team. This would require changes to a large a number of group members and sharing rules. UCs administrator is concerned about long processing time and failure during the process.What should a Data architect implement to make changes efficiently?

• Log a case with salesforce to make sharing rule changes.
• Enable Defer Sharing Calculation prior to making sharing rule changes.
• Delete old sharing rules and build new sharing rules
• Log out all users and make changes to sharing rules.

The data architect for UC 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 != NULLWhen the data architect usages 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?

• Remove description from the requested field set.
• Change query to SOSL. ??
• Add limit 100 to the query.
• Change the where clause to filter by a deterministic defined value.

UC is trying to switch from legacy CRM to salesforce and wants to keep legacy CRM and salesforce in place till all the functionality is deployed in salesforce. The want to keep data in synch b/w Salesforce, legacy CRM and SAP. What is the recommendation.

• Integrate legacy CRM to salesforce and keep data in synch till new functionality is in place
• Do not integrate legacy CRM to Salesforce, but integrate salesforce to SAP
• Integrate SAP with Salesforce, SAP to legacy CRM but not legacy CRM to Salesforce
• Suggest MDM solution and link MDM to salesforce and SAP

Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team the following issues with data entered in Salesforce.Information in certain records is incomplete.Incorrect entry in certain fields causes records to be excluded in report fitters.Duplicate entries cause incorrect counts.Which three steps should a data architect recommend to address the issues?

• Periodically export data to cleanse data and import them back into Salesforce for executive reports.
• Build a sales data warehouse with purpose-build data marts for dashboards and senior management reporting.
• Explore third-party data providers to enrich and augment information entered in salesforce.
• Leverage Salesforce features, such as validate rules, to avoid incomplete and incorrect records.
• design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc. Which three questions should be considered when designing an appropriate archiving strategy?

• How many fields are defined on the custom objects that need to be archived?
• Which profiles and users currently have access to these custom object records?
• If reporting is necessary, can the information be aggregated into fewer, summary records?
• Will the data being archived need to be reported on or accessed in any way in the future?
• Are there any regulatory restrictions that will influence the archiving and purging plans?

Universal Containers (UC) uses the following Salesforce products:Sales Cloud for customer management.Marketing Cloud for marketing.Einstein Analytics for business reporting.UC occasionally gets a list of prospects from third-party source as comma-separated values (CSV) files for marketing purposes. Historically, UC would load contact Lead object in Salesforce and sync to Marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing Cloud to send marketing communications. The number of records in the Lead object has grown over time and has been consuming large amounts of storage in Sales Cloud, UC is looking for recommendations to reduce the storage and advice on how to optimize the marketing process.What should a data architect recommend to UC in order to immediately avoid storage issues in the future?

• Load the CSV files in Einstein Analytics and sync with Marketing Cloud prior to sending marketing communications ;
• Load the CSV files in an external database and sync with Marketing Cloud prior to sending marketing communications.
• Load the contacts directly to Marketing Cloud and have a reconciliation process to track prospects that are converted to customers.
• Continue to use the existing process to use Lead object to sync with Marketing Cloud and delete Lead records from Sales after the sync is complete.

UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

• Use picklist fields rather than lookup to custom object.
• Limit assigning one user 10000 records ownership.
• Assign 10000 opportunities to one account.
• Limit associating 10000 opportunities to one account.
• Limit associating 10000 records looking up to same records.