Salesforce Analytics-Con-301 Exam Questions

When a client republishes a dashboard after making changes and users report broken bookmarks, the likely causes include:

The dashboard was published to a different project: Changing the project location alters the URL path, causing bookmarks to point to a now non-existent dashboard location.

The dashboard was published with a new name: Altering the dashboard's name changes its URL, resulting in broken bookmarks as the previous URL no longer leads to the intended dashboard.

When dashboards are published to Tableau Cloud, the function USERNAME() returns the user's Tableau Cloud username, which is the email address associated with their Tableau Cloud account.

Tableau documentation states:

On Tableau Cloud, the value returned by USERNAME() is always the user's email address.

Row-Level Security (RLS) is typically implemented using a comparison of USERNAME() to an email field in the data source.

For secure filtering, the field compared to USERNAME() must match the authentication identity exactly.

Looking at the provided table:

''Abbreviated Name'' contains short custom codes like ''SMiller,'' which do not match Tableau Cloud usernames.

''Lower Case Name'' contains names like ''sean miller,'' which also do not match Tableau Cloud usernames.

''Email'' contains the full email address for each user, such as ''Sean.Miller@superstore.com,'' which is the only field that corresponds to what USERNAME() returns in Tableau Cloud.

Therefore, the correct field to reference is Email.

Tableau Cloud authentication documentation stating USERNAME() returns the user's email address.

Row-Level Security setup guidance recommending the comparison USERNAME() = [Email Field].

Tableau security practices indicating only the email column will match USERNAME() values on Tableau Cloud.

Comprehensive and Detailed Explanation From Exact Extract:

The problem:

Custom SQL joins two multi-row tables, causing many-to-many duplication.

This artificially multiplies claim costs.

The extract becomes heavy and slow due to Custom SQL.

Tableau's recommended solution:

Use Relationships in the Logical Layer

Instead of physical joins

Tableau resolves many-to-many issues automatically

Query is generated at the appropriate granularity to avoid duplication

This is exactly Option A.

Relationships allow the Claims facts to remain at the claim grain and Members to remain at the member grain. Tableau resolves aggregations correctly, preventing inflated values.

Why the others are incorrect:

B --- Physical Join

Would continue the same duplication problem because multi-row joins multiply rows.

C --- LODs

Would require complex calculations and are error-prone.

They do NOT fix the duplication in the underlying extract.

D --- Table Calculations

Happen after Tableau aggregates the duplicated data --- too late to fix the inflated baseline numbers.

Thus, the only correct and modern solution is relationships.

Relationships documentation explaining resolution of many-to-many granularity issues.

Guidance recommending avoiding Custom SQL for performance reasons.

Logical Layer behavior preventing row-duplication errors.

Comprehensive and Detailed Explanation From Exact Extract:

Tableau Catalog provides multiple features for communicating data quality and freshness.

Data Quality Warnings (DQWs) are part of Catalog's metadata management system and are specifically designed to inform users about data issues, including when data is stale.

There are two visibility levels:

1. Standard Visibility Data Quality Warning

Appears subtly in metadata panels.

Intended for non-critical issues.

Does not guarantee the message will be seen by dashboard viewers.

2. High Visibility Data Quality Warning

Designed for urgent, critical, and highly visible alerts.

Displays a prominent warning indicator directly on connected dashboards, data sources, and workbooks.

Tableau documentation states high-visibility warnings are used when users must be alerted, such as:

Stale data

Incomplete refreshes

Data outages

Because the question emphasizes:

''important to alert dashboard viewers when data has not been refreshed''

A standard warning is not strong enough, but a High Visibility Data Quality Warning is explicitly designed for this scenario.

Evaluation of the choices:

A . Standard Visibility Data Quality Warning --- Not sufficient

It does not force dashboard users to notice the warning.

B . High Visibility Data Quality Warning --- Correct

This option is specifically meant to notify users of critical freshness issues, making it the perfect match for the requirement.

C . Certified Data Source --- Incorrect

Certification communicates trustworthiness, not freshness or alerts.

D . Lineage --- Incorrect

Lineage shows data relationships and dependencies, not refresh warnings.

Conclusion

To alert viewers about stale data in hourly-refreshed dashboards, the consultant must use a High Visibility Data Quality Warning.

Reference From Tableau Catalog Documentation

Description of Data Quality Warnings and their visibility levels.

Definition of High Visibility DQWs as critical alerts shown to dashboard viewers.

Catalog guidelines for stale data detection and communication.

Comprehensive and Detailed Explanation From Exact Extract:

To combine Excel and SQL Server data in the same logical data model, Tableau offers two supported capabilities:

Relationships

Recommended modern method for combining tables from multiple sources.

Supports cross-database relationships between Excel and SQL Server.

Maintains separate physical layers but integrates data at query time.

Cross-Database Joins

Allows joining data from different databases in the physical layer.

Fully supported for Excel + MS SQL Server.

Useful when granular row-level merging is needed.

Why the other options are incorrect:

C . Data Blending

Legacy feature, used only when no direct combination is possible.

Tableau recommends relationships instead.

Produces separate queries and may lose row-level detail.

D . Union

Requires tables to have equivalent structure.

Cannot union Excel with SQL Server unless identical column structure exists.

Not appropriate for most mixed-source reporting.

Therefore, the correct techniques are Relationships and Cross-Database Joins.

Tableau data modeling documentation recommending Relationships for multi-source modeling.

Cross-database join support list including Excel + SQL Server.