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

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?

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

Correct Answer: BCD

Universal Containers (UC) is expecting to have nearly 5 million shipments records in its Salesforce org. Each shipment record has up to 10 child shipment item records. The Shipment custom object has an
Organization-wide Default (OWD) sharing model set to Private and the Shipment Item custom object has a Master-Detail relationship to Shipment. There are 25 sharing rules set on the Shipment custom object, which allow shipment records to be shared to each of UC's 25 business areas around the globe. These sharing rules use public groups, one for each business area plus a number of groups for management and support roles. UC has a high turnover of Sales Reps and often needs to move Sales Reps between business areas in order to meet local demand. What feature would ensure that performance, when moving Sales Reps between regions, remains adequate while meeting existing requirements?

1. A. Implement data archiving for old Shipment records.
2. B. Contact Salesforce to create Skinny tables on Shipment.
3. C. Configure shipment OWD to Public Read/Write.
4. D. Contact Salesforce to enable Defer Sharing Rules

Correct Answer: D

Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?

1. A. Define external IDs for an object, migrate second database to first database, and load into Salesforce.
2. B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
3. C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
4. D. Define external IDs for an object, Insert data from one database, and use upsert for a second database

Correct Answer: D

Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?

1. A. Leverage real-time integration to pull records into Salesforce.
2. B. Bring all data Salesforce, and delete it after a year.
3. C. Leverage mashup to display historical records in Salesforce.
4. D. Build a chair solution to go the legacy system and display records.

Correct Answer: C

UC has to built a B2C ecommerce site on Heroku that shares customer and order data with a Heroku Postgres database. UC is currently utilizing Postgres as the single source of truth for both customers and orders. UC has asked a data architect to replicate the data into salesforce so that salesforce can now act as the system of record.
What are the 3 considerations that data architect should weigh before implementing this requirement? Choose 23 answers:

1. A. Consider whether the data is required for sales reports, dashboards and KPI’s.
2. B. Determine if the data is driver of key process implemented within salesforce.
3. C. Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.
4. D. Ensure the data is CRM center and able to populate standard of custom objects.
5. E. A selection of the tool required to replicate the data.
6. F. – Heroku Connect is required but this is confusing

Correct Answer: BD