Practice on 2024 LATEST Data-Architecture-And-Management-Designer Exam Updated 224 Questions
Download Latest Data-Architecture-And-Management-Designer Dumps with Authentic Real Exam QA's
Salesforce Data Architecture and Management Designer certification exam is designed to evaluate the candidate's knowledge and skills in various areas such as data modeling, data integration, data management, and data governance. Data-Architecture-And-Management-Designer exam consists of 60 multiple-choice questions and is timed for 105 minutes. To pass the exam, a candidate must score at least 68%.
NEW QUESTION # 19
Northern Trail Outfitters has implemented Salesforce for its sales associates nationwide. Senior management is concerned that the executive dashboards are not reliable for their real-time decision-making. On analysis, the team found the following issues with data entered in Salesforce:
1. Information in certain records is incomplete.
2. Incorrect entry in certain fields causes records to be excluded in report filters.
3. Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues? (Choose three.)
- A. Leverage Salesforce features, such as validation rules, to avoid incomplete and incorrect records.
- B. Build a sales data warehouse with purpose-built data marts for dashboards and senior management reporting.
- C. Design and implement data-quality dashboard to monitor and act on records that are incomplete or incorrect.
- D. Explore third-party data providers to enrich and augment information entered in Salesforce.
- E. Periodically export data to cleanse data and import them back into Salesforce for executive reports.
Answer: A,B,D
NEW QUESTION # 20
UC has migrated its Back-office data into an on-premise database with REST API access. UC recently implemented Sales cloud for its sales organization. But users are complaining about a lack of order data inside SF.
UC is concerned about SF storage limits but would still like Sales cloud to have access to the data.
Which design patterns should a data architect select to satisfy the requirement?
- A. Build a UI for the on-premise system and iframe it in Salesforce
- B. Migrate and persist the data in SF to take advantage of native functionality.
- C. Develop a bidirectional integration between the on-premise system and Salesforce.
- D. Use SF Connect to virtualize the data in SF and avoid storage limits.
Answer: D
NEW QUESTION # 21
Northern trail Outfitters (NTO) uses Sales Cloud and service Cloud to manage sales and support processes. Some of NTOs team are complaining they see new fields on their page 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 field as required.
- B. Create validation rules with error messages to explain why the fields is used
- C. Create and manage a data dictionary and ups a governance process for changes made to common objects.
- D. Create reports to identify which users are leaving blank, and use external data sources o agreement the missing data.
Answer: C
NEW QUESTION # 22
DreamHouse Realty 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.
There will be a large amount of time entry records to be loaded regularly from an external system into Salesforce.
- A. Load all data using external IDs to link to parent records.
- B. Calculate summary values instead of Roll-Up by using workflow.
- C. Load all data after deferring sharing calculations.
- D. Calculate summary values instead of Roll-Up by using triggers.
Answer: C
NEW QUESTION # 23
In 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
- A. Use workbench to update files within systems.
- B. Build synchronization reports and dashboards.
- C. Establish an MDM strategy to outline a single source of truth.
- D. Integrate Salesforce with the ERP environment.
Answer: B,C
NEW QUESTION # 24
Northern Trail Outfitters has these simple requirements for a data export process:
File format should be in CSV.
Process should be scheduled and run once per week.
The expert should be configurable through the Salesforce UI.
Which tool should a data architect leverage to accomplish these requirements?
- A. Data export wizard
- B. Bulk API
- C. Data loader
- D. Third-party ETL tool
Answer: A
NEW QUESTION # 25
Universal Containers (UC) is using Salesforce Sales & Service Cloud for B2C sales and customer service but they are experiencing a lot of duplicate customers in the system.
Which are two recommended approaches for UC to avoid duplicate data and increase the level of data quality?
- A. Use Data.com Clean
- B. Use an Enterprise Service Bus.
- C. Use Duplicate Management.
- D. Use a data wharehouse.
Answer: A,C
NEW QUESTION # 26
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. Create another field to copy data from encrypted field and use this field in export
- C. Set a standard profile for Data Migration user, and assign view encrypted data
- D. Leverage Apex class to decrypt data before exporting it.
Answer: A
NEW QUESTION # 27
Universal Containers is implementing Sales Cloud for patient management and would like to encrypt sensitive patient records being stored in files.
Which solution should a data architect recommend to solve this requirement?
- A. Use classic encryption to encrypt files
- B. Implement Shield Platform Encryption to encrypt files
- C. Implement third-party AppExchange app to encrypt files
- D. Store files outside of Salesforce and access them in real time
Answer: B
Explanation:
Explanation/Reference: https://www.salesforce.com/content/dam/web/en_us/www/documents/reports/wp-platform- encryption-architecture.pdf
NEW QUESTION # 28
Which two statements are accurate with respect to performance testing a Force.com application?
- A. Application performance benchmarked in a sandbox can also be expected in production.
- B. All Force.com applications must be performance tested in a sandbox as well as production.
- C. A performance test plan must be created and submitted to Salesforce customer support.
- D. Applications with highly customized code or large volumes should be performance tested.
Answer: C,D
NEW QUESTION # 29
Universal Containers (UC) needs to run monthly and yearly reports on opportunities and orders for sales reporting. There are 5 million opportunities and 10 million orders. Sales users are complaining that the report will regularly timeout.
What is the fastest and most effective way for a data architect to solve the time-out issue?
- A. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.
- B. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.
- C. Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on It.
- D. Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.
Answer: B
NEW QUESTION # 30
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. Enable and use the Query Plan tool in the developer console
- B. Use Salesforce's query optimizer to analyze the query in the developer console
- C. Use Splunk to query the system logs looking for transaction time and CPU usage
- D. Open a ticket with Salesforce support to retrieve transaction logs to be analyzed for processing time
Answer: B
Explanation:
Explanation
Explanation/Reference: https://trailhead.salesforce.com/content/learn/modules/database_basics_dotnet/ writing_efficient_queries
NEW QUESTION # 31
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. Integrate Salesforce with the ERP environment.
- B. Utilize an MDM strategy to outline a single source of truth.
- C. Utilize workbench to update files within systems.
- D. Build synchronization reports and dashboards.
Answer: A,B
NEW QUESTION # 32
Universal Container is Implementing salesforce and needs to migrate data from two legacy systems. UC would like to clean and duplicate data before migrate to Salesforce.
Which solution should a data architect recommend a clean migration?
- A. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.
- B. Define external IDs for an object, Insert data from one database, and use upsert for a second database
- C. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.
- D. Define external IDs for an object, migrate second database to first database, and load into Salesforce.
Answer: B
NEW QUESTION # 33
Universal Containers is exporting 40 million Account records from Salesforce using Informatica Cloud. The ETL tool fails and the query log indicates a full table scan time-out failure. What is the recommended solution?
- A. Modify the export job header to specify Export-in-Parallel.
- B. Modify the export query with LIMIT clause with Batch size 10,000.
- C. Modify the export query that includes standard index fields(s).
- D. Modify the export job header to specify Sforce-Enable-PKChunking.
Answer: D
NEW QUESTION # 34
NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.
What should a data architect recommend in order to get around the time out issue?
- A. Use a custom auto number and formula field and use that to chunk records while extracting data.
- B. Use ETL tool for extraction of records.
- C. The REST API to extract data as it automatically chunks records by 200.
- D. Ask SF support to increase the query timeout value.
Answer: A
NEW QUESTION # 35
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. Validate the format of phone numbers and postal codes by using Apex.
- B. Create data-quality dashboards by using an app from the AppExchange.
- C. Enable users to import their data using the Salesforce Import tools.
- D. Use a 3rd-party solution from the AppExchange for data uploads.
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION # 36
Ursa Major Solar has 4 million rows of data in Salesforce that are used in reports to assess historical trends. Both performance and data storage limits have become an issue.
Which two strategies are appropriate when discussing the issue with stakeholders? (Choose two.)
- A. Utilize scheduled batch Apex to copy aggregate information into a custom object and delete the original records.
- B. Utilize Data Loader to extract data, aggregate it, and write it back to a custom object, then delete the original records.
- C. Configure the Salesforce Archiving feature to archive older records and remove them from the data storage limits.
- D. Combine Analytics Snapshots with a purging plan by reporting on the snapshot data and deleting the original records.
Answer: A,C
NEW QUESTION # 37
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. Utilize Salesforce duplicate management.
- C. Utilize the private sharing model.
- D. Use validation rules on new record create and edit.
Answer: B,D
NEW QUESTION # 38
Universal Containers (UC) wants to capture information on how data entities are stored within the different applications and systems used within the company. For that purpose, the architecture team decided to create a data dictionary covering the main business domains within UC. Which two common techniques are used building a data dictionary to store information on how business entities are defined?
- A. Use the Salesforce Metadata API.
- B. Use Salesforce Object Query Language.
- C. Use an entity relationship diagram.
- D. Use a data definition language.
Answer: A,C
NEW QUESTION # 39
UC is preparing to implement sales cloud and would like to its users to have read only access to an account record if they have access to its child opportunity record. How would a data architect implement this sharing requirement between objects?
- A. Create a criteria-based sharing rule.
- B. Implicit sharing will automatically handle with standard functionality.
- C. Add appropriate users to the account team.
- D. Create an owner-based sharing rule.
Answer: B
NEW QUESTION # 40
Ursa Major Solar has the following two systems:
- Salesforce
- On-premise ERP system
Opportunity records need to be copied 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.
An Architect needs to recommend a real-time approach that fulfills these requirements.
Which recommendation is appropriate?
- A. Have an ERP poll Salesforce nightly and bring in the desired Opportunities.
- B. Create a workflow rule with Outbound Messaging that sends Opportunity data.
- C. Implement a Master Data Management system to determine system of record.
- D. Implement an hourly integration to send Salesforce Opportunities to the ERP system.
Answer: B
NEW QUESTION # 41
Universal 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
- A. Use the Force.com Workbench to export the data.
- B. Schedule jobs to export and delete using an ETL tool.
- C. Schedule jobs to export and delete using the Data Loader.
- D. Schedule a weekly export file from the Salesforce UI.
Answer: B,C
NEW QUESTION # 42
......
Authentic Data-Architecture-And-Management-Designer Exam Dumps PDF - Jun-2024 Updated: https://www.dumpsquestion.com/Data-Architecture-And-Management-Designer-exam-dumps-collection.html
Data-Architecture-And-Management-Designer Dumps Special Discount for limited time Try FOR FREE: https://drive.google.com/open?id=1-l7MIUo3WjUhS-R1IyZUkT5Z2kGCoykP