DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER Online Practice Questions and Answers

Get Cloudy Consulting monitors 15,000 servers, and these servers automatically record their status every 10 minutes. Because of company policy, these status reports must be maintained for 5 years. Managers at Get Cloudy Consulting need access to up to one week's worth of these status reports with all of their details.

An Architect is recommending what data should be integrated into Salesforce and for how long it should be stored in Salesforce.

Which two limits should the Architect be aware of? (Choose two.)

A. Data storage limits

B. Workflow rule limits

C. API Request limits

D. Webservice callout limits

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

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.

A Customer is migrating 10 million order and 30 million order lines into Salesforce using Bulk API. The

Engineer is experiencing time-out errors or long delays querying parents order IDs in Salesforce before

importing related order line items.

What is the recommended solution?

A. Query only indexed ID field values on the imported order to import related order lines.

B. Leverage an External ID from source system orders to import related order lines.

C. Leverage Batch Apex to update order ID on related order lines after import.

D. Leverage a sequence of numbers on the imported orders to import related order lines.

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?

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

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

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

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

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?

A. Leverage data loader platform API to load data.

B. Perform Batch job in parallel mode and reduce Batch size

C. Perform Batch job in serial mode and reduce batch size

D. Defer roll-up summary fields calculation during data migration.

What 2 data management policies does the data classification feature allow customers to classify in salesforce? Choose 2 answers:

A. Reference data policy.

B. Data governance policy.

C. Data sensitivity policy.

D. Compliance categorization policy.

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. Define external IDs for an object, migrate second database to first database, and load into Salesforce.

B. Define duplicate rules in Salesforce, and load data into Salesforce from both databases.

C. Set up staging data base, and define external IDs to merge, clean duplicate data, and load into Salesforce.

D. Define external IDs for an object, Insert data from one database, and use upsert for a second database

Northern Trail Outfitters (NTO) has a variety of customers that include householder, businesses, and

individuals.

The following conditions exist within its system:

NTO has a total of five million customers.

Duplicate records exist, which is replicated across many systems, including Salesforce. Given these

conditions, there is a lack of consistent presentation and clear identification of a customer record.

Which three option should a data architect perform to resolve the issues with the customer data?

A. Create a unique global customer ID for each customer and store that in all system for referential identity.

B. Use Salesforce CDC to sync customer data cross all systems to keep customer record in sync.

C. Invest in data duplicate tool to de-dupe and merge duplicate records across all systems.

D. Duplicate customer records across the system and provide a two-way sync of data between the systems.

E. Create a customer master database external to Salesforce as a system of truth and sync the customer data with all systems.

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 time-outs.

What is the fastest and most effective way for a data architect to solve the time-out issue?

A. Create custom fields on opportunity, and copy data from order into those custom fields and run all reports on Opportunity object.

B. Extract opportunity and order data from Salesforce, and use a third-party reporting tool to run reports outside of Salesforce.

C. Create an aggregate custom object that summarizes the monthly and yearly values into the required format for the required reports.

D. Create a skinny table in Salesforce, and copy order and opportunity fields into the skinny table and create the required reports on it.