Jan-2023 Download Free Latest Exam Data-Architecture-And-Management-Designer Certified Sample Questions
Prepare for your exam certification with our Data-Architecture-And-Management-Designer Certified Salesforce
NEW QUESTION 99
Universal 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?
- A. Delete all existing records, and then load all records together via the Insert operation.
- B. Load new records via the Insert operation and existing records via the Update operation.
- C. Load all records via the Upsert operation to determine new records vs. existing records.
- D. Load Contact records together using the Streaming API via the Upsert operation.
Answer: B
NEW QUESTION 100
Universal 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
- A. Use Data.com to standardize Contact address information to help identify duplicates.
- B. Make use of a third -party tool to help merge duplicate Contacts across Accounts.
- C. Make use of the Merge Contacts feature of Salesforce to merge duplicates for an Account.
- D. Use Workflow rules to standardize Contact information to identify and prevent duplicates.
Answer: A,B
NEW QUESTION 101
Universal 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?
- A. Use GZIP compression to export the data.
- B. Use the SOAP API to export data.
- C. Schedule a Batch Apex job to export the data.
- D. Utilize the Bulk API to export the data.
Answer: A
NEW QUESTION 102
UC is building a salesforce application to track contacts and their respective conferences that they have attended with the following requirements:
1. Contacts will be stored in the standard contact object.
2. Conferences will be stored in a custom conference__c object.
3. Each contact may attend multiple conferences and each conference may be related to multiple contacts.
How should a data architect model the relationship between the contact and conference objects?
- A. Create a master detail relationship field on the Conference object.
- B. Create a master detail relationship field on the Contact object.
- C. Create a lookup relationship field on contact object.
- D. Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.
Answer: D
NEW QUESTION 103
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?
- A. Implement a new Categories custom object and a master-detail relationship from Account to Category.
- B. Implement a new Categories custom object and create a lookup field from Account to Category.
- C. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
- D. Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
Answer: C
NEW QUESTION 104
Universal Containers is experiencing frequent and persistent group membership locking issues that severely restricts its ability to manage manual and a automated updates at the same time.
What should a data architect do in order to restore the issue?
- A. Enable granular locking
- B. Enable implicit sharing
- C. Enable parallel sharing rule calculation.
- D. Enable defer sharing calculation
Answer: A
NEW QUESTION 105
Cloud Kicks has the following requirements:
* Their Shipment custom object must always relate to a Product, a Sender, and a Receiver (all separate custom objects).
* If a Shipment is currently associated with a Product, Sender, or Receiver, deletion of those records should not be allowed.
* Each custom object must have separate sharing models.
What should an Architect do to fulfill these requirements?
- A. Create a required Lookup relationship to each of the three parent records.
- B. Create two Master-Detail and one Lookup relationship to the parent records.
- C. Create a Master-Detail relationship to each of the three parent records.
- D. Associate the Shipment to each parent record by using a VLOOKUP formula field.
Answer: A
NEW QUESTION 106
UC is having issues using Informatica Cloud Louder to export +10MOrder records. Each Order record has 10 Order Line Items. What two steps can you take to help correct this? Choose two answers.
- A. Export in multiple batches
- B. Use PK Chunking
- C. Export Bulk API in parallel mode
- D. Limit Batch to 10K records
Answer: A,B
NEW QUESTION 107
Universal Containers (UC) has adopted Salesforce as its primary sales automation tool. UC has 100,000 customers with a growth rate of 10% a year. UC uses an on-premise web-based billing and invoice system that generates over 1 million invoices a year supporting a monthly billing cycle.
The UC sales team needs to be able to pull up a customer record and view their account status, invoice history, and open opportunities without navigating outside of Salesforce.
What should a data architect use to provide the sales team with the required functionality?
- A. Create a mashup page that will present the billing system records within Salesforce.
- B. Write an Apex callout and populate a related list to display on the account record.
- C. Create a custom object and migrate the last 12 months of invoice data into Salesforce so it can be displayed on the Account layout.
- D. Create a visual force tab with the billing system encapsulated within an iframe.
Answer: A
Explanation:
Mashups use Salesforce presentation to display Salesforce-hosted data and externally hosted data.
Reference: https://developer.salesforce.com/docs/atlas.en-us.salesforce_large_data_volumes_bp.meta/ salesforce_large_data_volumes_bp/ldv_deployments_techniques_using_mashups.htm
NEW QUESTION 108
NTO uses salesforce to manage relationships and track sales opportunities. It has 10 million customers and
100 million opportunities. The CEO has been complaining 10 minutes to run and sometimes failed to load, throwing a time out error.
Which 3 options should help improve the dashboard performance?
Choose 3 answers:
- A. De-normalize the data by reducing the number of joins.
- B. Reduce the amount of data queried by archiving unused opportunity records.
- C. Run the dashboard for CEO and send it via email.
- D. Remove widgets from the dashboard to reduce the number of graphics loaded.
- E. Use selective queries to reduce the amount of data being returned.
Answer: A,B,E
NEW QUESTION 109
UC is planning a massive SF implementation with large volumes of data. As part of the org's implementation, several roles, territories, groups, and sharing rules have been configured. The data architect has been tasked with loading all of the required data, including user data, in a timely manner.
What should a data architect do to minimize data load times due to system calculations?
- A. Enable granular locking to avoid "UNABLE _TO_LOCK_ROW" error.
- B. Leverage the Bulk API and concurrent processing with multiple batches
- C. Enable defer sharing calculations, and suspend sharing rule calculations
- D. Load the data through data loader, and turn on parallel processing.
Answer: C
NEW QUESTION 110
Universal 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?
- A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
- B. Implement a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
- C. Use the Streaming API to send Account and Contact data from Salesforce to the OMS.
- D. Implement an integration tool to send OMS Accounts and Contacts to Salesforce.
Answer: B
NEW QUESTION 111
A company is introducing a new data quality process and needs an Architect to recommend an appropriate approach. The new process will monitor the data that users are manually entering into the system through the Salesforce UI.
Which recommendation is correct?
- A. Enable users to import their data using the Salesforce Import tools.
- B. Validate the format of phone numbers and postal codes by using Apex.
- C. Create data-quality dashboards by using an app from the AppExchange.
- D. Use a 3rd-party solution from the AppExchange for data uploads.
Answer: C
Explanation:
Explanation/Reference:
NEW QUESTION 112
Which three characteristics of a Skinny table help improve report and query performance?
- A. Skinny tables can be used to create custom indexes on multi-select picklist fields.
- B. Skinny tables provide a view across multiple objects for easy access to combined data.
- C. Skinny tables can contain frequently used fields and thereby help avoid joins.
- D. Skinny tables are kept in sync with changes to data in the source tables.
- E. Skinny tables do not include records that are available in the recycle bin.
Answer: B,C,D
NEW QUESTION 113
Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org.
UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org?
Choose 3 answers
- A. Use Rest API to permanently delete records from the Salesforce org.
- B. Identify records in objects that have not been modified or used In last 3 years.
- C. Use hard delete in Bulk API to permanently delete records from Salesforce.
- D. Use hard delete in batch Apex to permanently delete records from Salesforce.
- E. Archive the records in enterprise data warehouse (EDW) before deleting from Salesforce.
Answer: B,C,E
NEW QUESTION 114
UC is using SF CRM. UC sales managers are complaining about data quality and would like to monitor and measure data quality.
Which 2 solutions should a data architect recommend to monitor and measure data quality?
Choose 2 answers.
- A. Use custom objects and fields to identify issues.
- B. Review data quality reports and dashboards.
- C. Export data and check for data completeness outside of Salesforce.
- D. Install and run data quality analysis dashboard app
Answer: B,D
NEW QUESTION 115
Salesforce is being deployed in Ursa Major Solar's disparate, multi-system ERP environment. Ursa major Solar wants to maintain data synchronization between systems.
Which two techniques should be used to achieve this goal? (Choose two.)
- A. Utilize an MDM strategy to outline a single source of truth.
- B. Integrate Salesforce with the ERP environment.
- C. Utilize workbench to update files within systems.
- D. Build synchronization reports and dashboards.
Answer: A,B
NEW QUESTION 116
Northern Trail Outfitters (NTO) is in the process of evaluating big objects to store large amounts of asset data from an external system. NTO will need to report on this asset data weekly.
Which two native tools should a data architect recommend to achieve this reporting requirement? (Choose two.)
- A. Einstein Analytics
- B. Async SOQL with a custom object
- C. Standard SOQL queries
- D. Standard reports and dashboards
Answer: A,D
NEW QUESTION 117
Northern Trail Outfitters (NTO) has implemented Salesforce for its sales users. The opportunity management in Saiesforce Is implemented as follows:
1. Sales users enter their opportunities in Salesforce for forecasting and reporting purposes.
2. NTO has a product pricing system (PPS) that is used to update the Opportunity Amount field on opportunities on a daily basis.
3. PPS is the trusted source within NTO for Opportunity Amount.
4. NTO uses Opportunity Forecast for its sales planning and management.
Sales users have noticed that their updates to the Opportunity Amount field are overwritten when PPS updates their opportunities.
How should a data architect address this overwriting issue?
- A. Create a custom field for Opportunity amount that PSS updates separating the field sales user updates.
- B. Create a custom field for Opportunity amount that sales users update separating the field that PPS updates.
- C. Change PSS integration to update only Opportunity Amount field when the value is null.
- D. Change Opportunity Amount field access to Read Only for sales users field-level security.
Answer: D
NEW QUESTION 118
A large multinational B2C Salesforce customer is looking to implement their distributor management application is Salesforce. the application has the following capabilities:
1.Distributor create sales order in salesforce
2.Sales order are based on product prices applicable to their region
3. Sales order are closed once they are fulfilled
4. It is decided to maintain the order in opportunity object
How should the data architect model this requirement?
- A. Create lookup to Custom Price object and share with distributors.
- B. Add custom fields in Opportunity and use triggers to update prices.
- C. Manually update Opportunities with Prices application to distributors.
- D. Configure price Books for each region and share with distributors.
Answer: D
NEW QUESTION 119
Universal Containers (UC) is implementing its new Internet of Things technology, which consists of smart containers that provide information on container temperature and humidity updated every 10 minutes back to UC. There are roughly 10,000 containers equipped with this technology with the number expected to increase to 50,000 across the next five years. It is essential that Salesforce user have access to current and historical temperature and humidity data for each container. What is the recommended solution?
- A. Create 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.
- B. 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.
- C. 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.
- D. Create a new Container Reading custom object with a master-detail relationship to Container which is created when a new measure is received for a specific container.
Implement an archiving process that runs every hour.
Answer: D
NEW QUESTION 120
DreamHouse Realty has a Salesforce org that is used to manage Contacts.
What are two things an Architect should consider using to maintain data quality in this situation? (Choose two.)
- A. Use workflow to delete duplicate records.
- B. Use validation rules on new record create and edit.
- C. Use the private sharing model.
- D. Use Salesforce duplicate management.
Answer: B,D
NEW QUESTION 121
......
Free Salesforce Data-Architecture-And-Management-Designer Exam 2023 Practice Materials Collection: https://prep4sure.real4dumps.com/Data-Architecture-And-Management-Designer-prep4sure-exam.html
