ExamGecko
Search Search Login
Home Home / Salesforce / Certified Data Architect
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
Get Cloud Consulting needs to integrate two different systems with customer records into the Salesforce Account object. So that no duplicate records are created in Salesforce, Master Data Management will be used. An Architect needs to determine which system is the system of record on a field level. What should the Architect do to achieve this goal?
Universal Containers (UC) is migrating from a legacy system to Salesforce CRM, UC is concerned about the quality of data being entered by users and through external integrations. Which two solutions should a data architect recommend to mitigate data quality issues?
Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?
As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers
DreamHouse Realty has a data model as shown in the image. The Project object has a private sharing model, and it has Roll-Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce. What should the Architect consider in this situation?
Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers
An Architect needs to document the data architecture for a multi-system, enterprise Salesforce implementation. Which two key artifacts should the Architect use? (Choose two.)
Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?
A national nonprofit organization is using Salesforce to recruit members. The recruitment process requires a member to be matched with a volunteer opportunity. Given the following: 1. A record is created in Project__ c and used to track the project through completion. 2. The member may then start volunteering and is required to track their volunteer hours, which is stored in VTOTime_c object related to the project. 3. Ability to view or edit the VTOTime__c object needs to be the same as the Project__ c record. 4. Managers must see total hours volunteered while viewing the Project__ c record. Which data relationship should the data architect use to support this requirement when creating the custom VTOTime__c object?

Question 91 - Certified Data Architect discussion

Report
Export

Which three characteristics of a skinny table help improve report and query performance?

A.
Skinny tables can contain frequently used fields and thereby help avoid joins.
Answers
A.
Skinny tables can contain frequently used fields and thereby help avoid joins.
B.
Skinny tables can be used to create custom indexes on multi-select picklist fields.
Answers
B.
Skinny tables can be used to create custom indexes on multi-select picklist fields.
C.
Skinny tables provide a view across multiple objects for easy access to combined data.
Answers
C.
Skinny tables provide a view across multiple objects for easy access to combined data.
D.
Skinny tables are kept in sync with changes to data in the source tables.
Answers
D.
Skinny tables are kept in sync with changes to data in the source tables.
E.
Skinny tables do not include records that are available in the recycle bin.
Answers
E.
Skinny tables do not include records that are available in the recycle bin.
Suggested answer: A, D, E

Explanation:

The three characteristics of a Skinny table that help improve report and query performance are: Skinny tables can contain frequently used fields and thereby help avoid joins. Skinny tables are kept in sync with changes to data in the source tables. Skinny tables do not include records that are available in the recycle bin. These characteristics are beneficial because they reduce the query complexity and execution time, and improve the data accuracy and freshness.For example, skinny tables can contain frequently used fields from multiple objects, such as Account and Contact, and thereby help avoid joins that can slow down queries4.Skinny tables are updated automatically when the source tables are modified, so they always reflect the latest data5. Skinny tables do not include records that are available in the recycle bin, so they only contain active records that are relevant for reports and queries.

Show Answer
asked 23/09/2024
Diego Beltran
53 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms