[Q47-Q71] Pass Data-Architecture-And-Management-Designer Exam in First Attempt Guaranteed 2023 Dumps!

Q47. The head of sales at Get Cloudy Consulting wants to understand key relevant performance figures and help managers take corrective actions where appropriate.
What is one reporting option Get Cloudy Consulting should consider?

Q48. Get Cloudy Consulting is migrating their legacy system’s users and data to Salesforce. They will be creating
15,000 users, 1.5 million Account records, and 15 million Invoice records. The visibility of these records is controlled by a 50 owner and criteria-based sharing rules.
Get Cloudy Consulting needs to minimize data loading time during this migration to a new organization.
Which two approaches will accomplish this goal? (Choose two.)

Q49. UC has the following system:
* Billing system.
* Customer support system.
* CRM system.
US has been having trouble with business intelligence across the different systems.
Recently US implemented a master data management (MDM) solution that will be the system of truth for the customer records.
Which MDM data element is needed to allow reporting across these systems?

Q50. 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.

Q51. 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.

Q52. 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?

Q53. Northern Trail Outfitter has implemented Salesforce for its associates nationwide, Senior management is concerned that the executive dashboard are not reliable for their real-time decision-making. On analysis , the team the following issues with data entered in Salesforce.
Information in certain records is incomplete.
Incorrect entry in certain fields causes records to be excluded in report fitters.
Duplicate entries cause incorrect counts.
Which three steps should a data architect recommend to address the issues?

Q54. A company uses Salesforce, a cloud-based ERP system, and an on-premise Order Management System (OMS). This company requires a solution that uses Salesforce as the system of record for Leads and the OMS as the system of record for Account and Contacts.
Additionally, the company wants Accounts and Contacts to be able to maintain their names in each system (i.e., “”Jane Doe””; in the OMS and “”Jannie Doe””‘ in Salesforce), but wants to have a consolidated data store which links referenced records across the systems.
Which suggestion should the Architect provide to the company to meet this goal?

Q55. Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing, UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing “lock errors” consistently.
What should a data architect recommend to mitigate these errors?

Q56. Cloud Kicks needs to optimize data stewardship engagement for a Salesforce instance.
Before proposing design recommendations, the Data Architect is first assessing relevant areas of Salesforce.
Which three areas are appropriate to assess? (Choose three.)

Q57. 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.

What should the Architect consider in this situation?

Q58. 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:

Q59. Universal Containers has millions of rows of data in Salesforce that are being used in reports to evaluate historical trends. Performance has become an issue, as well as data storage limits. Which two strategies should be recommended when talking with stakeholders?

Q60. Ursa Major Solar’s legacy system has a quarterly accounts receivable report that compiles data from the following:
– Accounts
– Contacts
– Opportunities
– Orders
– Order Line Items
Which issue will an architect have when implementing this in Salesforce?

Q61. Developers at Universal Containers need to build a report for the business which displays Accounts opened in the past year grouped by industry. This report will also include information from contacts, opportunities, and orders. There are several million Accounts in the system. Which two options should be recommended to make this report perform well and satisfy the business need?

Q62. A customer needs a sales model that allows the following:
1. Opportunities need to be assigned to sales people based on the zip code.
2. Each sales person can be assigned to multiple zip codes.
3. Each zip code is assigned to a sales area definition. Sales is aggregated by sales area for reporting.
What should a data architect recommend?

Q63. 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.

Q64. Universal 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

Q65. UC has millions of case records with case history and SLA data. UC’s compliance team would like historical cases to be accessible for 10 years for Audit purpose.
What solution should a data architect recommend?

Q66. 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?

Q67. Get Cloudy Consulting uses an invoicing system that has specific requirements. One requirement is that attachments associated with the Invoice_c custom object be classified by Types (i.e., “”Purchase Order””, “”Receipt””, etc.) so that reporting can be performed on invoices showing the number of attachments grouped by Type.
What should an Architect do to categorize the attachments to fulfill these requirements?

Q68. Universal Containers (UC) has a Salesforce org with multiple automated processes defined for group membership processing. UC also has multiple admins on staff that perform manual adjustments to the role hierarchy. The automated tasks and manual tasks overlap daily, and UC is experiencing “lock errors” consistently.
What should a data architect recommend to mitigate these errors?

Q69. Universal 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?

Q70. UC has a roll-up summary field on Account to calculate the count of contacts associated with an account.
During the account load, SF is throwing an “Unable to lock a row” error.
Which solution should a data architect recommend, to resolve the error?

Q71. A company has 12 million records, and a nightly integration queries these records.
Which two areas should a Data Architect investigate during troubleshooting if queries are timing out?
(Choose two.)