[Apr 01, 2022] Ultimate Data-Architecture-And-Management-Designer Guide to Prepare Free Latest Salesforce Practice Tests Dumps [Q71-Q93]

NO.71 Which three characteristics of a Skinny table help improve report and query performance?

NO.72 What should a data architect do to provide additional guidance for users when they enter information in a standard field?

NO.73 A customer is operating in a highly reputated industry and is planning to implement SF. The customer information maintained in SF, includes the following:
* Personally, identifiable information (PII)
* IP restrictions on profiles organized by Geographic location
* Financial records that need to be private and accessible only by the assigned Sales associate.
* User should not be allowed to export information from Salesforce.
Enterprise security has mandate access to be restricted to users within a specific geography and detail monitoring of user activity. Which 3 Salesforce shield capabilities should a data architect recommend? Choose
3 answers:

NO.74 Universal containers is implementing Salesforce lead management. UC Precure lead data from multiple sources and would like to make sure lead data as company profile and location information. Which solution should a data architect recommend to make sure lead data has both profile and location information? Option

NO.75 Universal Containers has millions of cases and are running out storage. Some user groups need to have access to historical cases for up to seven years.
Which two solutions should a data architect recommend in order to minimize performance and storage issues?
(Choose two.)

NO.76 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.)

NO.77 The data architect for UC has written a SOQL query that will return all records from the Task object that do not have a value in the WhatId field:
Select id, description, Subject from Task where WhatId != NULL
When the data architect usages the query to select values for a process a time out error occurs.
What does the data architect need to change to make this query more performant?

NO.78 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?

NO.79 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

NO.80 Which two methods should be used when importing Leads into Salesforce to ensure there are no duplicate records? Choose 2 answers

NO.81 US has released a new disaster recovery (DR)policy that states that cloud solutions need a business continuity plan in place separate from the cloud providers built in data recovery solution.
Which solution should a data architect use to comply with the DR policy?

NO.82 DreamHouse Realty has an integration that creates records in a Salesforce Custom Object. The Custom Object has a field marked as required on the page layout.
DreamHouse Realty has noticed that many of the records coming from the external system are missing data in this field.
The Architect needs to ensure this field always contains data coming from the source system.
Which two approaches should the Architect take? Choose 2 answers

NO.83 UC has a legacy client server app that as a relational data base that needs to be migrated to salesforce.
What are the 3 key actions that should be done when data modeling in salesforce?
Choose 3 answers:

NO.84 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

NO.85 Universal Container (UC) has accumulated data over years and has never deleted data from its Salesforce org. UC is now exceeding the storage allocations in the org. UC is now looking for option to delete unused from the org.
Which three recommendations should a data architect make is order to reduce the number of records from the org?
Choose 3 answers

NO.86 Which two statements are accurate with respect to performance testing a Force.com application?

NO.87 Universal Containers (CU) is in the process of implementing an enterprise data warehouse (EDW). UC needs to extract 100 million records from Salesforce for migration to the EDW.
What data extraction strategy should a data architect use for maximum performance?

NO.88 Northern Trail Outfitters (NTO) uses Sales Cloud and Service Cloud to manage their sales and support processes. Some of NTOs teams are complaining they see new fields on their page and are unsure of which values need be input. NTO is concerned about lack of governance in making changes to Salesforce.
Which governance measure should a data architect recommend to solve this issue?

NO.89 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?

NO.90 Which two aspects of data does an Enterprise data governance program aim to improve?

NO.91 A manager at Cloud Kicks is importing Leads into Salesforce and needs to avoid creating duplicate records.
Which two approaches should the manager take to achieve this goal? (Choose two.)

NO.92 Universal Containers (UC) has implemented Salesforce. UC is running out of storage and needs to have an archiving solution. UC would like to maintain two years of data in Salesforce and archive older data out of Salesforce.
Which solution should a data architect recommend as an archiving solution?

NO.93 NTO need to extract 50 million records from a custom object everyday from its Salesforce org. NTO is facing query timeout issues while extracting these records.
What should a data architect recommend in order to get around the time out issue?