Salesforce Apex Trigger Interview Question Explained

Using the Setup menu, the Universal Containers company activated data sync (replication) in the Tableau CRM settings. After running the sync, they notice that the aggregate sum of a field within their dataset is different than what they manually calculated by summing the same data in the Salesforce object from which the dataset was populated. Which two differences in the newly synced data can explain this? (Choose two.)

A. Differences involving trigger-updated fields B. Differences involving permanently deleted records C. Differences involving workflow-upda...

A Tableau CRM consultant is asked to add a new SalesTax field to a Product Sales dataset. The formula to calculate SalesTax is (SubTotal"CountyTax). Which node should the consultant use in a Dataflow to calculate and insert SalesTax to the dataset?

A. update B. append C. join D. transform Suggest answer: D Reference:

Universal Containers (UC) sells mostly to the North American market. A consultant is studying the spending habits of UC's customers where the consultant collects the data with a Region column that is 94% North America, 3% Rest of the World, 3% null. What is the appropriate action to take?

A. Leave the data as-is, let Discovery deal with nulls. B. Replace the nulls with "Rest of the World" since Discovery rejects nul...

A consultant built a Tableau CRM app for the Sales Operations team. The Sales Operations team wants to share their app with other people at the company. The consultant recommends distributing the app as a Tableau CRM template app. What can the consultant do to give the Sales team more choices and options with future apps that are generated from the Sales Operations app?

A. Create a configuration wizard for the app. B. Ensure the Sales team has the necessary permissions to customize their apps. C. Update con...

To model customer value, a consultant decided to aggregate the amount ($) individual customers spent over a 2-year span. With reference to the outcome variable, which action should the consultant take?

A. Create five bins of revenues, ranging from Very High Value, High Value, Average Value, Low Value, and Very Low Value in data prep. B. Cr...

Universal Containers is evaluating the connection mode for the objects in their local Salesforce connector. They want to only sync updated and new records from the Order object, but they have some formula fields on the object and want to ensure those are updated weekly. Which connection mode is best suited for this purpose?

A. Full Sync B. Incremental Sync C. Periodic Full Sync D. Periodic Incremental Sync Suggest answer: D Reference:

After the initial creation of a story, the first story insight explains 93% of the variation of the outcome variable. This is unusually high. What is the most likely reason for this?

A. The dataset contains too many rows. B. The dataset contains multiple dominant values. C. The outcome variable is causing data leakage. D...

A Tableau CRM consultant has created three recipes that each produce a dataset. • Recipe1 creates Dataset1. • Recipe2 created Dataset2. • Recipe3 creates Dataset3. Recipe3 is dependent on Dataset1, while Recipe1 and Recipe2 have no dependencies. How should the consultant implement the recipe schedule?

A. Make Recipe1 and Recipe2 time based, but make Recipe3 event based when the local Salesforce connector has completed. B. Make all three r...

Which chart type is best suited to track progress of sales revenue that is realized versus the target?

A. Pie chart B. Pivot table C. Flat gauge D. Bar chart Suggest answer: C Reference:

A consultant is creating a Churn Prediction model to identify customers who did not renew their contract. What is the appropriate action to take?

A. For the Churn Reason field, enable the "This variable contains sensitive data" box because it may contain sensitive customer b...

The Universal Containers Sales team is looking to build a dashboard that shows the total revenue from their top 10 accounts (based on revenue) and make it dynamic with the filters of the dashboard. What two steps are required to accomplish this? (Choose two.)

A. Create a query with a selection based interaction as a filter using the limited query to pass in the 10 Account Id's. B. Create a qu...

An Einstein Analytics Consultant is working with a subscriptions based company to build a dashboard to understand customer renewals. Each subscription is captured as a Closed Won Opportunity within Salesforce and a single Account can only have one active subscription. Unfortunately, the Opportunity record does not specify whether it is a renewal or a net new subscription. Which data transformation should be used to determine if a subscription is new or a renewal?

A. computeRelative B. computeExpression C. augment D. flatten Suggest answer: D Reference:

A company's Salesforce org has multi-currency enabled. This company's business intelligence team used Tableau CRM to build a dataflow that creates a dataset, "OpportunityDataSet". This dataset is populated with data extracted from the standard object, Opportunity. One of the extracted fields is the standard field, Amount. If a user explores the "OpportunityDataSet" in Tableau CRM, in which currency will the Amount values be shown?

A. In the integration user's currency B. In the currency that is set on the "currency" attribute in the dataflow C. In the cu...

A consultant is working with the client to define goals and metrics for a dashboard that will be built. The consultant is in the design phase prior to starting the actual build. Which two design considerations should be determined at this time? (Choose two.)

A. How to get as much information as possible onto one page. B. How to quickly convey key information. C. Which colors to use and how to us...

A Tableau CRM consultant develops a dashboard called SalesPerformance_1 in a sandbox environment. To deploy the recipe, the consultant creates a package in workbench. What is the correct meta data reference in the xml file?

A. SalesPerformance_1 EADashboard B. SalesPerformance_1 WaveDashboard C. SalesPerformance_1 EdgeDashboard D. SalesPerformance_1 Suggest an...

A Tableau CRM Consultant is implementing encryption for a customer. Which two statements about Tableau CRM Encryption are true? (Choose two.)

A. By default, the same keys are used to encrypt data in Tableau CRM as are used to encrypt data in Salesforce objects. B. The customer...

A Tableau CRM consultant created a dashboard that went through review. A few charts were added and removed in the process. The dashboard is now approved for production. Which best practice should be done before releasing the dashboard?

A. Remove the redundant queries to ensure dashboard performance. B. Apply conditional formatting on the new charts. C. Rename all the queri...

The Universal Containers company used Tableau CRM to create two datasets: ✑ Dataset A: contains a list of activities with an "activityID" dimension and a "userID" dimension ✑ Dataset B: contains a list of users with a "userID" dimension The team wants to delete from Dataset A all activities related to users in Dataset B. How can a Tableau CRM Consultant help them achieve this?

A. Use an external ETL tool to extract both datasets and delete records. B. Use a combination of dataflow transformations: "augment...

A customer has a dataset consisting of over 300 unique product names. They request a prediction model with the product names included. Which action should the Einstein Consultant take?

A. Adjust the model to eliminate extreme values in the outcome variable. B. Use SKU numbers rather than product names to increase clarity. ...

A consultant built a very useful Tableau CRM app for Sales Operations and they want to share its contents with the rest of Global Sales. However, they do not want to add everyone in Sales to their app. The consultant recommends extending the Sales Operations app and distributing it as a Tableau CRM template app, but needs to locate specific information to get started. What is the REST API URL where the consultant can find current template apps?

A. /services/data/v##.#/analytics/projects B. /services/data/v##.#/analytics/wizard C. /services/data/v##.#/wave/apps D. /services/data/v##...

Older Posts Home

Popular Posts

Universal Containers uses a custom object to track Projects. When the status of a Project is changed from "In Progress" to "On Hold", the business wants the Project owner to be automatically assigned to an "On Hold" queue. What capability can be used to accomplish this?

Where can a developer identify the time taken by each process in a transaction using Developer Console log inspector?

The client asks a Tableau CRM Consultant to build a dashboard with a chart that shows revenue and quantity of units sold. Which type of Combo Chart can the consultant use?

Universal Containers (UC) sells a subscription Product, Monitoring Service. Although it is often sold in a bundle, UC wants to ensure that sales reps leave the quantity as 1 when it is sold outside of a bundle. Which solution can UC apply?

Identify the differences between Apex and the other programming languages. (Select all that apply.) ✑ Apex runs in a multitenant environment. ✑ Apex performs uncontrolled program invocations. ✑ Apex is case-insensitive. ✑ Apex can be processed on any platform.

Ursa Major Solar (UMS) recently went through a major rebranding effort that resulted in a new company logo along with new brand colors. UMS wants to update brand colors across all of its sites. The sites are built with Experience Cloud site templates. Which tool should the Experience Cloud consultant recommend to make these changes?

Access to opportunities at Cloud Kicks should be restricted. Sales users should only have access to two categories of opportunities: opportunities they own, and opportunities that are tied to accounts they own. What are two actions a consultant can take to meet the requirement? (Choose two.)

When looking at a landing page report in Pardot, what does unique submissions represent?

A Tableau CRM consultant is notified of a performance issue with data sync (replication). The consultant researches the issue and determines that unnecessary data is being synced. Which solution should the consultant implement to help improve data sync (replication) performance?