NEW QUESTION 1
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.

Answer: ACD

NEW QUESTION 2
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.

Answer: BD

NEW QUESTION 3
Universal Containers wants to develop a dashboard in Salesforce that will allow Sales Managers to do data exploration using their mobile device (i.e., drill down into sales-related data) and have the possibility of adding ad-hoc filters while on the move. What is a recommended solution for building data exploration dashboards in Salesforce?

• A. Create a Dashboard in an external reporting tool, export data to the tool, and add link to the dashboard in Salesforce.
• B. Create a Dashboard in an external reporting tool, export data to the tool, and embed the dashboard in Salesforce using the Canval toolkit.
• C. Create a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
• D. Create a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lenses and drill down.

Answer: D

NEW QUESTION 4
Universal Containers (UC) has several custom Visualforce applications have been developed in which users are able to edit Opportunity records. UC struggles with data completeness on their Opportunity records and has decided to make certain fields required that have not been in the past. The newly required fields are dependent on the Stage of the Opportunity, such that certain fields are only required once an Opportunity advances to later stages. There are two fields. What is the simplest approach to handle this new requirement?

• A. Update the Opportunity page layout to mark these fields as required.
• B. Use a validation rule for each field that takes the Stage into consideration.
• C. Update these Opportunity field definitions in Setup to be required.
• D. Write an Apex trigger that checks each field when records are saved.

Answer: B

NEW QUESTION 5
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.

Answer: ADE

NEW QUESTION 6
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

Answer: B

NEW QUESTION 7
NTO (Northern Trail Outlets) has a complex Salesforce org which has been developed over past 5 years. Internal users are complaining abt multiple data issues, including incomplete and duplicate data in the org. NTO has decided to engage a data architect to analyze and define data quality standards.
Which 3 key factors should a data architect consider while defining data quality standards? Choose 3 answers:

• A. Define data duplication standards and rules
• B. Define key fields in staging database for data cleansing
• C. Measure data timeliness and consistency
• D. Finalize an extract transform load (ETL) tool for data migration
• E. Measure data completeness and accuracy

Answer: ACE

NEW QUESTION 8
The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.
What is one reporting option Get Cloudy Consulting should consider?

• A. Case SLA performance report
• B. Sales KPI Dashboard
• C. Opportunity analytic snapshot
• D. Lead conversion rate report

Answer: B

NEW QUESTION 9
A large insurance provider is looking to implement Salesforce. The following exist.
* 1. Multiple channel for lead acquisition
* 2. Duplication leads across channels
* 3. Poor customer experience and higher costs
On analysis, it found that there are duplicate leads that are resulting to mitigate the issues?

• A. Build process is manually search and merge duplicates.
• B. Standard lead information across all channels.
• C. Build a custom solution to identify and merge duplicate leads.
• D. Implement third-party solution to clean and event lead data.
• E. Implement de-duplication strategy to prevent duplicate leads

Answer: BDE

NEW QUESTION 10
Which two aspects of data does an Enterprise data governance program aim to improve?

• A. Data integrity
• B. Data distribution
• C. Data usability
• D. Data modeling

Answer: AC

NEW QUESTION 11
Universal Containers (UC) owns a complex Salesforce org with many Apex classes, triggers, and automated processes that will modify records if available. UC has identified that, in its current development state, UC runs change of encountering race condition on the same record.
What should a data architect recommend to guarantee that records are not being updated at the same time?

• A. Embed the keywords FOR UPDATE after SOQL statements.
• B. Disable classes or triggers that have the potential to obtain the same record.
• C. Migrate programmatic logic to processes and flows.
• D. Refactor or optimize classes and trigger for maximum CPU performance.

Answer: A

NEW QUESTION 12
Universal Containers has more than 10 million records in the Order_c object. The query has timed out when running a bulk query. What should be considered to resolve query timeout?

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

Answer: B

NEW QUESTION 13
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 solution should a data architect recommend to mitigate data quality issues?

• A. Leverage picklist and lookup fields where possible
• B. Leverage Apex to validate the format of data being entered via a mobile device.
• C. Leverage validation rules and workflows.
• D. Leverage third-party- AppExchange tools

Answer: AC

NEW QUESTION 14
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 containe
• B. These custom fields are updated when a new measure is received.
• C. Create a new Container Reading custom object, which is created when a new measure is received for a specific containe
• D. The Container Reading custom object has a master-detail relationship to the container object.
• E. 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.
• F. 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 containe
• G. Implement an archiving process that runs every hour.

Answer: D

NEW QUESTION 15
North Trail Outfitters (NTD) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement?

• A. Standard reports and dashboards
• B. Async SOQL with a custom object
• C. Standard SOQL queries
• D. Einstein Analytics

Answer: BD

NEW QUESTION 16
How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?

• A. Remove "customize application" permissions from everyone else.
• B. Export the metadata and search it for the fields in question.
• C. Create a field history report for the fields in question.
• D. Export the setup audit trail and find the fields in question.

Answer: D

NEW QUESTION 17
UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.
Which 2 solutions should a data architect recommend to monitor and measure data quality? Choose 2 answers.

• A. Use custom objects and fields to identify issues.
• B. Review data quality reports and dashboards.
• C. Install and run data quality analysis dashboard app
• D. Export data and check for data completeness outside of Salesforce.

Answer: BC

NEW QUESTION 18
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.

Answer: D

NEW QUESTION 19
......