Copy and Edit

AMB1-2

Description

AMB1 Quiz on AMB1-2, created by Amir BOUTITI on 30/03/2020.
Amir BOUTITI
Quiz by Amir BOUTITI, updated more than 1 year ago
Amir BOUTITI
Created by Amir BOUTITI almost 6 years ago
53
0
0

Resource summary

Question 1

Question
A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before importing related order line items. What is the recommended solution?
Answer
  • Leverage Batch Apex to update order ID on related order lines after import.
  • Leverage an External ID from source system orders to import related order lines.
  • Query only indexed ID field values on the imported order to import related order lines.
  • Leverage a sequence of numbers on the imported orders to import related order lines.

Question 2

Question
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?
Answer
  • Use Salesforce Object Query Language.
  • Use the Salesforce Metadata API.
  • Use a data definition language.
  • Use an entity relationship diagram.

Question 3

Question
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?
Answer
  • 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.
  • 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.
  • 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.
  • 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.

Question 4

Question
A customer wishes to migrate 700,000 Account records in a single migration into Salesforce. What is the recommended solution to migrate these records while minimizing migration time?
Answer
  • Use Salesforce Bulk API in parallel mode.
  • Use Salesforce Soap API in parallel mode.
  • Use Salesforce Bulk API in serial mode.
  • Use Salesforce Soap API in serial mode.

Question 5

Question
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?
Answer
  • Refresh the full copy sandbox and re-run the data migration test.
  • Truncate all 5 objects quickly and re-run the data migration test.
  • Hard delete all 5 objects’ data and re-run the data migration test.
  • Truncate all 5 objects and hard delete before running the migration test.

Question 6

Question
Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system. Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?
Answer
  • Use Data.com Clean
  • Use an Enterprise Service Bus.
  • Use a data warehouse.
  • Use Duplicate Management.

Question 7

Question
Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?
Answer
  • Use the Account object with Person Accounts and a new B2C page layout.
  • Use the Account object with a newly created Record Type for B2C customers.
  • Create a new picklist value for B2C customers on the Account Type field.
  • Use 50 umbrella Accounts for each region, with customers as associated Contacts.

Question 8

Question
Universal Containers has received complaints that customers are being called by multiple Sales Reps where the second Sales Rep that calls is unaware of the previous call by their coworker. What is a data quality problem that could cause this?
Answer
  • Duplicate Contact records exist in the system.
  • Duplicate Activity records on a Contact.
  • Missing phone number on the Contact record.
  • Customer phone number has changed on the Contact record.

Question 9

Question
Which three characteristics of a Skinny table help improve report and query performance?
Answer
  • Skinny tables provide a view across multiple objects for easy access to combined data.
  • Skinny tables can be used to create custom indexes on multi-select picklist fields.
  • 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.

Question 10

Question
Universal Containers (UC) wants to assess the completeness and consistency of contact information in Salesforce. They are finding that their sales reps in many caes do not have enough information about their accounts and contacts. Also, in many cases they are not able to interpret the information in a consistent manner. They have identified certain “key” fields which are important to their sales reps. Which two steps can UC implement to assess their data for completeness and consistency?
Answer
  • Run one report per key field, grouped by that field, to understand its data variability.
  • Run a report that shows the percentage of blanks for the important fields.
  • Run a report which shows the last time the key fields were updated.
  • Run a process that can fill in default values for blank fields.

Question 11

Question
Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?
Answer
  • Use an indexed data field with bounded data filters.
  • Use Formula fields to surface information I related entities on the report.
  • Use unbounded date ranges to filter the report.
  • Use triggers to populate denormalized related fields on the Account.

Question 12

Question
Which two best practices should be followed when using SOSL for searching?
Answer
  • Keep searches specific and avoid wildcards where possible.
  • Use searches against single Objects for greater speed and accuracy.
  • Use Find in “ALL FIELDS” for faster searches.
  • Use SOSL option to ignore custom indexes as search fields are pre-indexed.

Question 13

Question
Universal Containers (UC) is launching an RFP to acquire a new accounting product available on AppExchange. UC is expecting to issue 5 million invoices per year, with each invoice containing an average of 10 line items. What should UC’s Data Architect recommend to ensure scalability?
Answer
  • Ensure the account product vendor includes Wave Analytics in their offering.
  • Ensure the account product vendor provides a sound data archiving strategy.
  • Ensure invoice line items simply reference existing Opportunity line items.
  • Ensure the accounting product runs 100% natively on the Salesforce platform.

Question 14

Question
Which three options can prevent your SOQL queries from being selective?
Answer
  • Using trailing % wildcards.
  • Using a custom index on a deterministic formula field.
  • Using leading % wildcards.
  • Using NOT and != operators.
  • Performing large loads and deletions.

Question 15

Question
Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they’ve purchased UC’s new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC’s new support service every month over the next five years. What is the recommended solution to ensure long-term performance, bearing in mind the above requirements?
Answer
  • Implement a new Categories custom object and create a lookup field from Account to Category.
  • Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
  • Implement a new Categories custom object and a master-detail relationship from Account to Category.
  • Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.

Question 16

Question
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?
Answer
  • Define a data taxonomy for product data and apply the taxonomy to the product data in the data warehouse.
  • Build Apex Triggers in Salesforce that ensure products have the correct names and labels after data is loaded into salesforce.
  • Change integration to let product master systems update product data directly in Salesforce via the Salesforce API.
  • Add custom fields to the Product standard object in Salesforce to store data from the different source systems.

Question 17

Question
Universal Containers (UC) is planning to launch its Customer Community. The community will allow user to register shipment requests which are then processed by UC employees. Shipment requests contain header information, and then a list of no more than 5 items being shipped. UC will initially roll out its community to 5,000 customers in Europe, and will ultimately roll out to 20,000 customers worldwide within the next two years. UC expects an average of 10 shipment requests per week per customer. UC wants customers to be able to view up to three years of shipment requests and use Saleforce reports. What is the recommended solution for UC’s Data Architect to address the requirements?
Answer
  • Create an external custom object to track shipment requests and a child external object to track shipment items. External objects are stored off-platform in Heroku’s Postgres database.
  • Create a custom object to track shipment requests with five lookup custom fields for each item being shipped Implement an archiving process that moves data off-platform after three years.
  • Create a custom object to track shipment requests and a child custom object to track shipment items. Implement an archiving process that moves data off-platform after three years.
  • Create an external custom object to track shipment requests with five lookup custom fields for each item being shipped. External objects are stored off-platform in Heroku’s Postgres database.

Question 18

Question
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?
Answer
  • Implement an archiving process for shipment records created after three years.
  • Set Customer-Reference_c as an External ID (unique).
  • Set Customer-Reference_c as an External ID (non-unique).
  • Implement an archiving process for shipment records created after five years.

Question 19

Question
Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?
Answer
  • Modify the export job header to specify Sforce-Enable-PKChunking.
  • Modify the export query that includes standard index fields(s).
  • Modify the export query with LIMIT clause with Batch size 10,000.
  • Modify the export job header to specify Export-in-Parallel.

Question 20

Question
Universal Containers (UC) has an Application custom object, which has tens of millions of records created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce at all times for reporting and queries. UC is currently encountering performance issues when reporting and running queries on this Object using date ranges as filters. Which two options can be used to improve report performance?
Answer
  • Add custom indexes to all fields on Application without a standard index.
  • Add custom indexes to the Date fields used for filtering the report.
  • Ask support to create a skinny table for Application with the necessary reporting fields.
  • Run multiple reports to get different pieces of the data and combine them.
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Browse Library