Page No | 1
Salesforce
DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Exam
DATA ARCHITECTURE AND MANAGEMENT DESIGNER
Product: Demo File
For More Information:
[Link]
[Link]
m/
Question: 1
A 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
A. Data storage limits
B. API Request limits
C. Web service callout limits
D. Workflow rule limits
Answer: A, B
Question: 2
A 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?
A. Create a Permission Set to hide old data from Sales Reps.
B. Use Batch Apex to archive old data on a rolling nightly basis.
C. Archive and purge old data from Salesforce on a monthly basis.
D. Set data access to Private to hide old data from Sales Reps.
Answer: C
Question: 3
Universal 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
A. Analytics/BI Owners
B. Data Domain Stewards
C. Salesforce Administrators
D. Operational Data Users
Answer: A, B
Question: 4
Universal 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
A. Engage with IT program managers to assess current velocity of projects in the pipeline.
B. Engage with database administrators to assess current database performance metrics.
C. Engage with executive sponsorship to assess enterprise data strategy and goals.
D. Engage with business units and IT to assess current operational systems and data models.
[Link]
m/
Answer: C, D
Question: 5
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. Determine if any integration points create records in Salesforce.
C. Run key reports to determine what fields should be required.
D. Export the setup audit trail to review what fields are being used.
E. Review the sharing model to determine impact on duplicate records.
Answer: A, C, E
Question: 6
To 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?
A. Errors with duplicate external Id values within the same CSV file.
B. Errors with records being updated and inserted in the same CSV file.
C. Errors when a duplicate Contact name is found cause upsert to fail.
D. Errors with using the wrong external Id will cause the load to fail.
Answer: A
Question: 7
Universal 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?
A. Enable field history tracking on the Case object.
B. Create a report on Case analytic snapshots.
C. Install AppExchange packages for available reports.
D. Create Contact and Opportunity Reports and Dashboards.
Answer: A
Question: 8
Universal 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?
A. Opportunity analytic snapshot
B. Case SLA performance report
C. Lead conversion rate report
D. Sales KPI Dashboard
Answer: D
Question: 9
In their legacy system. Universal Containers has a monthly accounts receivable report that
compiles data from Accounts, Contacts, Opportunities, Orders. and Order Line Items. What
[Link]
m/
difficulty will an architect run into when implementing
this in Salesforce?
A. Salesforce allows up to four objects in a single report type.
B. Salesforce does not support Orders or Order Line Items.
C. A report cannot contain data from Accounts and Contacts.
D. Custom report types cannot contain Opportunity data.
Answer: A
Question: 10
Universal 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
A. Create a report in an external system combining Salesforce Account data and Invoice
data from the ERP.
B. Create a report combining data from the Account standard object and the Invoices external
object.
C. Create a Visualforce page combining Salesforce Account data and Invoice external object
data.
D. Create a separate Salesforce report for Accounts and Invoices and combine them in a
dashboard.
Answer: A, C
Question: 11
Universal 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?
A. Use a Lead standard report and filter on the IsDeleted standard field.
B. Use a Converted Lead report to display data on Leads that have been deleted.
C. Query Salesforce with the queryAll API method or using the ALL ROWS SOQL keywords.
D. Send data to a Data Warehouse and mark Leads as deleted in that system.
Answer: D
Question: 12
Universal 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
A. AppExchange Apps
B. Wave Analytics
C. Weekly Snapshots
D. Setup Audit Trails
Answer: A, B
[Link]
m/
Question: 13
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 the SOAP API to export data.
B. Utilize the Bulk API to export the data.
C. Use GZIP compression to export the data.
D. Schedule a Batch Apex job to export the data.
Answer: C
Question: 14
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. Create a Custom Object Individual Consumer c to load all individual consumers.
B. Load all individual consumers as Account records and avoid using the Contact object.
C. Load one Account record and one Contact record for each individual consumer.
D. Create one Account and load individual consumers as Contacts linked to that one Account.
Answer: C
Question: 15
Universal 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 [Link]?
A. Load all data using external IDs to link to parent records.
B. Use workflow to calculate summary values instead of Roll -Up.
C. Use triggers to calculate summary values instead of Roll -Up.
D. Load all data after deferring sharing calculations.
Answer: D
Thank You for Trying Our Product
[Link]
m/
Our Certification Exam Features:
★ More than 99,900 Satisfied Customers Worldwide
★ Average 99.9%Success Rate
★Free Update to match latest and real exam scenarios
★Instant Download Access! No Setup required.
★ Questions & Answers are downloadable in PDF format.
★ Multi-Platform capabilities - Windows, Laptop, Mac, Android, iPhone, iPod, iPad
★ 100% Guaranteed Success.
★ Fast, helpful support 24x7
View Certification Exam page for Full Product:
[Link]
[Link]
m/