Universal Containers (UC) has lead assignment rules to assign leads to owners. Leads not routed by assignment rules are assigned to a dummy user. Sales rep are complaining of high load times and issues with accessing leads assigned to the dummy user.
What should a data architect recommend to solve these performance issues?
A. Assign dummy user last role in role hierarchy B. Create multiple dummy user and assign leads to them C. Assign dummy user to highest role in role hierarchy D. Periodically delete leads to reduce number of leads
B. Create multiple dummy user and assign leads to them
Explanation
According to the official Salesforce guide1, assigning leads to a single dummy user can cause performance issues and data skew, especially if the dummy user owns more than 10,000 records. Data skew occurs when a single user or a small number of users own a disproportionately large number of records, which can affect query performance and sharing calculations. Option B is the correct answer because it suggests creating multiple dummy users and assigning leads to them, which can distribute the load and reduce data skew. Option A is incorrect because assigning the dummy user to the last role in the role hierarchy does not affect the performance or data skew issues. Option C is incorrect because assigning the dummy user to the highest role in the role hierarchy can worsen the performance and data skew issues, as it will grant access to more users and records. Option D is incorrect because periodically deleting leads can cause data loss and does not address the root cause of the problem.
Question 142:
Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org?
Choose 3 answers
A. Use hard delete in Bulk API to permanently delete records from Salesforce. B. Use hard delete in batch Apex to permanently delete records from Salesforce. C. Identify records in objects that have not been modified or used In last 3 years. D. Use Rest API to permanently delete records from the Salesforce org. E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
A. Use hard delete in Bulk API to permanently delete records from Salesforce. C. Identify records in objects that have not been modified or used In last 3 years. E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
Explanation
Using hard delete in Bulk API, identifying records that have not been modified or used in last 3 years, and archiving the records in EDW before deleting from Salesforce are all good recommendations to reduce the number of records from the org1. Using hard delete in batch Apex or Rest API may not be as efficient or scalable as Bulk API
Question 143:
Universal Containers has a public website with several forms that create Lead records in Salesforce using the REST API.
When designing these forms, which two techniques will help maintain a high level of data quality?
A. Do client-side validation of phone number and email field formats. B. Prefer picklist form fields over free text fields, where possible. C. Ensure the website visitor is browsing using an HTTPS connection. D. Use cookies to track when visitors submit multiple forms.
A. Do client-side validation of phone number and email field formats. B. Prefer picklist form fields over free text fields, where possible.
Explanation
Doing client-side validation of phone number and email field formats and preferring picklist form fields over free text fields, where possible, are two techniques that will help maintain a high level of data quality when designing forms that create Lead records in Salesforce using the REST API. Client-side validation can ensure that the input data is in the correct format and prevent errors or invalid values from being submitted. Picklist form fields can provide a predefined set of values for the users to choose from and avoid typos or inconsistencies in the data.
Question 144:
Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?
A. Define external IDs for an object, migrate second database to first database, and load into Salesforce. B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases. C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce. D. Define external IDs for an object, Insert data from one database, and use upsert for a second database
C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
Explanation
To recommend a clean migration, the data architect should set up a staging database, and define external IDs to merge, clean duplicate data, and load into Salesforce. This will allow the data architect to consolidate and deduplicate the data from two legacy systems before importing it into Salesforce using external IDs as unique identifiers. Option A is incorrect because defining external IDs for an object, migrating second database to first database, and loading into Salesforce will not ensure that the data is clean and duplicate-free. Option B is incorrect because defining duplicate rules in Salesforce, and loading data into Salesforce from both databases will not prevent the duplicate data from being imported into Salesforce. Option D is incorrect because defining external IDs for an object, inserting data from one database, and using upsert for a second database will not handle the duplicate data from both databases.
Question 145:
Universal Containers (UC) requires 2 years of customer related cases to be available on SF for operational reporting. Any cases older than 2 years and upto 7 years need to be available on demand to the Service agents. UC creates 5 million cases per yr.
Which 2 data archiving strategies should a data architect recommend? Choose 2 options:
A. Use custom objects for cases older than 2 years and use nightly batch to move them. B. Sync cases older than 2 years to an external database, and provide access to Service agents to the database C. Use Big objects for cases older than 2 years, and use nightly batch to move them. D. Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.
C. Use Big objects for cases older than 2 years, and use nightly batch to move them. D. Use Heroku and external objects to display cases older than 2 years and bulk API to hard delete from Salesforce.
Explanation
The best data archiving strategies for UC are to use Big objects and Heroku with external objects. Big objects allow storing large amounts of data on the Salesforce platform without affecting performance or storage limits. They also support point-and-click tools, triggers, and Apex code. Heroku is a cloud platform that can host external databases and integrate with Salesforce using external objects. External objects enable on-demand access to external data sources via standard Salesforce APIs and user interfaces. Using bulk API to hard delete cases from Salesforce will free up storage space and improve performance.
Question 146:
Northern Trail Outfitters has these simple requirements for a data export process:
File format should be in CSV.
Process should be scheduled and run once per week.
The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?
A. Bulk API B. Data export wizard C. Third-party ETL tool D. Data loader
B. Data export wizard
Explanation
The correct answer is B, data export wizard. The data export wizard is a tool that allows you to export your data in CSV format, schedule the export process to run once per week, and configure the export settings through the Salesforce UI.
The data export wizard can handle up to 51 million records per export. The bulk API, third-party ETL tools, and data loader are also tools that can export data, but they are not as simple or user- friendly as the data export wizard.
Question 147:
Universal Containers (UC) is a major supplier of office supplies. Some products are produced by UC and some by other manufacturers. Recently, a number of customers have complained that product descriptions on the invoices do not match the descriptions in the online catalog and on some of the order confirmations (e.g., "ballpoint pen" in the catalog and "pen" on the invoice, and item color labels are inconsistent: "what vs. "White" or "blk" vs. "Black"). All product data is consolidated in the company data warehouse and pushed to Salesforce to generate quotes and invoices. The online catalog and webshop is a Salesforce Customer Community solution.
What is a correct technique UC should use to solve the data inconsistency?
A. Change integration to let product master systems update product data directly in Salesforce via the Salesforce API. B. Add custom fields to the Product standard object in Salesforce to store data from the different source systems. C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse. D. Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.
C. Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.
Explanation
A correct technique UC should use to solve the data inconsistency is to define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse. A data taxonomy is a hierarchical classification of data entities and attributes that defines their meaning, format, and relationships. A data taxonomy can help ensure consistency, accuracy, and completeness of product data across different systems and channels
Question 148:
UC developers have created a new lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.
What tool should a data architect use to identify why the query is taking too long?
A. Use Splunk to query the system logs looking for transaction time and CPU usage. B. Enable and use the query plan tool in the developer console. C. Use salesforce's query optimizer to analyze the query in the developer console. D. Open a ticket with salesforce support to retrieve transaction logs to e analyzed for processing time.
B. Enable and use the query plan tool in the developer console.
Explanation
According to the Salesforce documentation1, the query plan tool is a tool that can be enabled and used in the developer console to analyze the performance of a SOQL query. The query plan tool shows the cost, cardinality, sObject type, and relative cost of each query plan that Salesforce considers for a query. The relative cost indicates how expensive a query plan is compared to the Force.com query optimizer threshold. A query plan with a relative cost above 1.0 is likely to cause a time-out error. To identify why the query is taking too long, a data architect should use the query plan tool in the developer console (option B). This way, the data architect can see which query plan is chosen by Salesforce and how it affects the performance of the query. The data architect can also use the query plan tool to optimize the query by adding indexes, filters, or limits to reduce the cost and improve the efficiency of the query. Using Splunk to query the system logs looking for transaction time and CPU usage (option A) is not a good solution, as it can be complex, costly, and difficult to integrate with Salesforce. It may also not provide enough information or insights to identify and optimize the query performance. Using Salesforce's query optimizer to analyze the query in the developer console (option C) is also not a good solution, as it is not a separate tool that can be used in the developer console. The query optimizer is a feature that runs automatically when a SOQL query is executed and chooses the best query plan based on various factors2. Opening a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time (option D) is also not a good solution, as it can be time- consuming, dependent, and inefficient. It may also not provide enough information or insights to identify and optimize the query performance.
Question 149:
A casino is implementing salesforce and is planning to build a customer 360 view for a customer who visits its resorts. The casino currently maintained the following systems that records customer activity:
1.Point of sales system: All purchases for a customer. 2.Salesforce: All customer service activity and sales activity for a customer. 3.Mobile app: All bookings, preferences and browser activity for a customer. 4.Marketing: All email, SMS and social campaigns for a customer.
Customer service agents using salesforce would like to view the activities from all system to provide supports to customers. The information has to be current and real time.
What strategy should the data architect implement to satisfy this requirement?
A. Explore external data sources in salesforce to build 360 view of customer. B. Use a customer data mart to view the 360 view of customer. C. Migrate customer activities from all 4 systems into salesforce. D. Periodically upload summary information in salesforce to build 360 view.
A. Explore external data sources in salesforce to build 360 view of customer.
Explanation
Exploring external data sources in Salesforce to build 360 view of customer is the best strategy to satisfy the requirement, as it allows real-time access to data from other systems without storing it in Salesforce3. Using a customer data mart may not provide real-time information or may require additional integration efforts. Migrating customer activities from all 4 systems into Salesforce may exceed the storage limits or cause data quality issues. Periodically uploading summary information in Salesforce may not provide current or detailed information.
Question 150:
Northern Trail Outfitters would like to report on the type of customers. A custom field for customer type was created in Account object. Users need to be limited to the following defined choices when entering information in this field:
1. High Value
2. Medium Value
3. Low Value
Which strategy should a data architect recommend to configure customer type?
A. Lookup to a custom object with defined choices. B. Single-select restricted picklist with defined choices. C. Provide help text to guide users with defined choices. D. Create a validation rule to limit entry to defined choices.
B. Single-select restricted picklist with defined choices.
Explanation
single-select restricted picklist with defined choices can be a way to configure customer type. The article states that picklists are fields that allow users to select one or more predefined values from a list, and restricted picklists ensure that users can only select from the defined values. This can help to limit the choices for customer type and ensure data quality.
Nowadays, the certification exams become more and more important and required by more and more
enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare
for the exam in a short time with less efforts? How to get a ideal result and how to find the
most reliable resources? Here on Vcedump.com, you will find all the answers.
Vcedump.com provide not only Salesforce exam questions,
answers and explanations but also complete assistance on your exam preparation and certification
application. If you are confused on your DATA-ARCHITECT exam preparations
and Salesforce certification application, do not hesitate to visit our
Vcedump.com to find your solutions here.