← Back to exam page

Data-Architect – Salesforce Certified Data Architect (WI23)

Loading demo links...

Showing 1–3 of 15 questions

Question 1

A company has 12 million records, and a nightly integration queries these records.

Which two areas should a Data Architect investigate during troubleshooting if queries are timing out? (Choose two.)

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.
Question 2

DreamHouse Realty has a Salesforce deployment that manages Sales, Support, and Marketing efforts in a multi-system ERP environment. The company recently reached the limits of native reports and dashboards and needs options for providing more analytical insights.

What are two approaches an Architect should recommend? (Choose two.)

Select all that apply, then click Submit answer.

  • ○

    Weekly Snapshots
  • ○

    Einstein Analytics
  • ○

    Setup Audit Trails
  • ○

    AppExchange Apps
Question 3

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:

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.