ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 169 - Certified Data Architect discussion

Report
Export

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.
Use selective queries to reduce the amount of data being returned.
Answers
A.
Use selective queries to reduce the amount of data being returned.
B.
De-normalize the data by reducing the number of joins.
Answers
B.
De-normalize the data by reducing the number of joins.
C.
Remove widgets from the dashboard to reduce the number of graphics loaded.
Answers
C.
Remove widgets from the dashboard to reduce the number of graphics loaded.
D.
Run the dashboard for CEO and send it via email.
Answers
D.
Run the dashboard for CEO and send it via email.
E.
Reduce the amount of data queried by archiving unused opportunity records.
Answers
E.
Reduce the amount of data queried by archiving unused opportunity records.
Suggested answer: A, B, E

Explanation:

To improve the dashboard performance, the data architect should use selective queries to reduce the amount of data being returned, de-normalize the data by reducing the number of joins, and reduce the amount of data queried by archiving unused opportunity records. These options will help optimize the query performance, reduce the query complexity, and free up storage space. Option C is incorrect because removing widgets from the dashboard to reduce the number of graphics loaded will not affect the dashboard performance significantly, and may reduce the usability and functionality of the dashboard. Option D is incorrect because running the dashboard for CEO and sending it via email will not improve the dashboard performance, but rather shift the burden to another user.

asked 23/09/2024
Assane SENE
39 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first