Free Data-Architect – Salesforce Certified Data Architect (WI23) Practice Test Question

Select all that apply, then click Submit answer.

• ○

  Make sure the query doesn't contain NULL in any filter criteria.
  

• ○

  Create a formula field instead of having multiple filter criteria.
  

• ○

  Create custom indexes on the fields used in the filter criteria.
  

• ○

  Modify the integration users' profile to have View All Data.
  

Select all that apply, then click Submit answer.

• ○

  Weekly Snapshots
  

• ○

  Einstein Analytics
  

• ○

  Setup Audit Trails
  

• ○

  AppExchange Apps
  

Select all that apply, then click Submit answer.

• ○

  Use selective queries to reduce the amount of data being returned.
  

• ○

  De-normalize the data by reducing the number of joins.
  

• ○

  Remove widgets from the dashboard to reduce the number of graphics loaded.
  

• ○

  Run the dashboard for CEO and send it via email.
  

• ○

  Reduce the amount of data queried by archiving unused opportunity records.

Select all that apply, then click Submit answer.

• ○

  Do client-side validation of phone number and email field formats.
  

• ○

  Prefer picklist form fields over free text fields, where possible.
  

• ○

  Ensure the website visitor is browsing using an HTTPS connection.
  

• ○

  Use cookies to track when visitors submit multiple forms.

Select all that apply, then click Submit answer.

• ○

  Consider whether the data is required for sales reports, dashboards and KPI’s.
  

• ○

  Determine if the data is driver of key process implemented within salesforce.
  

• ○

  Ensure there is a tight relationship between order data and an enterprise resource plaining (ERP) application.
  

• ○

  Ensure the data is CRM center and able to populate standard of custom objects.
  

• ○

  A selection of the tool required to replicate the data.
  a. – Heroku Connect is required but this is confusing
  

Select all that apply, then click Submit answer.

• ○

  How many fields are defined on the custom objects that need to be archived?
  

• ○

  Which profiles and users currently have access to these custom object records?
  

• ○

  If reporting is necessary, can the information be aggregated into fewer, summary records?
  

• ○

  Will the data being archived need to be reported on or accessed in any way in the future?
  

• ○

  Are there any regulatory restrictions that will influence the archiving and purging plans?

Select all that apply, then click Submit answer.

• ○

  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.

Select an option, then click Submit answer.

• ○

  Create indexes on Opportunity object text fields.

• ○

  Group batches by the AccountId field.

• ○

  Sort batches by Name field values.

• ○

  Order batches by Auto -number field.

Select an option, then click Submit answer.

• ○

  Service Cloud
  

• ○

  Sales Cloud
  

• ○

  Light Platform Start
  

• ○

  Lighting platform plus

Select an option, then click Submit answer.

• ○

  Leverage Canvas to bring the order management UI in to the Salesforce tab.
  

• ○

  Build batch jobs to push order line items to salesforce.
  

• ○

  leverage Salesforce Connect top bring the order line item from the legacy system to Salesforce.
  

• ○

  Build real-time integration to pull order line items into Salesforce when viewing orders.

Select an option, then click Submit answer.

• ○

  Extract the Salesforce data into Excel and manually compare this against the trusted source.
  

• ○

  Load the Trusted Source data into Salesforce and run an Apex Batch job to find difference.
  

• ○

  Use an AppExchange package for Data Quality to match Salesforce data against the Trusted source.
  

• ○

  Leave the data in Salesforce alone and assume that it will auto-correct itself over time.

Select an option, then click Submit answer.

• ○

  Create a custom object and migrate the last 12 months of Invoice data into Salesforce so it can be displayed on the Account layout.
  

• ○

  Write an Apex callout and populate a related list to display on the account record.
  

• ○

  Create a mashup page that will present the billing system records within Salesforce.
  

• ○

  Create a visual force tab with the billing system encapsulated within an iframe.

Select an option, then click Submit answer.

• ○

  Use third-party AppExchange tools to monitor and measure data quality.
  

• ○

  Generate reports to view the quality of sample data.
  

• ○

  Use custom objects and fields to calculate data quality.
  

• ○

  Export the data to an enterprise data warehouse and use BI tools for data quality.

Select an option, then click Submit answer.

• ○

  Add additional options to the standard ContentType picklist field for the Attachment object.
  

• ○

  Add a ContentType picklist field to the Attachment layout and create additional picklist options.
  

• ○

  Create a custom picklist field for the Type on the standard Attachment object with the values.
  

• ○

  Create a custom object related to the Invoice object with a picklist field for the Type.
  

Select an option, then click Submit answer.

• ○

  Use a custom auto number and formula field and use that to chunk records while extracting data.
  

• ○

  The REST API to extract data as it automatically chunks records by 200.
  

• ○

  Use ETL tool for extraction of records.
  

• ○

  Ask SF support to increase the query timeout value.