A company has a custom object 'Order' with a lookup to 'Account'. They need to report on the total number of orders per account, including accounts with zero orders. Which report type should they use?

Report on Accounts with a lookup to Orders

Report on Orders with a lookup to Accounts

When designing a data model, what is a key trade-off between using a highly normalized schema and a denormalized schema?

Denormalized schemas improve write performance but reduce data integrity.

Normalized schemas are easier to query but require more storage space.

Normalized schemas improve data integrity but can reduce query performance due to more joins.

Denormalized schemas are always better for performance and integrity.

SalesforceCertified Data Architect

Domain 1Objective 1

Compare and Contrast Various Techniques and Considerations for Designing Lightning Platform Data Model (e.g., Objects, Fields & Relationships, Object Features). DATA-ARCHITECT Practice Questions (Page 3)

Part of the DATA MODELING domain, which accounts for 20% of the DATA-ARCHITECT exam.

15questions here

3free pages

6concepts

20%of the exam

Questions 11–15

11foundation · medium
Which type of relationship automatically inherits the parent record's sharing and security settings, and deleting the parent record deletes the child records?
Select an answer first
12expert · medium
A company has a custom object 'Order' with a lookup to 'Account'. They need to report on the total number of orders per account, including accounts with zero orders. Which report type should they use?
Select an answer first
13foundation · medium
Which field type is used to store a unique identifier from an external system to facilitate data integration and prevent duplicate records?
Select an answer first
14foundation · medium
When designing a data model, what is a key trade-off between using a highly normalized schema and a denormalized schema?
Select an answer first
15foundation · medium
Which type of object in the Lightning Platform is used to store data that resides in an external system and is accessed via an external data source?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DATA-ARCHITECT

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “DATA-ARCHITECT” is a trademark of its owner, used for identification only.

Compare and Contrast Various Techniques and Considerations for Designing Lightning Platform Data Model (e.g., Objects, Fields & Relationships, Object Features). DATA-ARCHITECT Practice Questions (Page 3)

Questions 11–15

Which type of relationship automatically inherits the parent record's sharing and security settings, and deleting the parent record deletes the child records?

A company has a custom object 'Order' with a lookup to 'Account'. They need to report on the total number of orders per account, including accounts with zero orders. Which report type should they use?

Which field type is used to store a unique identifier from an external system to facilitate data integration and prevent duplicate records?

When designing a data model, what is a key trade-off between using a highly normalized schema and a denormalized schema?

Which type of object in the Lightning Platform is used to store data that resides in an external system and is accessed via an external data source?

Keep studying — DATA MODELING