Salesforce DATA-ARCHITECT Online Practice Questions and Exam Preparation

Salesforce DATA-ARCHITECT Online Questions & Answers

• Question 171:

  Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.

  What data extraction strategy should a data architect use for maximum performance?

  A. Install a third-party AppExchange tool.
  B. Call the REST API in successive queries.
  C. Utilize PK Chunking with the Bulk API.
  D. Use the Bulk API in parallel mode.
  C. Utilize PK Chunking with the Bulk API.

  ---

  Explanation

  According to the Salesforce documentation2, extracting large amounts of data from Salesforce can be challenging and time-consuming, as it can encounter performance issues, API limits, timeouts, etc. To extract 100 million records from Salesforce for migration to an enterprise data warehouse (EDW), a data extraction strategy that can provide maximum performance is: Utilize PK Chunking with the Bulk API (option C). This means using a feature that allows splitting a large query into smaller batches based on the record IDs (primary keys) of the queried object. This can improve performance and avoid timeouts by processing each batch asynchronously and in parallel using the Bulk API3. Installing a third-party AppExchange tool (option A) is not a good solution, as it can incur additional costs and dependencies. It may also not be able to handle such a large volume of data efficiently. Calling the REST API in successive queries (option B) is also not a good solution, as it can encounter API limits and performance issues when querying such a large volume of data. Using the Bulk API in parallel mode (option D) is also not a good solution, as it can still cause timeouts and errors when querying such a large volume of data without chunking.

• Question 172:

  North Trail Outfitters (NTO) operates a majority of its business from a central Salesforce org, NTO also owns several secondary orgs that the service, finance, and marketing teams work out of, At the moment, there is no integration between central and secondary orgs, leading to data-visibility issues.

  Moving forward, NTO has identified that a hub-and-spoke model is the proper architect to manage its data, where the central org is the hub and the secondary orgs are the spokes.

  Which tool should a data architect use to orchestrate data between the hub org and spoke orgs?

  A. A middleware solution that extracts and distributes data across both the hub and spokes.
  B. Develop custom APIs to poll the hub org for change data and push into the spoke orgs.
  C. Develop custom APIs to poll the spoke for change data and push into the org.
  D. A backup and archive solution that extracts and restores data across orgs.
  A. A middleware solution that extracts and distributes data across both the hub and spokes.

  ---

  Explanation

  According to the Salesforce documentation, a hub-and-spoke model is an integration architecture pattern that allows connecting multiple Salesforce orgs using a central org (hub) and one or more secondary orgs (spokes). The hub org acts as the master data source and orchestrates the data flow between the spoke orgs. The spoke orgs act as the consumers or producers of the data and communicate with the hub org. To orchestrate data between the hub org and spoke orgs, a data architect should use: A middleware solution that extracts and distributes data across both the hub and spokes (option A). This means using an external service or tool that can connect to multiple Salesforce orgs using APIs or connectors, and perform data extraction, transformation, and distribution operations between the hub and spoke orgs. This can provide a scalable, flexible, and reliable way to orchestrate data across multiple orgs.

  Developing custom APIs to poll the hub org for change data and push into the spoke orgs (option B) is not a good solution, as it can be complex, costly, and difficult to maintain. It may also not be able to handle large volumes of data or complex transformations efficiently. Developing custom APIs to poll the spoke orgs for change data and push into the hub org (option C) is also not a good solution, as it can have the same drawbacks as option B. It may also not be able to handle conflicts or errors effectively. Using a backup and archive solution that extracts and restores data across orgs (option D) is also not a good solution, as it can incur additional costs and dependencies. It may also not be able to handle real-time or near-real-time data orchestration requirements.

• Question 173:

  Cloud Kicks stores Invoice records in a custom object. Invoice records are being sent to the Accounting department with missing States and incorrectly formatted Postal Codes.

  Which two actions should Cloud Kicks take to improve data quality? (Choose two.)

  A. Change each address field to require on the Page Layout.
  B. Write an Apex Trigger to require all fields to be populated.
  C. Utilize a Validation Rule with a REGEX operator on Postal Code.
  D. Utilize a Validation Rule with a CONTAINS operator on address fields.
  C. Utilize a Validation Rule with a REGEX operator on Postal Code.
  D. Utilize a Validation Rule with a CONTAINS operator on address fields.

  ---

  Explanation

  Utilizing a Validation Rule with a REGEX operator on Postal Code and utilizing a Validation Rule with a CONTAINS operator on address fields are two actions that Cloud Kicks should take to improve data quality for their Invoice records. A Validation Rule with a REGEX operator can check if the Postal Code field matches a specific pattern or format, such as a five-digit number or a combination of letters and numbers. A Validation Rule with a CONTAINS operator can check if the address fields contain certain values, such as valid state abbreviations or country names. These Validation Rules can prevent users from saving invalid or incomplete data and display error messages to guide them to correct the data. The other options are not effective or recommended for improving data quality, as they would either require additional customization, not enforce data standards, or not address the specific issues of missing states and incorrectly formatted postal codes

• Question 174:

  DreamHouse Realty has 15 million records in the Order_c custom object. When running a bulk query, the query times out.

  What should be considered to address this issue?

  A. Tooling API
  B. PK Chunking
  C. Metadata API
  D. Streaming API
  B. PK Chunking

  ---

  Explanation

  PK Chunking is a feature of the Bulk API that allows splitting a large query into smaller batches based on the primary key of the object. This can improve the performance and avoid query timeouts when querying large data sets

• Question 175:

  Universal Containers has successfully migrated 50 million records into five different objects multiple times in a full copy sandbox. The Integration Engineer wants to re-run the test again a month before it goes live into Production.

  What is the recommended approach to re-run the test?

  A. Truncate all 5 objects quickly and re-run the data migration test.
  B. Refresh the full copy sandbox and re-run the data migration test.
  C. Hard delete all 5 objects' data and re-run the data migration test.
  D. Truncate all 5 objects and hard delete before running the migration test.
  B. Refresh the full copy sandbox and re-run the data migration test.

  ---

  Explanation

  The recommended approach to re-run the test is to refresh the full copy sandbox and re-run the data migration test. A full copy sandbox is a replica of the production Org, including all data, metadata, and attachments. Refreshing a full copy sandbox means creating a new copy of the production Org and replacing the existing sandbox. This would ensure that the test is run on a clean and up-to-date environment, without any leftover data or configuration from previous tests.

  Truncating or hard deleting objects would not be sufficient, because they would not remove all the data or metadata from the sandbox, and they could also affect other dependent objects or processes.

• Question 176:

  UC is rolling out Sales App globally to bring sales teams together on one platform. UC expects millions of opportunities and accounts to be creates and is concerned about the performance of the application.

  Which 3 recommendations should the data architect make to avoid the data skew? Choose 3 answers.

  A. Use picklist fields rather than lookup to custom object.
  B. Limit assigning one user 10000 records ownership.
  C. Assign 10000 opportunities to one account.
  D. Limit associating 10000 opportunities to one account.
  E. Limit associating 10000 records looking up to same records.
  B. Limit assigning one user 10000 records ownership.
  D. Limit associating 10000 opportunities to one account.
  E. Limit associating 10000 records looking up to same records.

  ---

  Explanation

  Data skew occurs when a large number of child records are associated with a single parent record, or when a single user owns a large number of records. This can cause performance issues and lock contention. To avoid data skew, the data architect should limit assigning one user 10,000 records ownership, limit associating 10,000 opportunities to one account, and limit associating 10,000 records looking up to the same record

• Question 177:

  A health care provider wishes to use salesforce to track patient care. The following actions are in Salesforce

  1. Payment Providers: Orgas who pay for the care 2 patients.

  2. Doctors: They provide care plan for patients and need to support multiple patients, they are provided access to patient information.

  3. Patients: They are individuals who need care.

  A data architect needs to map the actor to Sf objects.

  What should be the optimal selection by the data architect?

  A. Patients as Contacts, Payment providers as Accounts, & Doctors as Accounts
  B. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Contacts
  C. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account
  D. Patients as Accounts, Payment providers as Accounts, & Doctors as Person Accounts
  C. Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Account

  ---

  Explanation

  Patients as Person Accounts, Payment providers as Accounts, & Doctors as Person Accounts is the optimal selection by the data architect to map the actor to Salesforce objects. This is because Person Accounts are a special type of accounts that can store both business and personal information for individual customers. Payment providers are organizations that pay for the care of patients, so they can be modeled as Accounts. Doctors are also individuals who provide care plans for patients and need access to patient information, so they can also be modeled as Person Accounts.

• Question 178:

  Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.

  Which governance measure should a data architect recommend to solve this issue?

  A. Add description fields to explain why the field is used, and mark the field as required.
  B. Create and manage a data dictionary and ups a governance process for changes made to common objects.
  C. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
  D. Create validation rules with error messages to explain why the fields is used
  B. Create and manage a data dictionary and ups a governance process for changes made to common objects.

  ---

  Explanation

  To solve the issue of lack of governance in making changes to Salesforce, a data architect should recommend creating and managing a data dictionary and setting up a governance process for changes made to common objects. A data dictionary is a document that defines the metadata, structure, and relationship of each object and field in Salesforce. A governance process is a set of rules and procedures that govern how changes are proposed, reviewed, approved, and deployed in Salesforce. These measures will help NTO to maintain consistency, quality, and clarity of their data model and avoid confusion and errors among users. Option A is incorrect because adding description fields to explain why the field is used, and marking the field as required will not prevent unauthorized or unnecessary changes to Salesforce. Option C is incorrect because creating reports to identify which users are leaving blank, and using external data sources to augment the missing data will not address the root cause of the issue, which is the lack of governance in making changes to Salesforce. Option D is incorrect because creating validation rules with error messages to explain why the fields are used will not stop users from seeing new fields on their page that they are unsure of.

• Question 179:

  For a production cutover, a large number of Account records will be loaded into Salesforce from a legacy system. The legacy system does not have enough information to determine the Ownership for these Accounts upon initial load.

  Which two recommended options assign Account ownership to mitigate potential performance problems?

  A. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.
  B. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.
  C. Let the VP of the Sales department, who will report directly to the senior VP, own all the Account records.
  D. Let a "system user" own all the Account records and make this user part of the highest- level role in the Role Hierarchy.
  A. Let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy.
  B. Let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy.

  ---

  Explanation

  The two recommended options to assign Account ownership to mitigate potential performance problems are to let a "system user" own all the Account records without assigning any role to this user in Role Hierarchy, or to let a "system user" own the Account records and assign this user to the lowest-level role in the Role Hierarchy. This is because these options would reduce the number of sharing calculations and rules that need to be applied to the Account records, and improve the performance and scalability of the system34. The other options are not recommended, as they would increase the sharing complexity and overhead, and potentially expose sensitive data to unauthorized users.

• Question 180:

  Universal Containers (UC) has users complaining about reports timing out or simply taking too long to run What two actions should the data architect recommend to improve the reporting experience? Choose 2 answers

  A. Index key fields used in report criteria.
  B. Enable Divisions for large data objects.
  C. Create one skinny table per report.
  D. Share each report with fewer users.
  A. Index key fields used in report criteria.
  C. Create one skinny table per report.

  ---

  Explanation

  Indexing key fields used in report criteria can speed up the query execution and reduce the report run time. Indexes can be created by Salesforce automatically or manually by request. Creating one skinny table per report can also improve the reporting performance by storing frequently used fields in a separate table that does not include complex formulas or joins.