[Apr-2022] Dumps Practice Exam Questions Study Guide for the Data-Architecture-And-Management-Designer Exam [Q23-Q42] : Free Exam Dumps Collection : http://free.examcollectionpass.com

NEW QUESTION 23
Universal Containers (UC) has over 10 million accounts with an average of 20 opportunities with each account. A Sales Executive at UC needs to generate a daily report for all opportunities in a specific opportunity stage.
Which two key considerations should be made to make sure the performance of the report is not degraded due to large data volume?

Number of queries running at a time.

Number of joins used in report query.

Number of records returned by report query.

Number of characters in report query.

NEW QUESTION 24
Universal Containers wants to implement a data -quality process to monitor the data that users are manually entering into the system through the Salesforce UI. Which approach should the architect recommend?

Allow users to import their data using the Salesforce Import tools.

Utilize a 3rd -party solution from the AppExchange for data uploads.

Utilize an app from the AppExchange to create data -quality dashboards.

Use Apex to validate the format of phone numbers and postal codes.

NEW QUESTION 25
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

AppExchange Apps

Wave Analytics

Weekly Snapshots

Setup Audit Trails

NEW QUESTION 26
Universal Container (US) is replacing a home grown CRM solution with Salesforce, UC has decided to migrate operational (Open and active) records to Salesforce, while keeping historical records in legacy system, UC would like historical records to be available in Salesforce on an as needed basis.
Which solution should a data architect recommend to meet business requirement?

Leverage real-time integration to pull records into Salesforce.

Bring all data Salesforce, and delete it after a year.

Leverage mashup to display historical records in Salesforce.

Build a chair solution to go the legacy system and display records.

NEW QUESTION 27
Cloud Kicks has the following requirements:
– Data needs to be sent from Salesforce to an external system to generate invoices from their Order Management System (OMS).
– A Salesforce administrator must be able to customize which fields will be sent to the external system without changing code.
What are two approaches for fulfilling these requirements? (Choose two.)

A set<sobjectFieldset> to determine which fields to send in an HTTP callout.

An Outbound Message to determine which fields to send to the OMS.

A Field Set that determines which fields to send in an HTTP callout.

Enable the field -level security permissions for the fields to send.

NEW QUESTION 28
Universal Containers wants their Shipment custom object to always relate to a Container, a Sender, and a Receiver (all separate custom objects). If a Shipment is currently associated with a Container, Sender, or Receiver, deletion of those records should not be allowed.
They also want separate sharing models on each custom object. What approach should an architect take to fulfill these requirements?

Create a required Lookup relationship to each of the three parent records.

Create two Master -Detail and one Lookup relationship to the parent records.

Create a Master -Detail relationship to each of the three parent records.

Use a VLOOKUP formula field to associate the Shipment to each parent record.

NEW QUESTION 29
Northern Trail outfitters in migrating to salesforce from a legacy CRM system that identifies the agent relationships in a look-up table.
What should the data architect do in order to migrate the data to Salesfoce?

Create custom objects to store agent relationships.

Migrate to Salesforce without a record owner.

Assign record owner based on relationship.

Migrate the data and assign to a non-person system user.

NEW QUESTION 30
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 Salesforce.com?

Load all data using external IDs to link to parent records.

Use workflow to calculate summary values instead of Roll -Up.

Use triggers to calculate summary values instead of Roll -Up.

Load all data after deferring sharing calculations.

NEW QUESTION 31
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?

Use the SOAP API to export data.

Utilize the Bulk API to export the data.

Use GZIP compression to export the data.

Schedule a Batch Apex job to export the data.

NEW QUESTION 32
What makes Skinny tables fast? Choose three answers.

They do not include soft-deleted records

They avoid resource intensive joins

Their tables are kept in sync with their source tables when the source tables are modified

They can contain fields from other objects

They support up to a max of 100 of columns

NEW QUESTION 33
Cloud Kicks has a system environment that is complex, and they plan on creating a data governance program for the first time.
What are two initial actions Cloud Kicks should take to initiate an assessment of data architecture?
(Choose two.)

Work with database administrators to assess current database performance metrics.

Work with executive sponsorship to assess enterprise data strategy and goals.

Work with IT program managers to assess current velocity of projects in the pipeline.

Work with business units and IT to assess current operational systems and data models.

NEW QUESTION 34
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 de-normalizing this data model into a single Conference object with a Venue picklist? Choose 2 answers

Standard list view in-line editing.

Limitations on master -detail relationships.

Org data storage limitations.

Bulk API limitations on picklist fields.

NEW QUESTION 35
Universal Containers is creating a new B2C service offering for consumers to ship goods across continents. This is in addition to their well-established B2B offering. Their current Salesforce org uses the standard Account object to track B2B customers. They are expecting to have over 50,000,000 consumers over the next five years across their 50 business regions. B2C customers will be individuals. Household data is not required to be stored. What is the recommended data model for consumer account data to be stored in Salesforce?

Use the Account object with Person Accounts and a new B2C page layout.

Use the Account object with a newly created Record Type for B2C customers.

Create a new picklist value for B2C customers on the Account Type field.

Use 50 umbrella Accounts for each region, with customers as associated Contacts.

NEW QUESTION 36
A customer is facing locking issued when importing large data volumes of order records that are children in a master-detail relationship with the Account object. What is the recommended way to avoid locking issues during import?

Change the relationship to Lookup and update the relationship to master-detail after import.

Import Account records first followed by order records after sorting order by OrderID.

Import Account records first followed by order records after sorting orders by AccountID.

Import Order records and Account records separately and populate AccountID in orders using batch Apex.

NEW QUESTION 37
What are two valid metadata types that should be included to document the data architecture of a Salesforce org? Choose 2 answers

RecordType

Document

CustomField

SecuritySettings

NEW QUESTION 38
During the implementation of Salesforce a customer has the following requirements for Sales Order:
1. Sales Order information needs to be shown to users in Salesforce.
2. Sales Orders are maintained in the on-premise enterprise resource planning (ERP).
3. Sales Order information has more than 150 million records.
4. Sales Orders will not be updated in Salesforce.
What should a data architect recommend for maintaining Sales Orders in Salesforce?

Use external objects to maintain Sales Orders in Salesforce.

Use custom big objects to maintain Sales Orders in Salesforce.

Use Standard Order object to maintain Sales Orders in Salesforce.

Use custom objects to maintain Sales Orders in Salesforce.

NEW QUESTION 39
A phased Salesforce rollout is planned. Three deployments will be spread out over 12 months, and the requirements have been carefully documented.
An Architect needs to trace back configuration changes to the requirements.
Which two approaches should the Architect use? (Choose two.)

Utilize the Force.com IDE to save the metadata files in source control.

Analyze the setup audit trail for configuration changes.

Enter the business purpose into the Description of each field.

Maintain a data dictionary with the justification for each field.

NEW QUESTION 40
Universal Container (UC) stores 10 million rows of inventory data in a cloud database, As part of creating a connected experience in Salesforce, UC would like to this inventory data to Sales Cloud without a import. UC has asked its data architect to determine if Salesforce Connect is needed.
Which three consideration should the data architect make when evaluating the need for Salesforce Connect?

You want real-time access to the latest data, from other systems.

You have a large amount of data and would like to copy subsets of it into Salesforce.

You need to expose data via a virtual private connection.

You have a large amount of data that you don’t want to copy into your Salesforce org.

You need to small amounts of external data at any one time.

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

Use the Force.com Workbench to export the data.

Schedule a weekly export file from the Salesforce UI.

Schedule jobs to export and delete using an ETL tool.

Schedule jobs to export and delete using the Data Loader.

NEW QUESTION 42
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?

Implement a Contact Conference junction object with master detail relationship to both contact and conference__c.

Create a master detail relationship field on the Contact object.

Create a master detail relationship field on the Conference object.

Create a lookup relationship field on contact object.

[Apr-2022] Dumps Practice Exam Questions Study Guide for the Data-Architecture-And-Management-Designer Exam [Q23-Q42]

Difficulty in writing Data-Architecture-And-Management-Designer Exam