Data-Architecture-And-Management-Designer Exam Brain Dumps - Study Notes and Theory [Sep-2023]
100% Guaranteed Results Data-Architecture-And-Management-Designer Unlimited 224 Questions
NEW QUESTION # 99
Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)
- A. Using a custom index on a deterministic formula field.
- B. Using NOT and != operators.
- C. Using trailing % wildcards.
- D. Using leading % wildcards.
- E. Performing large loads and deletions.
Answer: A,B,D
NEW QUESTION # 100
NTO has implemented salesforce for its sales users. The opportunity management in salesforce 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 opportunity amount field on opportunities on a daily basis.
3. PPS is the trusted source within the 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 overriding issue?
- A. Change opportunity amount field access to read only for sales users using field level security.
- B. Create a custom field for opportunity amount that PPS updates separating the field that sales user updates.
- C. Create a custom field for opportunity amount that sales users update separating the fields that PPS updates.
- D. Change PPS integration to update only opportunity amount fields when values is NULL.
Answer: A
NEW QUESTION # 101
Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two org:org A and org B, UC has delivered these requirements to its data architect
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from org A to org B for compliance reasons.
3. The migrate will need occur within the next two month, prior to be split.
Which migrate strategy should a data architect use to successfully migrate the date?
- A. use as ETL tool to orchestrate the migration.
- B. Use the Salesforces CLI to query, export, and import
- C. Write a script to use the Bulk API
- D. Use Data Loader for export and Data Import Wizard for import
Answer: C
NEW QUESTION # 102
Universal Containers developers have created a new Lightning component that uses an Apex controller using a SOQL query to populate a custom list view. Users are complaining that the component often fails to load and returns a time-out error.
What tool should a data architect use to identify why the query is taking too long?
- A. Use Salesforce's query optimizer to analyze the query in the developer console
- B. Use Splunk to query the system logs looking for transaction time and CPU usage
- C. Enable and use the Query Plan tool in the developer console
- D. Open a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time
Answer: A
Explanation:
Explanation
Explanation/Reference: https://trailhead.salesforce.com/content/learn/modules/database_basics_dotnet/ writing_efficient_queries
NEW QUESTION # 103
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items.
The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?
- A. 1. Annually delete orders and order line items. 2. Ensure the customer has order information in another system.
- B. 1. Annually export and delete order line items. 2. Store them in a zip file in case the data is needed later.
- C. 1. Annually export and delete orders and order line items. 2. Store them in a zip file in case the data is needed later.
- D. 1. Annually aggregate order amount data to store in a custom object. 2. Delete those orders and order line items.
Answer: D
NEW QUESTION # 104
Universal containers is implementing Salesforce lead management. UC Precure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option
- A. Run reports to identify records which does not have company profile and location data
- B. Leverage external data providers populate company profile and location data
- C. Ask sales people to search for populating company profile and location data
- D. Export data out of Salesforce and send to another team to populate company profile and location data
Answer: B
NEW QUESTION # 105
DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.
DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answers
- A. Mark the field required in setup at the field level.
- B. Create a Workflow to default a value into this field.
- C. Blame the customer's external system for bad data.
- D. Set up a Validation Rule to prevent blank values.
Answer: A,D
NEW QUESTION # 106
Every year, Ursa Major Solar has more than 1 million orders. Each order contains an average of 10 line items. The Chief Executive Officer (CEO) needs the Sales Reps to see how much money each customer generates year-over-year. However, data storage is running low in Salesforce.
Which approach for data archiving is appropriate for this scenario?
- A. 1. Annually export and delete orders and order line items.
2. Store them in a zip file in case the data is needed later. - B. 1. Annually export and delete order line items.
2. Store them in a zip file in case the data is needed later. - C. 1. Annually aggregate order amount data to store in a custom object.
2. Delete those orders and order line items. - D. 1. Annually delete orders and order line items.
2. Ensure the customer has order information in another system.
Answer: C
NEW QUESTION # 107
Universal Containers (UC) loads bulk leads and campaigns from third-party lead aggregators on a weekly and monthly basis. The expected lead record volume is 500K records per week, and the expected campaign records volume is 10K campaigns per week. After the upload, Lead records are shared with various sales agents via sharing rules and added as Campaign members via Apex triggers on Lead creation. UC agents work on leads for 6 months, but want to keep the records in the system for at least 1 year for reference. Compliance requires them to be stored for a minimum of 3 years. After that, data can be deleted. What statement is true with respect to a data archiving strategy for UC?
- A. UC can leverage recycle bin capability, which guarantees record storage for 15 days after deletion.
- B. UC can leverage a "tier"-based approach to classify the record storage need.
- C. UC can store long-term lead records in custom storage objects to avoid counting against storage limits.
- D. UC can leverage the Salesforce Data Backup and Recovery feature for data archival needs.
Answer: B
NEW QUESTION # 108
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 are kept in sync with changes to data in the source tables.
- C. Skinny tables provide a view across multiple objects for easy access to combined data.
- D. Skinny tables can contain frequently used fields and thereby help avoid joins.
- E. Skinny tables do not include records that are available in the recycle bin.
Answer: B,C,D
NEW QUESTION # 109
UC has millions of case records with case history and SLA dat
a. UC's compliance team would like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?
- A. Purchase more data storage to support case object
- B. Use a custom Big object to store archived case data.
- C. Archive Case data using Salesforce Archiving process
- D. Use a custom object to store archived case data.
Answer: B
NEW QUESTION # 110
Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?
- A. Add description fields to explain why the field is used, and mark the fields as Required.
- B. Create reports to identify which fields users are leaving blank, and use external data sources to augment the missing data.
- C. Create validation rules with error messages to explain why the field is used.
- D. Create and manage a data dictionary, and use a governance process for changes made to common objects.
Answer: D
NEW QUESTION # 111
An Architect needs information about who is creating, changing, or deleting certain fields within the past four months.
How can the Architect access this information?
- A. After exporting the metadata, search it for the fields in question.
- B. Create a field history report for the fields in question.
- C. Remove "customize application" permissions from everyone else.
- D. After exporting the setup audit trail, find the fields in question.
Answer: D
NEW QUESTION # 112
Cloud Kicks has deployed Salesforce for case management and wants to know the percentage of cases that are resolved from the initial call to their support organization.
An Architect needs to recommended a reporting solution to measure the support reps case closure rates.
What is an appropriate recommendation?
- A. Ensure that Contact and Opportunity Reports and Dashboards are created.
- B. Ensure that a report is created on Case analytic snapshots.
- C. Ensure field history tracking is enabled on the Case object.
- D. Ensure that AppExchange packages are installed for available reports.
Answer: C
NEW QUESTION # 113
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 # 114
Universal 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?
- A. Load one Account record and one Contact record for each individual consumer.
- B. Create one Account and load individual consumers as Contacts linked to that one Account.
- C. Load all individual consumers as Account records and avoid using the Contact object.
- D. Create a Custom Object Individual Consumer c to load all individual consumers.
Answer: A
NEW QUESTION # 115
Members of DreamHouse Realty sales team are reporting that searches are yielding too many irrelevant, outdated records. Management requires that data for historical reporting. DreamHouse Realty has enough data storage.
In this situation, which strategy should a data architect use to ensure a better user experience for the Sales Reps?
- A. Archive and purge old data from Salesforce on a monthly basis.
- B. Hide old data from Sales Reps by creating a Permission Set.
- C. Use Batch Apex to archive old data on a rolling nightly basis.
- D. Hide old data from Sales Reps by setting data access to Private.
Answer: A
NEW QUESTION # 116
NTO has 1 million customer records spanning 25 years. As part of its new SF project, NTO would like to create a master data management strategy to help preserve the history and relevance of its customer data.
Which 3 activities will be required to identify a successful master data management strategy? Choose 3 answers:
- A. Choose a Business Intelligence tool.
- B. Install a data warehouse
- C. Define the systems of record for critical data
- D. Identify data to be replicated
- E. Create a data archive strategy
Answer: C,E
NEW QUESTION # 117
Universal Containers (UC) is in the process of selling half of its company. As part of this split, UC's main Salesforce org will be divided into two orgs: Org A and Org
B. UC has delivered these requirements to its data architect:
1. The data model for Org B will drastically change with different objects, fields, and picklist values.
2. Three million records will need to be migrated from Org A to Org B for compliance reasons.
3. The migration will need occur within the next two months, prior to the spilt.
Which migration strategy should a data architect use to successfully migrate the data?
- A. Use an ETL tool to orchestrate the migration.
- B. Use Data Loader for export and Data Import Wizard for import.
- C. Use the Salesforce CLI to query, export, and import.
- D. Write a script to use the Bulk API.
Answer: C
NEW QUESTION # 118
UC has a classic encryption for Custom fields and is leveraging weekly data reports for data backups. During the data validation of exported data UC discovered that encrypted field values are still being exported as part of data exported. What should a data architect recommend to make sure decrypted values are exported during data export?
- A. Set up a custom profile for data migration user and assign view encrypted data.
- B. Leverage Apex class to decrypt data before exporting it.
- C. Set a standard profile for Data Migration user, and assign view encrypted data
- D. Create another field to copy data from encrypted field and use this field in export
Answer: A
NEW QUESTION # 119
UC has one SF org (Org A) and recently acquired a secondary company with its own Salesforce org (Org B).
UC has decided to keep the orgs running separately but would like to bidirectionally share opportunities between the orgs in near-real time.
Which 3 options should a data architect recommend to share data between Org A and Org B?
Choose 3 answers.
- A. Leverage middleware tools to bidirectionally send Opportunity data across orgs.
- B. Install a 3rd party AppExchange tool to handle the data sharing
- C. Develop an Apex class that pushes opportunity data between orgs daily via the Apex schedule.
- D. Use Salesforce Connect and the cross-org adapter to visualize Opportunities into external objects
- E. Leverage Heroku Connect and Heroku Postgres to bidirectionally sync Opportunities.
Answer: A,C,D
NEW QUESTION # 120
NTO has outgrown its current salesforce org and will be migrating to new org shortly. As part of this process NTO will be migrating all of its metadata and dat a. NTO's data model in the source org has a complex relationship hierarchy with several master detail and lookup relationships across objects, which should be maintained in target org.
What 3 things should a data architect do to maintain the relationship hierarchy during migration?
Choose 3 answers:
- A. Replace source record ID's with new record ID's from the target org in the import file.
- B. Redefine the master detail relationship fields to lookup relationship fields in the target org.
- C. Use data loader to export the data from source org and then import or Upsert into the target org in sequential order.
- D. Create a external id field for each object in the target org and map source record ID's to this field.
- E. Keep the relationship fields populated with the source record ID's in the import file.
Answer: A,C,D
NEW QUESTION # 121
A 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
- A. Review the metadata xml files for redundant fields to consolidate.
- B. Review the sharing model to determine impact on duplicate records.
- C. Determine if any integration points create records in Salesforce.
- D. Export the setup audit trail to review what fields are being used.
- E. Run key reports to determine what fields should be required.
Answer: A,B,E
NEW QUESTION # 122
A large retail B2C customer wants to build a 360-degree view of its customers for its call center agents. The customer information is currently maintained in the following systems:
1. Salesforce CRM
2. Custom billing solution
3. Customer master data management (MDM)
4. Contract management system
5. Marketing solution
What should a data architect recommend that would help uniquely identify the customer across multiple systems?
- A. Create a customer database, and use this ID in all systems
- B. Create a custom object that will serve as a cross-reference for the customer ID
- C. Create a custom field as external ID to maintain the customer ID from the MDM solution
- D. Store the Salesforce ID in all the solutions to identify the customer
Answer: D
NEW QUESTION # 123
......
Data-Architecture-And-Management-Designer Dumps PDF - Want To Pass Data-Architecture-And-Management-Designer Fast: https://prepaway.updatedumps.com/Salesforce/Data-Architecture-And-Management-Designer-updated-exam-dumps.html