Plat-Arch-201 시험 - Salesforce실제시험문제와 답 - 257문항

Question No : 1

Universal Containers would like to have a Service-Level Agreement (SLA) of 1 day for any data loss due to unintentional or malicious updates of records in Salesforce.
What approach should be suggested to address this requirement?

A.Build a daily extract job and extract data to on-premise systems for long-term backup and archival purposes.
B.Schedule a Weekly Extract Service for key objects and extract data in XL sheets to on-premise systems.
C.Store all data in shadow custom objects on any updates and deletes, and extract them as needed.
D.Evaluate a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes.

정답:
Explanation:
Evaluating a third-party AppExchange app, such as OwnBackup or Spanning, etc., for backup and archival purposes is the best approach to address the requirement of having a one-day SLA for any data loss. These apps can provide automated backups, granular restores, and compliance features that can help UC recover from any data loss or corruption scenarios.

Question No : 2

UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items.
What two steps can you take to help correct this? Choose two answers.

A.Export in multiple batches
B.Export Bulk API in parallel mode
C.Use PK Chunking
D.Limit Batch to 10K records

정답:
Explanation:
Exporting in multiple batches and using PK Chunking are two steps that can help correct the issues with exporting large volumes of Order records using Informatica Cloud Loader. Exporting in multiple batches can reduce the load on the system and avoid timeouts or errors. Using PK Chunking can split a large data set into smaller chunks based on the record IDs and enable parallel processing of each chunk.

Question No : 3

Universal Containers (UC) wants to store product data in Salesforce, but the standard Product object does not support the more complex hierarchical structure which is currently being used in the product master system.
How can UC modify the standard Product object model to support a hierarchical data structure in order to synchronize product data from the source system to Salesforce?

A.Create a custom lookup filed on the standard Product to reference the child record in the hierarchy.
B.Create a custom lookup field on the standard Product to reference the parent record in the hierarchy.
C.Create a custom master-detail field on the standard Product to reference the child record in the hierarchy.
D.Create an Apex trigger to synchronize the Product Family standard picklist field on the Product object.

정답:
Explanation:
Creating a custom lookup field on the standard Product to reference the parent record in the hierarchy is the correct way to modify the standard Product object model to support a hierarchical data structure. This allows UC to create a self-relationship on the Product object and define parent-child relationships among products.

Question No : 4

Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)

A.Using leading % wildcards.
B.Using trailing % wildcards.
C.Performing large loads and deletions.
D.Using NOT and != operators.
E.Using a custom index on a deterministic formula field.

정답:
Explanation:
Using leading % wildcards, performing large loads and deletions, and using NOT and != operators are three options that prevent a query from being selective. These options can cause the query to scan a large number of records or indexes, which can negatively impact the performance and scalability of the query5. Using a custom index on a deterministic formula field, on the other hand, can improve the query selectivity by allowing the query to use the index instead of scanning all the records6.

Question No : 5

Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As part of their implementation, they are planning to create a new custom object (Shipments), which will have a lookup relationship to Opportunities. When creating shipment records, Salesforce users need to manually input a customer reference, which is provided by customers, and will be stored in the Customer_Reference__c text custom field. Support agents will likely use this customer reference to search for Shipment records when resolving shipping issues. UC is expecting to have around 5 million shipment records created per year.
What is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records?

A.Implement an archiving process for shipment records created after five years.
B.Implement an archiving process for shipment records created after three years.
C.Set Customer-Reference_c as an External ID (non-unique).
D.Set Customer-Reference_c as an External ID (unique).

정답:
Explanation:
Setting Customer-Reference_c as an External ID (unique) is the recommended solution to ensure that support agents using global search and reports can quickly find shipment records. This is because external ID fields are indexed and can be used as filters in reports and list views4. Making the field unique also ensures that there are no duplicate values that could confuse the search results.

Question No : 6

Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted.
What statement is true with respect to a data archiving strategy for UC?

A.UC can store long-term lead records in custom storage objects to avoid counting against storage limits.
B.UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
C.UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
D.UC can leverage a “tier”-based approach to classify the record storage need.

정답:
Explanation:
Leveraging a “tier”-based approach to classify the record storage need is a true statement with respect to a data archiving strategy for UC. This approach involves defining different tiers of data based on their usage, value, and retention policies, and then applying appropriate storage and archiving solutions for each tier.

Question No : 7

Universal Containers (UC) maintains a collection of several million Account records that represent business in the United Sates. As a logistics company, this list is one of the most valuable and important components of UC's business, and the accuracy of shipping addresses is paramount. Recently it has been noticed that too many of the addresses of these businesses are inaccurate, or the businesses don't exist.
Which two scalable strategies should UC consider to improve the quality of their Account addresses?

A.Contact each business on the list and ask them to review and update their address information.
B.Build a team of employees that validate Accounts by searching the web and making phone calls.
C.Integrate with a third-party database or services for address validation and enrichment.
D.Leverage Data.com Clean to clean up Account address fields with the D&B database.

정답:
Explanation:
Integrating with a third-party database or service for address validation and enrichment is a scalable strategy that can improve the quality of the Account addresses by comparing them with a reliable source of data1. Leveraging Data.com Clean to clean up Account address fields with the D&B database is another scalable strategy that can automatically update and enrich Account records with verified information from Data.com2.

Question No : 8

Which two best practices should be followed when using SOSL for searching?

A.Use searches against single Objects for greater speed and accuracy.
B.Keep searches specific and avoid wildcards where possible.
C.Use SOSL option to ignore custom indexes as search fields are pre-indexed.
D.Use Find in “ALL FIELDS” for faster searches.

정답:
Explanation:
The two best practices that should be followed when using SOSL for searching are: Keep searches specific and avoid wildcards where possible. Use Find in “ALL FIELDS” for faster searches. These best practices are helpful because they optimize the search performance and relevance.
For example, keeping searches specific and avoiding wildcards where possible can reduce the number of results returned and improve the search accuracy. Using Find in “ALL FIELDS” for faster searches can leverage Salesforce’s pre-defined indexes on common fields and return results more quickly than specifying individual fields.

Question No : 9

Universal Containers (UC) has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request. UC has opportunity as master and custom line item object as detail in master-detail relationship. UC also has a custom line item object as master and a custom discount request object as detail in another master-detail relationship. UC has a requirement to show all sums of discounts across line items at an opportunity level.
What is the recommended solution to address these requirements?

A.Use roll-up for the line-item-level summary and a trigger for the opportunity amount summary, as only one level roll-up is allowed.
B.Update the master-detail relationships to lookup relationships in order to allow the discount amount to roll up.
C.Remove the master-detail relationships and rely completely on workflow/triggers to summarize the discount amount.
D.Roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level.

정답:
Explanation:
The recommended solution to address the requirements of Universal Containers (UC) is to roll-up discount request amount at the line-item-level and line-item-level summary discount at the opportunity level. This solution would allow UC to show all sums of discounts across line items at an opportunity level using standard roll-up summary fields. Since UC has a multi-level master-detail relationship for opportunities, a custom opportunity line item object, and a custom discount request object, they can use two levels of roll-up summary fields to aggregate the discount amounts from the child objects to the parent objects. For example, they can create a roll-up summary field on the custom line item object to sum up the discount request amounts from the custom discount request object. Then, they can create another roll-up summary field on the opportunity object to sum up the line-item-level summary discounts from the custom line item object.

Question No : 10

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

정답:
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.

Question No : 11

Universal Containers is planning out their archiving and purging plans going forward for their custom objects Topic__c and Comment__c. Several options are being considered, including analytics snapshots, offsite storage, scheduled purges, etc.
Which three questions should be considered when designing an appropriate archiving strategy?

A.How many fields are defined on the custom objects that need to be archived?
B.Which profiles and users currently have access to these custom object records?
C.If reporting is necessary, can the information be aggregated into fewer, summary records?
D.Will the data being archived need to be reported on or accessed in any way in the future?
E.Are there any regulatory restrictions that will influence the archiving and purging plans?

정답:
Explanation:
The three questions that should be considered when designing an appropriate archiving strategy are: If reporting is necessary, can the information be aggregated into fewer, summary records? Will the data being archived need to be reported on or accessed in any way in the future? Are there any regulatory restrictions that will influence the archiving and purging plans? These questions are important because they help determine the scope, frequency, and method of archiving and purging data from Salesforce. For example, if reporting is necessary, then summary records or analytics snapshots can be used to store aggregated data and reduce the number of records that need to be archived1. If the data being archived needs to be accessed in the future, then offsite storage or external objects can be used to retain the data and make it available on demand2. If there are any regulatory restrictions, such as GDPR or HIPAA, then the archiving and purging plans need to comply with them and ensure data security and privacy

Question No : 12

Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container.
What is the recommended solution?

A.Create new custom fields for temperature and humidity in the existing Container custom object, as well as an external ID field that is unique for each container. These custom fields are updated when a new measure is received.
B.Create a new Container Reading custom object, which is created when a new measure is received for a specific container. The Container Reading custom object has a master-detail relationship to the container object.
C.Create a new Lightning Component that displays last humidity and temperature data for a specific container and can also display historical trends obtaining relevant data from UC’s existing data warehouse.
D.Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour.

정답:
Explanation:
The recommended solution for Universal Containers (UC) to implement its new Internet of Things technology is to create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container. Implement an archiving process that runs every hour. This solution would allow UC to store and access current and historical temperature and humidity data for each container on Salesforce, and use reports and dashboards to analyze it. However, since UC expects a large volume of data over time, they should implement an archiving process that moves data off-platform after a certain period of time to avoid hitting the Org data storage limit and maintain optimal performance. The other options are not recommended, as they would either not store the historical data on Salesforce, or create too many custom fields on the Container object that could impact performance and usability.

Question No : 13

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.

정답:
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 No : 14

Universal Containers is integrating a new Opportunity engagement system with Salesforce. According to their Master Data Management strategy, Salesforce is the system of record for Account, Contact, and Opportunity data. However, there does seem to be valuable Opportunity data in the new system that potentially conflicts with what is stored in Salesforce.
What is the recommended course of action to appropriately integrate this new system?

A.The MDM strategy defines Salesforce as the system of record, so Salesforce Opportunity values prevail in all conflicts.
B.A policy should be adopted so that the system whose record was most recently updated should prevail in conflicts.
C.The Opportunity engagement system should become the system of record for Opportunity records.
D.Stakeholders should be brought together to discuss the appropriate data strategy moving forward.

정답:
Explanation:
The recommended course of action to appropriately integrate the new Opportunity engagement system with Salesforce is to bring the stakeholders together to discuss the appropriate data strategy moving forward. This is because there may be valuable data in both systems that need to be reconciled and harmonized, and the Master Data Management (MDM) strategy may need to be revised or updated to accommodate the new system. The other options are not recommended, as they may result in data loss, inconsistency, or duplication

Question No : 15

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.

정답:
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.

Salesforce Plat-Arch-201 시험