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.)
A. Work with database administrators to assess current database performance metrics.
B. Work with executive sponsorship to assess enterprise data strategy and goals.
C. Work with IT program managers to assess current velocity of projects in the pipeline.
D. Work with business units and IT to assess current operational systems and data models.
DreamHouse Realty needs an Architect to develop a solution that will integrate data and resolve duplicates and discrepancies between Salesforce and one or more external systems.
What are two important questions the Architect should answer when determining whether to use Master Data Management in the solution? (Choose two.)
A. Are the systems cloud-based or on-premise?
B. Does the system of record change for different tables?
C. How many systems are integrating with each other?
D. Will Salesforce replace a legacy system?
Universal Containers has a custom object with millions of rows of data.
When executing SOQL queries, which three options prevent a query from being selective? (Choose three.)
A. Utilizing NOT and != operators.
B. Utilizing a custom index on a deterministic formula field.
C. Using leading % wildcards.
D. Performing large loads and deletions.
E. Using trailing % wildcards.
Get Cloudy Consulting uses Salesforce for tracking opportunities (Opportunity) and currently has the following environment:
1.
An internal ERP system is in place for tracking services and invoicing.
2.
The ERP system supports SOAP API and CData for bi-directional integration between Salesforce and the ERP system.
3.
950,000 opportunities exist; for each opportunity, the company sends one invoice per month during a 12-month period.
Get Cloudy Consulting sales reps must view current invoice status and invoice amount from the opportunity page.
When creating an object to model invoices, what should the Architect suggest, considering performance and data storage space?
A. Create an external object Invoice_x with a Lookup relationship with Opportunity.
B. Create a custom object Invoice_c with a Lookup relationship with Opportunity.
C. Retrieve the current status from the ERP by using Streaming API, and display on the Opportunity page.
D. Create a custom object Invoice_c with a master-detail relationship with Opportunity.
Two million Opportunities need to be loaded in different batches into Salesforce using the Bulk API in
parallel mode.
What should an Architect consider when loading the Opportunity records?
A. Use the Name field values to sort batches.
B. Order batches by Auto-number field.
C. Create indexes on Opportunity object text fields.
D. Group batches by the AccountId field.
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?
A. Have Salesforce poll the OMS nightly and bring in the desired Accounts and Contacts.
B. Use an integration tool to send OMS Accounts and Contacts to Salesforce.
C. Utilize the Streaming API to send Account and Contact data from Salesforce to the OMS.
D. Use a Master Data Management strategy to reconcile Leads, Accounts, and Contacts.
Ursa Major Solar's legacy system has a quarterly accounts receivable report that compiles data from the following:
1.
Accounts
2.
Contacts
3.
Opportunities
4.
Orders
5.
Order Line Items
Which issue will an architect have when implementing this in Salesforce?
A. Custom report types CANNOT contain Opportunity data.
B. Salesforce does NOT support Orders or Order Line Items.
C. Salesforce does NOT allow more than four objects in a single report type.
D. A report CANNOT contain data from Accounts and Contacts.
Universal Containers (UC) is implementing a new customer categorization process where customers should be assigned to a Gold, Silver, or Bronze category if they've purchased UC's new support service. Customers are expected to be evenly distributed across all three categories. Currently, UC has around 500,000 customers, and is expecting 1% of existing non-categorized customers to purchase UC's new support service every month over the next five years. What is the recommended solution to ensure longterm performance, bearing in mind the above requirements?
A. Implement a new global picklist custom field with Gold, Silver, and Bronze values and enable it in Account.
B. Implement a new picklist custom field in the Account object with Gold, Silver, and Bronze values.
C. Implement a new Categories custom object and a master-detail relationship from Account to Category.
D. Implement a new Categories custom object and create a lookup field from Account to Category.
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.
What makes Skinny tables fast? Choose three answers.
A. They do not include soft-deleted records
B. They avoid resource intensive joins
C. Their tables are kept in sync with their source tables when the source tables are modified
D. They can contain fields from other objects
E. They support up to a max of 100 of columns
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Salesforce exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your DATA-ARCHITECTURE-AND-MANAGEMENT-DESIGNER exam preparations and Salesforce certification application, do not hesitate to visit our Vcedump.com to find your solutions here.