Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?

• A.Modify the export job header to specify Export-in-Parallel.
• B.Modify the export job header to specify Sforce-Enable-PKChunking.
• C.Modify the export query that includes standard index fields(s).
• D.Modify the export query with LIMIT clause with Batch size 10,000.

Comment: *

Name: *

Email: *

Verification: *

NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and 100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.
Which 3 options should help improve the dashboard performance?
Choose 3 answers:

• A.Remove widgets from the dashboard to reduce the number of graphics loaded.
• B.Reduce the amount of data queried by archiving unused opportunity records.
• C.Use selective queries to reduce the amount of data being returned.
• D.Run the dashboard for CEO and send it via email.
• E.De-normalize the data by reducing the number of joins.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:

• A.Use Big objects for cases older than 2 years, and use nightly batch to move them.
• B.Use custom objects for cases older than 2 years and use nightly batch to move them.
• C.Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.
• D.Sync cases older than 2 years to an external database, and provide access to Service agents to the database

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) is migrating data from legacy system to Salesforce. During data analysis it was discovered that data types of fields being migrated do not match with Salesforce data types.
Which solution should a data architect use to ensure successful data migrations?

• A.Migrate the legacy data leveraging an ETL tool to transform data types and load data into Salesforce.
• B.Export legacy data into the staging database and leverage stored procedures to transform data types before loading into Salesforce.
• C.Migrate legacy data to a staging database for mapping then leverage an ETL tool to transform the data and load into Salesforce.
• D.Export legacy data into CSV files and leverage data loader to load data into Salesforce.

Comment: *

Name: *

Email: *

Verification: *

Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system. How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

• A.Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
• B.Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
• C.Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
• D.Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.

Comment: *

Name: *

Email: *

Verification: *