Free Salesforce Data-Architect Exam Dumps Questions & Answers

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:

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

Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they ' ve purchased UC ' s new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC ' s new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?

• A.Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
• B.Implement a new Categories custom object and create a lookup field from Account to Category.
• C.Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
• D.Implement a new Categories custom object and a master-detail relationship from Account to Category.

NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.
What should a data architect recommend in order to get around the time out issue?

• A.Use ETL tool for extraction of records.
• B.The REST API to extract data as it automatically chunks records by 200.
• C.Ask SF support to increase the query timeout value.
• D.Use a custom auto number and formula field and use that to chunk records while extracting data.

A shipping and logistics company has created a large number of reports within Sales Cloud since Salesforce was introduced. Some of these reports analyze large amounts of data regarding the whereabouts of the company ' s containers, and they are starting to time out when users are trying to run the reports. What is a recommended approach to avoid these time-out issues?

• A.Improve reporting performance by replacing the existing reports in Sales Cloud with new reports based on Analytics Cloud.
• B.Improve reporting performance by creating a dashboard that is scheduled to run the reports only once per day.
• C.Improve reporting performance by creating a custom Visualforce report that is using a cache of the records in the report.
• D.Improve reporting performance by creating an Apex trigger for the Report object that will pre-fetch data before the report is run.

Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations.
Which two solutions should a data architect recommend to mitigate data quality issues?

• A.Leverage validation rules and workflows.
• B.Leverage picklist and lookup fields where possible
• C.Leverage Apex to validate the format of data being entered via a mobile device.
• D.Leverage third-party- AppExchange tools