Quiz
Data MNG
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem Quiz (146)
1Universal Containers wants their Shipment custom object to always relate to a Container, a Sender, and a Receiver (all separate custom objects). If a Shipment is currently associated with a Container, Sender, or Receiver, deletion of those records should not be allowed. They also want separate sharing models on each custom object. What approach should an architect take to fulfill these requirements?
- ACreate a required Lookup relationship to each of the three parent records.
- BCreate two Master -Detail and one Lookup relationship to the parent records.
- CCreate a Master -Detail relationship to each of the three parent records.
- DUse a VLOOKUP formula field to associate the Shipment to each parent record.
2Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?
- AAfter the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.
- BCreate a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.
- CEnable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.
- DWrite an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.
3An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers
- AImplement a third -party validation process with translate functionality.
- BCreate a trigger on Contact and add an error to the record with a custom label.
- CCreate a workflow field update to set the standard ErrorMessage field.
- DCreate a validation rule and translate the error message with translation workbench.
4What is an advantage of using Custom metadata type over Custom setting?
- ACustom metadata records are not copied from production to sandbox.
- BCustom metadata types are available for reporting.
- CCustom metadata records are deployable using packages.
- DCustom metadata records are editable in Apex.
5The invoicing system at Universal Containers requires that attachments associated with the Invoice _c custom object be classified by Types (i.e., "Receipt," "Invoice PDF," etc.) so that reporting can be done on invoices showing the number of attachments grouped by Type. What approach should be taken to categorize the attachments to meet these requirements?
- AAdd additional options to the standard ContentType picklist field for the Attachment object.
- BAdd a ContentType picklist field to the Attachment layout and create additional picklist options.
- CCreate a custom picklist field for the Type on the standard Attachment object with the values.
- DCreate a custom object related to the Invoice object with a picklist field for the Type.
6Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
- ALimitations on master -detail relationships.
- BOrg data storage limitations.
- CBulk API limitations on picklist fields.
- DStandard list view in -line editing.
7Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers
- AUse SOQL queries without WHERE conditions.
- BWork with Salesforce Support to enable Skinny Tables
- CReduce the number of triggers on Order _c object.
- DMake the queries more selective using indexed fields.
8Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?
- ACreate a picklist field, values sorted alphabetically.
- BCreate a Master -Detail to custom object ShippingStatus c.
- CCreate a Lookup to custom object ShippingStatus c.
- DCreate a text field and make it an external ID.
9Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers
- ACreate a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
- BWrite an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
- CLII Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
- DCreate a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
10Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?
- ACreate a "before delete" trigger to check if the current user is not the owner.
- BSet the Sharing settings as Public Read Only for the Contact object.
- CSet the profile of the users to remove delete permission from the Contact object.
- DCreate a validation rule on the Contact object to check if the current user is not the owner.
11Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?
- AUse Streaming API to get the current status from the ERP and display on the Opportunity page.
- BCreate an external object Invoice _x with a Lookup relationship with Opportunity.
- CCreate a custom object Invoice _c with a master -detail relationship with Opportunity.
- DCreate a custom object Invoice _c with a Lookup relationship with Opportunity.
12Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers
- ACreate a custom object to store a copy of the record when changed.
- BCreate a custom object to store the previous and new field values.
- CUse Analytic Snapshots to store a copy of the record when changed.
- DSelect the 100 fields in the Opportunity Set History Tracking page.
13In a Salesforce org used to manage Contacts, what two options should be considered to maintain data quality? Choose 2 answers
- AUse the private sharing model.
- BUse Salesforce duplicate management.
- CUse validation rules on new record create and edit.
- DUse workflow to delete duplicate records.
14Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers
- AUse a workflow to check and prevent duplicates.
- BClean data before importing to Salesforce.
- CUse Salesforce matching and duplicate rules.
- DImport the data concurrently.
15Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?
- AUse a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
- BRun a report, find Accounts whose name starts with the same five characters, then merge those Accounts.
- CEnable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
- DMake the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.
16Managers at Universal Containers (UC) have noticed that shipment records (a custom object) are being sent to the shipping department with bad address data Specifically, addresses have missing data like City and poorly formatted Postal codes. Which two approaches will solve this issue? Choose 2 answers
- AEdit each of the page layouts to require that each address field contains data.
- BUse a Validation Rule using CONTAINS to ensure address fields contain data.
- CUse a Validation Rule using REGEX to ensure proper Postal Code formatting.
- DWrite an Apex Trigger to require all of the fields on the page layouts.
17Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers
- AMake use of a third -party tool to help merge duplicate Contacts across Accounts.
- BUse Data.com to standardize Contact address information to help identify duplicates.
- CUse Workflow rules to standardize Contact information to identify and prevent duplicates.
- DMake use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.
18Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?Choose 2 answers
- ASchedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
- BUse Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.
- CSchedule reports that will automatically catch duplicates and merge or delete the records every week.
- DStore all data in an external system and set up an integration to Salesforce for view -only access.
19Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?
- AAllow users to import their data using the Salesforce Import tools.
- BUtilize a 3rd -party solution from the AppExchange for data uploads.
- CUtilize an app from the AppExchange to create data -quality dashboards.
- DUse Apex to validate the format of phone numbers and postal codes.
20which two methods should be used when importing Leads into Salesforce to ensure there are no duplicate records? Choose 2 answers
- ACreate a Workflow Rule to check for duplicate records.
- BPurchase an AppExchange Lead de -duplication application.
- CImplement Salesforce Matching and Duplicate Rules.
- DRun the Salesforce Lead Mass de -duplication tool.
21A customer has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. The customer has noticed that many of the records coming from the external system are missing data in this field. What two things should the architect do to ensure this field always contains data coming from the source system? Choose 2 answers
- ASet up a Validation Rule to prevent blank values.
- BCreate a Workflow to default a value into this field.
- CMark the field required in setup at the field level.
- DBlame the customer's external system for bad data.
22Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?
- AImplement a Master Data Management system to determine system of record.
- BImplement a workflow rule that sends Opportunity data through Outbound Messaging.
- CHave the ERP poll Salesforce nightly and bring in the desired Opportunities.
- DImplement an hourly integration to send Salesforce Opportunities to the ERP system.
23Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?
- AHave Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
- BImplement an integration tool to send OMS Accounts and Contacts to Salesforce.
- CImplement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
- DUse the Streaming API to send Account and Contact data from Salesforce to the OMS.
24An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution? Choose 2 answers
- AWhether the systems are cloud -based or on -premise.
- BWhether or not Salesforce replaced a legacy CRM.
- CWhether the system of record changes for different tables.
- DThe number of systems that are integrating with each other.
25A customer is integrating two different systems with customer records into the Salesforce Account object Master Data Management will be used to ensure that no duplicate records are created in Salesforce. How can the architect determine which system is the system of record on a field level?
- AAny field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.
- BReview the database schema for each external system and any fields with different names should always be separate fields in Salesforce.
- CMaster Data Management systems determine system of record and the architect doesn't have to think about what data is controlled by what system.
- DAny Fields with the same purpose between the two systems should be reviewed by the key stakeholders to see how they will be used in Salesforce.
26In a disparate multi -system ERP environment, where Salesforce is being deployed, what are two techniques that should be used to maintain data synchronization between systems? Choose 2 answers
- ABuild synchronization reports and dashboards.
- BIntegrate Salesforce with the ERP environment.
- CEstablish an MDM strategy to outline a single source of truth.
- DUse workbench to update files within systems.
27All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:• An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.• An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.• A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.How should the architect determine which of these systems is the system of record?
- AAccount and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
- BWhatever system updates the attribute or object should be the system of record for that field or object.
- CWhatever integration data flow runs last will, by default, determine which system is the system of record.
- DData flows should be reviewed with the business users to determine the system of record per object or field.
28What are two valid metadata types that should be included to document the data architecture of a Salesforce org? Choose 2 answers
- ARecordType
- BDocument
- CCustomField
- DSecuritySettings
29What are two key artifacts used to document the data architecture for a multi -system enterprise Salesforce implementation? Choose 2 answers
- AUser stories
- BData model
- CNon-functional requirements
- DIntegration specification
30As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers
- AReview the setup audit trail for configuration changes.
- BPut the business purpose in the Description of each field.
- CMaintain a data dictionary with the justification for each field.
- DUse the Force.com IDE to save the metadata files in source control.
31How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?
- ARemove "customize application" permissions from everyone else.
- BExport the metadata and search it for the fields in question.
- CCreate a field history report for the fields in question.
- DExport the setup audit trail and find the fields in question.
32Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers
- AUse the Force.com Workbench to export the data.
- BSchedule a weekly export file from the Salesforce UI.
- CSchedule jobs to export and delete using an ETL tool.
- DSchedule jobs to export and delete using the Data Loader.
33Which two automated approaches should an architect recommend to purge old data out of Salesforce and aggregate that data in Salesforce? Choose 2 answers
- ASchedulable Batch Apex
- BThird -party Business Intelligence system
- CThird -party Integration Tool (ETL)
- DApex Triggers
34Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?
- AReduce data storage by purging old data.
- BImplement an AppExchange package.
- CReview projected data storage needs.
- DSchedule a weekly export file.
35A Salesforce customer has millions of orders every year. Each order contains, on average, ten line items. The customer wants its Sales Reps to know how much money each customer generates year -over -year, but they are running out of data storage in Salesforce. What data archiving plan should the architect recommend? Choose 1 answer
- AAnnually delete orders and order line items and ensure the customer has order information in another system.
- BAnnually aggregate order amount data to store in a custom object, then delete those orders and order line items.
- CAnnually export and delete orders and order line items and store them in a zip file in case the data is needed later.
- DAnnually export and delete order line items and store them in a zip file in case they data is needed later
36A customer monitors over 10,000 servers and these servers automatically record their status every 15 minutes The customer is required to maintain all of these status reports for a period of 10 years. Service Reps need access to up to one week's worth of these status reports with all of their details. What are two limits an architect should consider when recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce?Choose 2 answers
- AData storage limits
- BAPI Request limits
- CWebservice callout limits
- DWorkflow rule limits
37A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting.What strategy should a data architect use to ensure a better user experience for the Sales Reps?
- ACreate a Permission Set to hide old data from Sales Reps.
- BUse Batch Apex to archive old data on a rolling nightly basis.
- CArchive and purge old data from Salesforce on a monthly basis.
- DSet data access to Private to hide old data from Sales Reps.
38Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers
- AAnalytics/BI Owners
- BData Domain Stewards
- CSalesforce Administrators
- DOperational Data Users
39Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers
- AEngage with IT program managers to assess current velocity of projects in the pipeline.
- BEngage with database administrators to assess current database performance metrics.
- CEngage with executive sponsorship to assess enterprise data strategy and goals.
- DEngage with business units and IT to assess current operational systems and data models.
40A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers
- AReview the metadata xml files for redundant fields to consolidate.
- BDetermine if any integration points create records in Salesforce
- CRun key reports to determine what fields should be required.
- DExport the setup audit trail to review what fields are being used.
- EReview the sharing model to determine impact on duplicate records.
41To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?
- AErrors with duplicate external Id values within the same CSV file.
- BErrors with records being updated and inserted in the same CSV file.
- CErrors when a duplicate Contact name is found cause upsert to fail.
- DErrors with using the wrong external Id will cause the load to fail.
42Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?
- AEnable field history tracking on the Case object.
- BCreate a report on Case analytic snapshots.
- CInstall AppExchange packages for available reports.
- DCreate Contact and Opportunity Reports and Dashboards.
43Universal Containers uses Salesforce to track its sales opportunities The Sales VP would like to better understand key relevant performance figures and help the Sales Managers take corrective actions where appropriate. What reporting option should be considered?
- AOpportunity analytic snapshot
- BCase SLA performance report
- CLead conversion rate report
- DSales KPI Dashboard
44In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?
- ASalesforce allows up to four objects in a single report type.
- BSalesforce does not support Orders or Order Line Items.
- CA report cannot contain data from Accounts and Contacts.
- DCustom report types cannot contain Opportunity data.
45Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers
- ACreate a report in an external system combining Salesforce Account data and Invoice data from the ERP.
- BCreate a report combining data from the Account standard object and the Invoices external object.
- CCreate a Visualforce page combining Salesforce Account data and Invoice external object data.
- DCreate a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.
46Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?
- AUse a Lead standard report and filter on the IsDeleted standard field.
- BUse a Converted Lead report to display data on Leads that have been deleted.
- CQuery Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.
- DSend data to a Data Warehouse and mark Leads as deleted in that system.
47Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers
- AAppExchange Apps
- BWave Analytics
- CWeekly Snapshots
- DSetup Audit Trails
48Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?
- AUse the SOAP API to export data.
- BUtilize the Bulk API to export the data.
- CUse GZIP compression to export the data.
- DSchedule a Batch Apex job to export the data.
49Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?
- ACreate a Custom Object Individual Consumer c to load all individual consumers.
- BLoad all individual consumers as Account records and avoid using the Contact object.
- CLoad one Account record and one Contact record for each individual consumer.
- DCreate one Account and load individual consumers as Contacts linked to that one Account.
50Universal Containers (UC) has a data model as shown in the image.The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?
- ALoad all data using external IDs to link to parent records.
- BUse workflow to calculate summary values instead of Roll -Up.
- CUse triggers to calculate summary values instead of Roll -Up.
- DLoad all data after deferring sharing calculations.
51Universal Containers is migrating their legacy system's users and data to Salesforce. They will be creating 10,000 users,2 million Account records, and 10 million Invoice records. The visibility of these records is controlled by a few dozen owner and criteria -based sharing rules. What are two approaches that will minimize data loading time during this migration to a new organization? Choose 2 answers
- ACreate the users, upload all data, and then deploy the sharing rules.
- BContact Salesforce to activate indexing before uploading the data.
- CFirst, load all account records, and then load all user records.
- DDefer sharing calculations until the data has finished uploading.
52Universal Containers wishes to send data from Salesforce to an external system to generate invoices from their Order Management System (OMS). They want a Salesforce administrator to be able to customize which fields be sent to the external system without modifying code. What two approaches should an architect recommend to deliver the desired solution? Choose 2 answers
- AA set to determine which fields to send in an HTTP callout.
- BAn Outbound Message to determine which fields to send to the OMS.
- CA Field Set that determines which fields to send in an HTTP callout.
- DEnable the field -level security permissions for the fields to send.
53The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers
- AReview the time zones of the User loading the data.
- BRemove custom indexes on the data being loaded.
- CDetermine if the legacy system is still in use.
- DDefer sharing calculations of the Salesforce Org.
- EDeactivate approval processes and workflow rules.
54Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?
- ALoad Contact records together using the Streaming API via the Upsert operation.
- BDelete all existing records, and then load all records together via the Insert operation.
- CLoad all records via the Upsert operation to determine new records vs. existing records.
- DLoad new records via the Insert operation and existing records via the Update operation.
55An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?
- ACreate indexes on Opportunity object text fields.
- BGroup batches by the AccountId field.
- CSort batches by Name field values.
- DOrder batches by Auto -number field.
56Universal 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?
- ATooling API
- BPK Chunking
- CMetadata API
- DStreaming API
57Global Containers (GC) just acquired Universal Containers (UC). Both companies use Salesforce. and as part of the acquisition, all of the data for the UC Salesforce instance (source) must be migrated into the GC Salesforce instance (target). Universal Containers has over 5 million Case records. What should the architect consider when trying to optimize the data load time?
- AUse the Salesforce Org Migration Tool from the Setup Data Management menu.
- BPre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.
- CLoad Case data directly leveraging Salesforce-to-Salesforce functionality.
- DBreak the load into multiple sets of data to be loaded using Bulk API parallel processes.
58universal 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
- AIndex key fields used in report criteria
- BEnable Divisions for large data objects.
- CCreate one skinny table per report.
- DShare each report with fewer users.
59Universal Containers (UC) has over 10 million records. They have a nightly integration that queries these records The queries are timing out What should the data architect do or look for when troubleshooting the queries? Choose 2 answers
- AChange the integration users' profile to have View All Data.
- BEnsure the query doesn't contain NULL in any filter criteria.
- CCreate custom indexes on the fields used in the filter criteria.
- DCreate a formula field instead of having multiple filter criteria.
60Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project? Choose 2 answers
- APre -go -live automated page -load testing against the Salesforce Full sandbox.
- BPost go -live automated page -load testing against the Salesforce Production org.
- CPre -go -live unit testing in the Salesforce Full sandbox.
- DStress testing against the web services hosted by the integration middleware.
61Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -partyERP system. They have connected the Invoice data through a Salesforce external object. Theywant data from both Accounts and Invoices visible in one report in one place. What twoapproaches should an architect suggest for achieving this solution? Choose 2 answers
- ACreate a report in an external system combining Salesforce Account data and Invoice datafrom the ERP.
- BCreate a report combining data from the Account standard object and the Invoices externalobject.
- CCreate a Visualforce page combining Salesforce Account data and Invoice external objectdata.
- DCreate a separate Salesforce report for Accounts and Invoices and combine them in adashboard.
62Universal Containers (UC) wants to capture information on how data entities are stored withinthe different applications and systems used within the company. For that purpose, thearchitecture team decided to create a data dictionary covering the main business domainswithin U
C. Which two common techniques are used building a data dictionary to storeinformation on how business entities are defined?- AUse Salesforce Object Query Language.
- BUse a data definition language
- CUse an entity relationship diagram.
- DUse the Salesforce Metadata API.
63Universal Containers is planning out their archiving and purging plans going forward for theircustom objects Topic__c and Comment__c. Several options are being considered, includinganalytics snapshots, offsite storage, scheduled purges, etc. Which three questions should beconsidered when designing an appropriate archiving strategy?
- AHow many fields are defined on the custom objects that need to be archived?
- BWhich profiles and users currently have access to these custom object records?
- CIf reporting is necessary, can the information be aggregated into fewer, summary records?
- DWil the data being archived need to be reported on or accessed in any way in the future?
- EAre there any regulatory restrictions that wil influence the archiving and purging plans?
64Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. Theyhave noticed similar, but not identical. Account names and addresses. What should UC do toensure proper data quality?
- AUse a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
- BRun a report, find Accounts whose name starts with the same five characters, then mergethose Accounts.
- CEnable Account de -duplication by creating matching rules in Salesforce, which wil massmerge duplicate Accounts.
- DMake the Account Owner clean their Accounts' addresses, then merge Accounts with thesame address.
65What are two valid metadata types that should be included to document the data architecture ofa Salesforce org? Choose 2 answers
- ARecordType
- BDocument
- CCustomField
- DSecuritySettings
66Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during theexport process?
- AUse the SOAP API to export data.
- BUtilize the Bulk API to export the data.
- CUse GZIP compression to export the data.
- DSchedule a Batch Apex job to export the data.
67Universal Containers (UC) is implementing Salesforce Sales Cloud and Service Cloud. As partof their implementation, they are planning to create a new custom object (Shipments), which willhave a lookup relationship to Opportunities. When creating shipment records, Salesforce usersneed to manualy input a customer reference, which is provided by customers, and wil bestored in the Customer_Reference__c text custom field. Support agents wil likely use thiscustomer reference to search for Shipment records when resolving shipping issues. UC isexpecting to have around 5 mil ion shipment records created per year. What is therecommended solution to ensure that support agents using global search and reports canquickly find shipment records?
- AImplement an archiving process for shipment records created after five years.
- BImplement an archiving process for shipment records created after three years.
- CSet Customer-Reference_c as an External ID (non-unique).
- DSet Customer-Reference_c as an External ID (unique).
68Universal Containers has received complaints that customers are being called by multiple SalesReps 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?
- AMissing phone number on the Contact record.
- BCustomer phone number has changed on the Contact record
- CDuplicate Contact records exist in the system.
- DDuplicate Activity records on a Contact.
69Universal Containers is migrating their legacy system's users and data to Salesforce. They willbe creating 10,000 users,2 mil ion Account records, and 10 mil ion Invoice records. The visibilityof these records is controlled by a few dozen owner and criteria -based sharing rules. What aretwo approaches that will minimize data loading time during this migration to a new organization?Choose 2 answers
- ACreate the users, upload all data, and then deploy the sharing rules.
- BContact Salesforce to activate indexing before uploading the data.
- CFirst, load all account records, and then load all user records.
- DDefer sharing calculations until the data has finished uploading.
70To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contactrecords into Salesforce. What common error should the data architect be aware of when usingupsert?
- AErrors with duplicate external Id values within the same CSV file.
- BErrors with records being updated and inserted in the same CSV file.
- CErrors when a duplicate Contact name is found cause upsert to fail.
- DErrors with using the wrong external Id will cause the load to fail.
71Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historical y, they have only used 20 Venues. Which two things should the data architect consider when de-normalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
- AStandard list view in-line editing.
- BLimitations on master -detail relationships.
- COrg data storage limitations.
- DBulk API limitations on picklist fields.
72Which two best practices should be followed when using SOSL for searching?
- AUse searches against single Objects for greater speed and accuracy.
- BKeep searches specific and avoid wildcards where possible.
- CUse SOSL option to ignore custom indexes as search fields are pre-indexed.
- DUse Find in "ALL FIELDS" for faster searches.
73Universal Containers (UC) has users complaining about reports timing out or simply taking toolong to run What two actions should the data architect recommend to improve the reportingexperience? Choose 2 answers
- AIndex key fields used in report criteria.
- BEnable Divisions for large data objects.
- CCreate one skinny table per report.
- DShare each report with fewer users.
74Universal Containers wants to develop a dashboard in Salesforce that wil allow SalesManagers to do data exploration using their mobile device (i.e., dril down into sales-relateddata) and have the possibility of adding ad-hoc filters while on the move. What is arecommended solution for building data exploration dashboards in Salesforce?
- ACreate a Dashboard in an external reporting tool, export data to the tool, and add link to thedashboard in Salesforce.
- BCreate a Dashboard in an external reporting tool, export data to the tool, and embed thedashboard in Salesforce using the Canval toolkit.
- CCreate a standard Salesforce Dashboard and connect it to reports with the appropriate filters.
- DCreate a Dashboard using Analytics Cloud that will allow the user to create ad-hoc lensesand dril down.
75Universal Containers is integrating a new Opportunity engagement system with Salesforce.According to their Master Data Management strategy, Salesforce is the system of record forAccount, Contact, and Opportunity data. However, there does seem to be valuable Opportunitydata in the new system that potentially conflicts with what is stored in Salesforce. What is therecommended course of action to appropriately integrate this new system?
- AThe MDM strategy defines Salesforce as the system of record, so Salesforce Opportunityvalues prevail in all conflicts.
- BA policy should be adopted so that the system whose record was most recently updatedshould prevail in conflicts.
- CThe Opportunity engagement system should become the system of record for Opportunityrecords.
- DStakeholders should be brought together to discuss the appropriate data strategy movingforward.
76Universal Containers (UC) is launching an RFP to acquire a new accounting product availableon AppExchange. UC is expecting to issue 5 mil ion invoices per year, with each invoicecontaining an average line items. What should UC's Data Architect recommend to ensurescalability?
- AEnsure invoice line items simply reference existing Opportunity line items.
- BEnsure the account product vendor includes Wave Analytics in their offering.
- CEnsure the account product vendor provides a sound data archiving strategy.
- DEnsure the accounting product runs 100% natively on the Salesforce platform.
77Universal Containers has defined a new Data Quality Plan for their Salesforce data and wantsto know how they can enforce it throughout the organization. Which two approaches should anarchitect recommend to enforce this new plan? Choose 2 answers
- ASchedule a weekly dashboard displaying records that are missing information to be sent tomanagers for review.
- BUse Workflow, Validation Rules, and Force.com code (Apex) to enforce critical businessprocesses.
- CSchedule reports that wil automatically catch duplicates and merge or delete the recordsevery week.
- DStore all data in an external system and set up an integration to Salesforce for view -onlyaccess.
78Universal Containers (UC) has an Application custom object, which has tens of mil ions ofrecords created in the past 5 years. UC needs the last 5 years of data to exist in Salesforce atall times for reporting and queries. UC is currently encountering performance issues whenreporting and running queries on this Object using date ranges as filters. Which two options canbe used to improve report performance?
- AAsk support to create a skinny table for Application with the necessary reporting fields.
- BAdd custom indexes to all fields on Application without a standard index.
- CRun multiple reports to get different pieces of the data and combine them.
- DAdd custom indexes to the Date fields used for filtering the report.
79Universal Containers (UC) is implementing a formal, cross -business -unit data governanceprogram As part of the program, UC wil implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2answers
- AAnalytics/BI Owners
- BData Domain Stewards
- CSalesforce Administrators
- DOperational Data Users
80Which two automated approaches should an architect recommend to purge old data out ofSalesforce and aggregate that data in Salesforce? Choose 2 answers
- ASchedulable Batch Apex
- BThird -party Business Intelligence system
- CThird -party Integration Tool (ETL)
- DApex Triggers
81Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales andcustomer service but they are experiencing a lot of duplicate customers in the system. Whichare two recommended approaches for UC to avoid duplicate data and increase the level of dataquality?
- AUse Duplicate Management.
- BUse an Enterprise Service Bus.
- CUse Data.com Clean
- DUse a data wharehouse.
82Universal Containers (UC) has implemented Sales Cloud and it has been noticed that Salesreps are not entering enough data to run insightful reports and dashboards. UC executives would like to monitor and measure data quality metrics.What solution addresses this requirement?
- AUse third-party AppExchange tools to monitor and measure data quality.
- BGenerate reports to view the quality of sample data.
- CUse custom objects and fields to calculate data quality.
- DExport the data to an enterprise data warehouse and use BI tools for data quality.
83Universal Containers (UC) is facing data quality issues where Sales Reps are creating duplicatecustomer accounts, contacts, and leads. UC wants to fix this issue immediately by promptingusers about a record that possibly exists in Salesforce. UC wants a report regarding duplicaterecords. What would be the recommended approach to help UC start immediately?
- ACreate an after insert and update trigger on the account, contact and lead, and send an errorif a duplicate is found using a custom matching criteria.
- BCreate a duplicate rule for account, lead, and contact, use standard matching rules for theseobjects, and set the action to report and alert for both creates and edits.
- CCreate a duplicate rule for account, lead, and contact, use standard matching rules for theseobjects, and set the action to block for both creates and edits.
- DCreate a before insert and update trigger on account, contact, and lead, and send an error ifa duplicate is found using a custom matching criteria.
84Universal Containers (UC) is expecting to have nearly 5 mil ion shipments records in itsSalesforce org. Each shipment record has up to 10 child shipment item records. The Shipmentcustom object has an Organization-wide Default (OWD) sharing model set to Private and theShipment Item custom object has a Master-Detail relationship to Shipment. There are 25sharing rules set on the Shipment custom object, which allow shipment records to be shared toeach of UC's 25 business areas around the globe.These sharing rules use public groups, one for each business area plus a number of groups formanagement and support roles. UC has a high turnover of Sales Reps and often needs to moveSales Reps between business areas in order to meet local demand. What feature would ensurethat performance, when moving Sales Reps between regions, remains adequate while meetingexisting requirements?
- AImplement data archiving for old Shipment records.
- BContact Salesforce to create Skinny tables on Shipment
- CConfigure shipment OWD to Public Read/Write.
- DContact Salesforce to enable Defer Sharing Rules
85An architect has been asked by a client to develop a solution that wil integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use aMaster Data Management system to achieve this solution? Choose 2 answers
- AWhether the systems are cloud -based or on -premise
- BWhether or not Salesforce replaced a legacy CRM.
- CWhether the system of record changes for different tables.
- DThe number of systems that are integrating with each other.
86Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforcemash -ups with back -end systems. The Salesforce Full sandbox used by the project integrateswith full-scale back -end testing systems. What two types of performance testing are appropriatefor this project?Choose 2 answers
- APre -go -live automated page -load testing against the Salesforce Ful sandbox.
- BPost go -live automated page -load testing against the Salesforce Production org.
- CPre -go -live unit testing in the Salesforce Full sandbox.
- DStress testing against the web services hosted by the integration middleware.
87Universal Containers (UC) wants to store product data in Salesforce, but the standard Productobject does not support the more complex hierarchical structure which is currently being used inthe product master system. How can UC modify the standard Product object model to support ahierarchical data structure in order to synchronize product data from the source system toSalesforce?
- ACreate a custom lookup filed on the standard Product to reference the child record in thehierarchy.
- BCreate a custom lookup field on the standard Product to reference the parent record in thehierarchy.
- CCreate a custom master-detail field on the standard Product to reference the child record inthe hierarchy
- DCreate an Apex trigger to synchronize the Product Family standard picklist field on theProduct object.
88Universal Containers wants their Shipment custom object to always relate to a Container, a Sender, and a Receiver (all separate custom objects). If a Shipment is currently associated with a Container, Sender, or Receiver, deletion of those records should not be allowed. They also want separate sharing models on each custom object. What approach should an architect take to fulfill these requirements?
- ACreate a required Lookup relationship to each of the three parent records.
- BCreate two Master -Detail and one Lookup relationship to the parent records.
- CCreate a Master -Detail relationship to each of the three parent records.
- DUse a VLOOKUP formula field to associate the Shipment to each parent record.
89Universal Containers (UC) is planning to move away from legacy CRM to Salesforce. As part of one-time data migration, UC will need to keep the original date when a contact was created in the legacy system. How should an Architect design the data migration solution to meet this requirement?
- AAfter the data is migrated, perform an update on all records to set the original date in a standard CreatedDate field.
- BCreate a new field on Contact object to capture the Created Date. Hide the standard CreatedDate field using Field -Level Security.
- CEnable "Set Audit Fields" and assign the permission to the user loading the data for the duration of the migration.
- DWrite an Apex trigger on the Contact object, before insert event to set the original value in a standard CreatedDate field.
90An architect has been asked to provide error messages when a future date is detected in a custom Birthdate _c field on the Contact object. The client wants the ability to translate the error messages. What are two approaches the architect should use to achieve this solution? Choose 2 answers
- AImplement a third -party validation process with translate functionality.
- BCreate a trigger on Contact and add an error to the record with a custom label.
- CCreate a workflow field update to set the standard ErrorMessage field.
- DCreate a validation rule and translate the error message with translation workbench.
91What is an advantage of using Custom metadata type over Custom setting?
- ACustom metadata records are not copied from production to sandbox.
- BCustom metadata types are available for reporting.
- CCustom metadata records are deployable using packages.
- DCustom metadata records are editable in Apex.
92The invoicing system at Universal Containers requires that attachments associated with the Invoice _c custom object be classified by Types (i.e., "Receipt," "Invoice PDF," etc.) so that reporting can be done on invoices showing the number of attachments grouped by Type. What approach should be taken to categorize the attachments to meet these requirements?
- AAdd additional options to the standard ContentType picklist field for the Attachment object.
- BAdd a ContentType picklist field to the Attachment layout and create additional picklist options.
- CCreate a custom picklist field for the Type on the standard Attachment object with the values.
- DCreate a custom object related to the Invoice object with a picklist field for the Type.
93Universal Containers has a legacy system that captures Conferences and Venues. These Conferences can occur at any Venue. They create hundreds of thousands of Conferences per year. Historically, they have only used 20 Venues. Which two things should the data architect consider when denormalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers
- ALimitations on master -detail relationships.
- BOrg data storage limitations.
- CBulk API limitations on picklist fields.
- DStandard list view in -line editing.
94Universal Container (UC) has around 200,000 Customers (stored in Account object). They get 1 or 2 Orders every month from each Customer. Orders are stored in a custom object called "Order c"; this has about 50 fields. UC is expecting a growth of 10% year -over -year. What are two considerations an architect should consider to improve the performance of SOQL queries that retrieve data from the Order _c object? Choose 2 answers
- AUse SOQL queries without WHERE conditions.
- BWork with Salesforce Support to enable Skinny Tables.
- CReduce the number of triggers on Order _c object.
- DMake the queries more selective using indexed fields.
95Universal Containers (UC) provides shipping services to its customers. They use Opportunities to track customer shipments. At any given time, shipping status can be one of the 10 values. UC has 200,000 Opportunity records. When creating a new field to track shipping status on opportunity, what should the architect do to improve data quality and avoid data skew?
- ACreate a picklist field, values sorted alphabetically.
- BCreate a Master -Detail to custom object ShippingStatus c.
- CCreate a Lookup to custom object ShippingStatus c.
- DCreate a text field and make it an external ID.
96Universal Containers (UC) management has identified a total of ten text fields on the Contact object as important to capture any changes made to these fields, such as who made the change, when they made the change, what is the old value, and what is the new value. UC needs to be able to report on these field data changes within Salesforce for the past 3 months. What are two approaches that will meet this requirement? Choose 2 answers
- ACreate a workflow to evaluate the rule when a record is created and use field update actions to store previous values for these ten fields in ten new fields.
- BWrite an Apex trigger on Contact after insert event and after update events and store the old values in another custom object.
- CLII Turn on field Contact object history tracking for these ten fields, then create reports on contact history.
- DCreate a Contact report including these ten fields and Salesforce Id, then schedule the report to run once a day and send email to the admin.
97Universal Containers (UC) has an open sharing model for its Salesforce users to allow all its Salesforce internal users to edit all contacts, regardless of who owns the contact. However, UC management wants to allow only the owner of a contact record to delete that contact. If a user does not own the contact, then the user should not be allowed to delete the record. How should the architect approach the project so that the requirements are met?
- ACreate a "before delete" trigger to check if the current user is not the owner.
- BSet the Sharing settings as Public Read Only for the Contact object.
- CSet the profile of the users to remove delete permission from the Contact object.
- DCreate a validation rule on the Contact object to check if the current user is not the owner.
98Universal Containers (UC) uses Salesforce for tracking opportunities (Opportunity). UC uses an internal ERP system for tracking deliveries and invoicing. The ERP system supports SOAP API and OData for bi-directional integration between Salesforce and the ERP system. UC has about one million opportunities. For each opportunity, UC sends 12 invoices, one per month. UC sales reps have requirements to view current invoice status and invoice amount from the opportunity page. When creating an object to model invoices, what should the architect recommend, considering performance and data storage space?
- AUse Streaming API to get the current status from the ERP and display on the Opportunity page.
- BCreate an external object Invoice _x with a Lookup relationship with Opportunity.
- CCreate a custom object Invoice _c with a master -detail relationship with Opportunity.
- DCreate a custom object Invoice _c with a Lookup relationship with Opportunity.
99Universal Containers has a large number of Opportunity fields (100) that they want to track field history on. Which two actions should an architect perform in order to meet this requirement? Choose 2 answers
- ACreate a custom object to store a copy of the record when changed.
- BCreate a custom object to store the previous and new field values.
- CUse Analytic Snapshots to store a copy of the record when changed.
- DSelect the 100 fields in the Opportunity Set History Tracking page.
100In a Salesforce org used to manage Contacts, what two options should be considered to maintain data quality? Choose 2 answers
- AUse the private sharing model.
- BUse Salesforce duplicate management.
- CUse validation rules on new record create and edit.
- DUse workflow to delete duplicate records.
101Universal Containers is looking to use Salesforce to manage their sales organization. They will be migrating legacy account data from two aging systems into Salesforce. Which two design considerations should an architect take to minimize data duplication? Choose 2 answers
- AUse a workflow to check and prevent duplicates.
- BClean data before importing to Salesforce.
- CUse Salesforce matching and duplicate rules.
- DImport the data concurrently.
102Universal Containers (UC) has a Salesforce instance with over 10.000 Account records. They have noticed similar, but not identical. Account names and addresses. What should UC do to ensure proper data quality?
- AUse a service to standardize Account addresses, then use a 3rd -party tool to merge Accounts based on rules.
- BRun a report, find Accounts whose name starts with the same five characters, then merge those Accounts.
- CEnable Account de -duplication by creating matching rules in Salesforce, which will mass merge duplicate Accounts.
- DMake the Account Owner clean their Accounts' addresses, then merge Accounts with the same address.
103Managers at Universal Containers (UC) have noticed that shipment records (a custom object) are being sent to the shipping department with bad address data Specifically, addresses have missing data like City and poorly formatted Postal codes. Which two approaches will solve this issue? Choose 2 answers
- AEdit each of the page layouts to require that each address field contains data.
- BUse a Validation Rule using CONTAINS to ensure address fields contain data.
- CUse a Validation Rule using REGEX to ensure proper Postal Code formatting.
- DWrite an Apex Trigger to require all of the fields on the page layouts.
104Universal Containers (UC) has multi -level account hierarchies that represent departments within their major Accounts. Users are creating duplicate Contacts across multiple departments. UC wants to clean the data so as to have a single Contact across departments. What two solutions should UC implement to cleanse their data? Choose 2 answers
- AMake use of a third -party tool to help merge duplicate Contacts across Accounts.
- BUse Data.com to standardize Contact address information to help identify duplicates.
- CUse Workflow rules to standardize Contact information to identify and prevent duplicates.
- DMake use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.
105Universal Containers has defined a new Data Quality Plan for their Salesforce data and wants to know how they can enforce it throughout the organization. Which two approaches should an architect recommend to enforce this new plan?Choose 2 answers
- ASchedule a weekly dashboard displaying records that are missing information to be sent to managers for review.
- BUse Workflow, Validation Rules, and Force.com code (Apex) to enforce critical business processes.
- CSchedule reports that will automatically catch duplicates and merge or delete the records every week.
- DStore all data in an external system and set up an integration to Salesforce for view -only access.
106Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?
- AAllow users to import their data using the Salesforce Import tools.
- BUtilize a 3rd -party solution from the AppExchange for data uploads.
- CUtilize an app from the AppExchange to create data -quality dashboards.
- DUse Apex to validate the format of phone numbers and postal codes.
107which two methods should be used when importing Leads into Salesforce to ensure there are no duplicate records? Choose 2 answers
- ACreate a Workflow Rule to check for duplicate records.
- BPurchase an AppExchange Lead de -duplication application.
- CImplement Salesforce Matching and Duplicate Rules.
- DRun the Salesforce Lead Mass de -duplication tool.
108A customer has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout. The customer has noticed that many of the records coming from the external system are missing data in this field. What two things should the architect do to ensure this field always contains data coming from the source system? Choose 2 answers
- ASet up a Validation Rule to prevent blank values.
- BCreate a Workflow to default a value into this field.
- CMark the field required in setup at the field level.
- DBlame the customer's external system for bad data.
109Universal Containers has two systems. Salesforce and an on -premise ERP system. An architect has been tasked with copying Opportunity records to the ERP once they reach a Closed/Won Stage. The Opportunity record in the ERP system will be read-only for all fields copied in from Salesforce. What is the optimal real-time approach that achieves this solution?
- AImplement a Master Data Management system to determine system of record.
- BImplement a workflow rule that sends Opportunity data through Outbound Messaging.
- CHave the ERP poll Salesforce nightly and bring in the desired Opportunities.
- DImplement an hourly integration to send Salesforce Opportunities to the ERP system.
110Universal Containers (UC) has three systems: Salesforce, a cloud -based ERP system, and an on -premise Order Management System (OMS). An architect has been tasked with creating a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts. UC wants Accounts and Contacts to be able to maintain their names in each system (i.e., "John Doe" in the OMS and "Johnny Doe" in Salesforce), but wants to have a consolidated data store which links referenced records across the systems. What approach should an architect suggest so the requirements are met?
- AHave Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
- BImplement an integration tool to send OMS Accounts and Contacts to Salesforce.
- CImplement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
- DUse the Streaming API to send Account and Contact data from Salesforce to the OMS.
111An architect has been asked by a client to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems. What two factors should the architect take into consideration when deciding whether or not to use a Master Data Management system to achieve this solution? Choose 2 answers
- AWhether the systems are cloud -based or on -premise.
- BWhether or not Salesforce replaced a legacy CRM.
- CWhether the system of record changes for different tables.
- DThe number of systems that are integrating with each other.
112A customer is integrating two different systems with customer records into the Salesforce Account object Master Data Management will be used to ensure that no duplicate records are created in Salesforce. How can the architect determine which system is the system of record on a field level?
- AAny field that is an input field in either external system will be overwritten by the last record integrated and can never have a system of record.
- BReview the database schema for each external system and any fields with different names should always be separate fields in Salesforce.
- CMaster Data Management systems determine system of record and the architect doesn't have to think about what data is controlled by what system
- DAny Fields with the same purpose between the two systems should be reviewed by the key stakeholders to see how they will be used in Salesforce.
113In a disparate multi -system ERP environment, where Salesforce is being deployed, what are two techniques that should be used to maintain data synchronization between systems? Choose 2 answers
- ABuild synchronization reports and dashboards.
- BIntegrate Salesforce with the ERP environment.
- CEstablish an MDM strategy to outline a single source of truth.
- DUse workbench to update files within systems.
114All accounts and opportunities are created in Salesforce. Salesforce is integrated with three systems:• An ERP system feeds order data into Salesforce and updates both Account and Opportunity records.• An accounting system feeds invoice data into Salesforce and updates both Account and Opportunity records.• A commission system feeds commission data into Salesforce and updates both Account and Opportunity records.How should the architect determine which of these systems is the system of record?
- AAccount and opportunity data originates in Salesforce, and therefore Salesforce is the system of record.
- BWhatever system updates the attribute or object should be the system of record for that field or object.
- CWhatever integration data flow runs last will, by default, determine which system is the system of record.
- DData flows should be reviewed with the business users to determine the system of record per object or field.
115What are two valid metadata types that should be included to document the data architecture of a Salesforce org? Choose 2 answers
- ARecordType
- BDocument
- CCustomField
- DSecuritySettings
116What are two key artifacts used to document the data architecture for a multi -system enterprise Salesforce implementation? Choose 2 answers
- AUser stories
- BData model
- CNon-functional requirements
- DIntegration specification
117As part of a phased Salesforce rollout. there will be 3 deployments spread out over the year. The requirements have been carefully documented. Which two methods should an architect use to trace back configuration changes to the detailed requirements? Choose 2 answers
- AReview the setup audit trail for configuration changes.
- BPut the business purpose in the Description of each field.
- CMaintain a data dictionary with the justification for each field.
- DUse the Force.com IDE to save the metadata files in source control.
118How can an architect find information about who is creating, changing, or deleting certain fields within the past two months?
- ARemove "customize application" permissions from everyone else.
- BExport the metadata and search it for the fields in question.
- CCreate a field history report for the fields in question.
- DExport the setup audit trail and find the fields in question.
119Universal Containers wants to automatically archive all inactive Account data that is older than 3 years. The information does not need to remain accessible within the application. Which two methods should be recommended to meet this requirement? Choose 2 answers
- AUse the Force.com Workbench to export the data.
- BSchedule a weekly export file from the Salesforce UI.
- CSchedule jobs to export and delete using an ETL tool.
- DSchedule jobs to export and delete using the Data Loader.
120Which two automated approaches should an architect recommend to purge old data out of Salesforce and aggregate that data in Salesforce? Choose 2 answers
- ASchedulable Batch Apex
- BThird -party Business Intelligence system
- CThird -party Integration Tool (ETL)
- DApex Triggers
121Universal Containers (UC) is concerned that data is being corrupted daily either through negligence or maliciousness. They want to implement a backup strategy to help recover any corrupted data or data mistakenly changed or even deleted. What should the data architect consider when designing a field -level audit and recovery plan?
- AReduce data storage by purging old data.
- BImplement an AppExchange package.
- CReview projected data storage needs.
- DSchedule a weekly export file.
122A Salesforce customer has millions of orders every year. Each order contains, on average, ten line items. The customer wants its Sales Reps to know how much money each customer generates year -over -year, but they are running out of data storage in Salesforce. What data archiving plan should the architect recommend?
- AAnnually delete orders and order line items and ensure the customer has order information in another system.
- BAnnually aggregate order amount data to store in a custom object, then delete those orders and order line items.
- CAnnually export and delete orders and order line items and store them in a zip file in case the data is needed later.
- DAnnually export and delete order line items and store them in a zip file in case they data is needed later.
123A customer monitors over 10,000 servers and these servers automatically record their status every 15 minutes The customer is required to maintain all of these status reports for a period of 10 years. Service Reps need access to up to one week's worth of these status reports with all of their details. What are two limits an architect should consider when recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce?Choose 2 answers
- AData storage limits
- BAPI Request limits
- CWebservice callout limits
- DWorkflow rule limits
124A Salesforce customer has plenty of data storage. Sales Reps are complaining that searches are bringing back old records that aren't relevant any longer. Sales Managers need the data for their historical reporting.What strategy should a data architect use to ensure a better user experience for the Sales Reps?
- ACreate a Permission Set to hide old data from Sales Reps.
- BUse Batch Apex to archive old data on a rolling nightly basis.
- CArchive and purge old data from Salesforce on a monthly basis
- DSet data access to Private to hide old data from Sales Reps.
125Universal Containers (UC) is implementing a formal, cross -business -unit data governance program As part of the program, UC will implement a team to make decisions on enterprise -wide data governance. Which two roles are appropriate as members of this team? Choose 2 answers
- AAnalytics/BI Owners
- BData Domain Stewards
- CSalesforce Administrators
- DOperational Data Users
126Universal Containers (UC) has a complex system landscape and is implementing a data governance program for the first time Which two first steps would be appropriate for UC to initiate an assessment of data architecture? Choose 2 answers
- AEngage with IT program managers to assess current velocity of projects in the pipeline.
- BEngage with database administrators to assess current database performance metrics.
- CEngage with executive sponsorship to assess enterprise data strategy and goals.
- DEngage with business units and IT to assess current operational systems and data models.
127A data architect has been tasked with optimizing a data stewardship engagement for a Salesforce instance Which three areas of Salesforce should the architect review before proposing any design recommendation? Choose 3 answers
- AReview the metadata xml files for redundant fields to consolidate.
- BDetermine if any integration points create records in Salesforce.
- CRun key reports to determine what fields should be required.
- DExport the setup audit trail to review what fields are being used.
- EReview the sharing model to determine impact on duplicate records.
128To avoid creating duplicate Contacts, a customer frequently uses Data Loader to upsert Contact records into Salesforce. What common error should the data architect be aware of when using upsert?
- AErrors with duplicate external Id values within the same CSV file.
- BErrors with records being updated and inserted in the same CSV file.
- CErrors when a duplicate Contact name is found cause upsert to fail.
- DErrors with using the wrong external Id will cause the load to fail.
129Universal Containers has deployed Salesforce for case management The company is having difficulty understanding what percentage of cases are resolved from the initial call to their support organization. What first step is recommended to implement a reporting solution to measure the support reps case closure rates?
- AEnable field history tracking on the Case object.
- BCreate a report on Case analytic snapshots.
- CInstall AppExchange packages for available reports.
- DCreate Contact and Opportunity Reports and Dashboards.
130Universal Containers uses Salesforce to track its sales opportunities The Sales VP would like to better understand key relevant performance figures and help the Sales Managers take corrective actions where appropriate. What reporting option should be considered?
- AOpportunity analytic snapshot
- BCase SLA performance report
- CLead conversion rate report
- DSales KPI Dashboard
131In their legacy system. Universal Containers has a monthly accounts receivable report that compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What difficulty will an architect run into when implementing this in Salesforce?
- ASalesforce allows up to four objects in a single report type.
- BSalesforce does not support Orders or Order Line Items.
- CA report cannot contain data from Accounts and Contacts.
- DCustom report types cannot contain Opportunity data.
132Universal Containers keeps its Account data in Salesforce and its Invoice data in a third -party ERP system. They have connected the Invoice data through a Salesforce external object. They want data from both Accounts and Invoices visible in one report in one place. What two approaches should an architect suggest for achieving this solution? Choose 2 answers
- ACreate a report in an external system combining Salesforce Account data and Invoice data from the ERP.
- BCreate a report combining data from the Account standard object and the Invoices external object.
- CCreate a Visualforce page combining Salesforce Account data and Invoice external object data.
- DCreate a separate Salesforce report for Accounts and Invoices and combine them in a dashboard.
133Universal Containers wishes to maintain Lead data from Leads even after they are deleted and cleared from the Recycle Bin. What approach should be implemented to achieve this solution?
- AUse a Lead standard report and filter on the IsDeleted standard field.
- BUse a Converted Lead report to display data on Leads that have been deleted.
- CQuery Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.
- DSend data to a Data Warehouse and mark Leads as deleted in that system.
134Universal Containers (UC) has deployed Salesforce to manage Marketing. Sales, and Support efforts in a multi -system ERP environment After reaching the limits of native reports & dashboards. UC leadership is looking to understand what options can be used to provide more analytical insights. What two approaches should an architect recommend? Choose 2 answers
- AAppExchange Apps
- BWave Analytics
- CWeekly Snapshots
- DSetup Audit Trails
135Universal Containers is setting up an external Business Intelligence (BI) system and wants to extract 1,000,000 Contact records. What should be recommended to avoid timeouts during the export process?
- AUse the SOAP API to export data.
- BUtilize the Bulk API to export the data
- CUse GZIP compression to export the data.
- DSchedule a Batch Apex job to export the data.
136Universal Containers (UC) is a business that works directly with individual consumers (B2C). They are moving from a current home-grown CRM system to Salesforce. UC has about one million consumer records. What should the architect recommend for optimal use of Salesforce functionality and also to avoid data loading issues?
- ACreate a Custom Object Individual Consumer c to load all individual consumers.
- BLoad all individual consumers as Account records and avoid using the Contact object.
- CLoad one Account record and one Contact record for each individual consumer.
- DCreate one Account and load individual consumers as Contacts linked to that one Account.
137Universal Containers (UC) has a data model as shown in the image.The Project object has a private sharing model, and it has Roll -Up summary fields to calculate the number of resources assigned to the project, total hours for the project, and the number of work items associated to the project. What should the architect consider, knowing there will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.com?
- ALoad all data using external IDs to link to parent records.
- BUse workflow to calculate summary values instead of Roll -Up.
- CUse triggers to calculate summary values instead of Roll -Up.
- DLoad all data after deferring sharing calculations.
138Universal Containers is migrating their legacy system's users and data to Salesforce. They will be creating 10,000 users,2 million Account records, and 10 million Invoice records. The visibility of these records is controlled by a few dozen owner and criteria -based sharing rules. What are two approaches that will minimize data loading time during this migration to a new organization? Choose 2 answers
- ACreate the users, upload all data, and then deploy the sharing rules.
- BContact Salesforce to activate indexing before uploading the data.
- CFirst, load all account records, and then load all user records.
- DDefer sharing calculations until the data has finished uploading.
139Universal Containers wishes to send data from Salesforce to an external system to generate invoices from their Order Management System (OMS). They want a Salesforce administrator to be able to customize which fields be sent to the external system without modifying code. What two approaches should an architect recommend to deliver the desired solution? Choose 2 answers
- AA set to determine which fields to send in an HTTP callout.
- BAn Outbound Message to determine which fields to send to the OMS.
- CA Field Set that determines which fields to send in an HTTP callout.
- DEnable the field -level security permissions for the fields to send.
140The architect is planning a large data migration for Universal Containers from their legacy CRM system to Salesforce. What three things should the architect consider to optimize performance of the data migration? Choose 3 answers
- AReview the time zones of the User loading the data.
- BRemove custom indexes on the data being loaded.
- CDetermine if the legacy system is still in use.
- DDefer sharing calculations of the Salesforce Org.
- EDeactivate approval processes and workflow rules.
141Universal Containers has a large volume of Contact data going into Salesforce.com. There are 100,000 existing contact records. 200,000 new contacts will be loaded. The Contact object has an external ID field that is unique and must be populated for all existing records. What should the architect recommend to reduce data load processing time?
- ALoad Contact records together using the Streaming API via the Upsert operation
- BDelete all existing records, and then load all records together via the Insert operation.
- CLoad all records via the Upsert operation to determine new records vs. existing records.
- DLoad new records via the Insert operation and existing records via the Update operation.
142An architect is planning on having different batches to load one million Opportunities into Salesforce using the Bulk API in parallel mode. What should be considered when loading the Opportunity records?
- ACreate indexes on Opportunity object text fields.
- BGroup batches by the AccountId field.
- CSort batches by Name field values.
- DOrder batches by Auto -number field.
143Universal 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?
- ATooling API
- BPK Chunking
- CMetadata API
- DStreaming API
144Global Containers (GC) just acquired Universal Containers (UC). Both companies use Salesforce. and as part of the acquisition, all of the data for the UC Salesforce instance (source) must be migrated into the GC Salesforce instance (target). Universal Containers has over 5 million Case records. What should the architect consider when trying to optimize the data load time?
- AUse the Salesforce Org Migration Tool from the Setup Data Management menu.
- BPre-process the data, then use Data Loader with SOAP API to upsert with zip compression enabled.
- CLoad Case data directly leveraging Salesforce-to-Salesforce functionality.
- DBreak the load into multiple sets of data to be loaded using Bulk API parallel processes.
145Universal Containers (UC) has over 10 million records. They have a nightly integration that queries these records The queries are timing out What should the data architect do or look for when troubleshooting the queries? Choose 2 answers
- AChange the integration users' profile to have View All Data.
- BEnsure the query doesn't contain NULL in any filter criteria.
- CCreate custom indexes on the fields used in the filter criteria.
- DCreate a formula field instead of having multiple filter criteria.
146Universal Containers (UC) is implementing a Salesforce project with large volumes of data and daily transactions. The solution includes both real-time web service integrations and Visualforce mash -ups with back -end systems. The Salesforce Full sandbox used by the project integrates with full-scale back -end testing systems. What two types of performance testing are appropriate for this project? Choose 2 answers
- APre -go -live automated page -load testing against the Salesforce Full sandbox.
- BPost go -live automated page -load testing against the Salesforce Production org.
- CPre -go -live unit testing in the Salesforce Full sandbox.
- DStress testing against the web services hosted by the integration middleware.
Informationen
- Beschreibung
- Quiz am Data MNG, erstellt von Jonathan Bf am 19/12/2019.
- Autor
- Jonathan Bf
- Sprache
- Español
- Aufrufe
- 0
- Schlagwörter
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz