Online Access Free ANC-301 Practice Test

Exhibit.

Universal Containers has a dashboard for sales managers to visualize the Year Over Year (YoY) growth of their customers. The formula used is:
YoY = [(This Year - Last Year) / Last Year] %
Based on the graphic, when there is not an account in the Last Year column, the YoY Growth shows null results. The sales managers want to replace it with 100% value.
What is the correct function to use?

• A.coalesce()
• B.substr()
• C.replace()

The CRM Analytics consultant at Cloud Kicks is asked to a dashboard displaying Opportunities data on the account's record page. The dashboard should display only opportunity data related to the current account viewed.
How should the consultant accomplish this?

• A.Create a dashboard, clone it and filter It for each account record, and embed them into the account's record pages accordingly.
• B.Create the dashboard, insert in the account's record page, and apply a filter based on the account's Id field.
• C.Create the dashboard, insert in the account's record page, and apply a filter based on the opportunity's Id field.

A CRM Analytics consultant is building a dashboard for Cloud Kicks that is embedded in a separate Lightning page called "Management Dashboard" using a CRM Analytics Dashboard Component. The system administrator and the contract manager should both have access. The system administrator is able to see the dashboard and the data, but the contract manager sees a blank Lightning page.
What is causing the issue?

• A.The consultant has set up a dashboard filter condition for data to be visible to system administrators only.
• B.The consultant has set up/enabled a 'Hide on Error' feature for the dashboard while embedding it.
• C.The consultant has set up component visibility for the dashboard for system administrators only.

A CRM Analytics consultant is asked to help a company report on its sales activity. The company wants to train some users to create dashboards. The company also wants one other specific team to be able to use the dashboards.
What should the consultant do to address these requirements?

• A.Use a permission set license with two different levels of access.
• B.Clone the existing permission set with different system permissions.
• C.configure a permission set license assignment with two different levels of access.

A CRM Analytics consultant has been tasked with providing access to CRM Analytics for a few users. They should be able to view the data but unable to export it.
Which permission should the consultant make sure to NOT include?

• A.Download CRM Analytics data
• B.Export CRM Analytics data
• C.View CRM Analytics Assets