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.Use a custom auto number and formula field and use that to chunk records while extracting data.
• C.The REST API to extract data as it automatically chunks records by 200.
• D.Ask SF support to increase the query timeout value.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers has a rollup summary field on account to calculate the count of contacts associated with an account. During the account load, Salesforce is throwing an "Unable to lock a row" error.
Which solution should a data architect recommend to resolve the error?

• A.Perform batch job in parallel mode, and reduce batch size
• B.Defer rollup summary fields calculation during data migration
• C.Leverage data loader platform API to load data
• D.Perform batch job in serial mode, and reduce batch size

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?

• A.Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container.
  Implement an archiving process that runs every hour.
• B.Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.
• C.Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC's existing data warehouse.
• D.Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master- detail relationship to the container object.

Comment: *

Name: *

Email: *

Verification: *

Get Cloudy Consulting needs to evaluate the completeness and consistency of contact information in Salesforce. Their sales reps often have incomplete information about their accounts and contacts. Additionally, they are not able to interpret the information in a consistent manner. Get Cloudy Consulting has identified certain ""key"" fields which are important to their sales reps.
What are two actions Get Cloudy Consulting can take to review their data for completeness and consistency?
(Choose two.)

• A.Run a process that can fill in default values for blank fields.
• B.Run a report which shows the last time the key fields were updated.
• C.Run a report that shows the percentage of blanks for the important fields.
• D.Run one report per key field, grouped by that field, to understand its data variability.

Comment: *

Name: *

Email: *

Verification: *

Northern Trail Outfitters (NTO) has the following systems:
Customer master-source of truth for customer information
Service cloud-customer support
Marketing cloud-marketing support
Enterprise data warehouse-business reporting
The customer data is duplicated across all these system and are not kept in sync. Customers are also complaining that they get repeated marketing emails and have to call into update their information.
NTO is planning to implement master data management (MDM) solution across the enterprise.
Which three data will an MDM tool solve?
Choose 3 answers

• A.Data loss and recovery
• B.Data accuracy and quality
• C.Data completeness
• D.Data standardization
• E.Data duplication

Comment: *

Name: *

Email: *

Verification: *