Data-Architect Exam Dumps - Salesforce Certified Data Architect (SU24)

Go to page:

Question # 17

Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers

Use the Force.com Workbench to export the data.

Schedule a weekly export file from the Salesforce UI.

Schedule jobs to export and delete using an ETL tool.

Schedule jobs to export and delete using the Data Loader.

Full Access

Question # 18

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?

Define external IDs for an object, migrate second database to first database, and load into Salesforce.

Define duplicate rules in Salesforce, and load data into Salesforce from both databases.

Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

Define external IDs for an object, Insert data from one database, and use upsert for a second database

Full Access

Question # 19

North 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 architect 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 middleware solution that extracts and distributes data across both the hub and spokes.

Develop custom APIs to poll the hub org for change data and push into the spoke orgs.

Develop custom APIs to poll the spoke for change data and push into the org.

A backup and archive solution that extracts and restores data across orgs.

Full Access

Question # 20

Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers

Create a report in an external system combining Salesforce Account data and Invoice data from the ERP.

Create a report combining data from the Account standard object and the Invoices external object.

Create a Visualforce page combining Salesforce Account data and Invoice external object data.

Create a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.

Full Access

Question # 21

Universal Containers has a requirement to store more than 100 million records in salesforce and needs to create a custom big object to support this business requirement.

Which two tools should a data architect use to build custom object?

Use DX to create big object.

Use Metadata API to create big object.

Go to Big Object In setup select new to create big object.

Go to Object manager In setup and select new to create big object.

Full Access

Question # 22

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

Full Access

Question # 23

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.

Full Access

Question # 24

Universal Containers (CU) 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?

Install a third-party AppExchange tool.

Call the REST API in successive queries.

Utilize PK Chunking with the Bulk API.

Use the Bulk API in parallel mode.

Full Access

Go to page: