Online Access Free Analytics-Con-301 Exam Questions

A client notices that several groups are sharing content across divisions and are not complying with their data governance strategy. During a Tableau Server audit, a consultant notices that the asset permissions for the client's top-level projects are set to "Locked," but that "Apply to Nested Projects" is not checked.
The consultant recommends checking "Apply to Nested Projects" to enforce compliance.
Which impact will the consultant's recommendation have on access to the existing nested projects?

• A.Access will be automatically rolled back to the top-level project permissions immediately.
• B.Users will be prompted to manually update permissions for all nested projects.
• C.Users will be notified that they will automatically lose access to content after 30 days.
• D.Current custom access will be maintained, but new custom permissions will not be granted.

A client collects information about a web browser customers use to access their website. They then visualize the breakdown of web traffic by browser version.
The data is stored in the format shown below in the related table, with a NULL BrowserID stored in the Site Visitor Table if an unknown browser version accesses their website.

The client uses "Some Records Match" for the Referential Integrity setting because a match is not guaranteed.
The client wants to improve the performance of
the dashboard while also getting an accurate count of site visitors.
Which modifications to the data tables and join should the consultant recommend?

• A.Add an "Unknown" option to the Browser Table, reference its BrowserID in the Site Visitor Table, and leave the Referential Integrity set to
  "Some Records Match."
• B.Continue to use NULL as the BrowserID in the Site Visitor Table and leave the Referential Integrity set to "Some Records Match."
• C.Continue to use NULL as the BrowserID in the Site Visitor Table and change the Referential Integrity to "All Records Match."
• D.Add an "Unknown" option to the Browser Table, reference its BrowserID in the Site Visitor Table, and change the Referential Integrity to "All Records Match."

A company uses an extract built from Custom SQL joining Claims and Members.
Members have multiple records in both tables # causing data duplication, which results in inflated claim cost trends.
Which approach meets performance and maintenance goals?

• A.Use Table Calculations to ensure that claim costs are captured at the right granularity.
• B.Replace the Custom SQL with a join between two Physical Tables: Members and Claims.
• C.Replace the Custom SQL with a relationship between two Logical Tables: Members and Claims.
• D.Use LOD calculations to ensure that claim costs are captured at the right granularity.

A client wants to count all the distinct orders placed in 2010. They have written the following calculation, but the result is incorrect.
IF YEAR([Date])=2010 THEN COUNTD ([OrderID]) END
Which calculation will produce the correct result?

• A.IF YEAR([Date])=2010 THEN {COUNTD ([OrderID])} END
• B.IF MIN(YEAR([Date]))=2010 THEN WINDOW_COUNTD([OrderID]) END
• C.COUNTD(IF YEAR([Date])=2010 THEN [OrderID] END)
• D.COUNT(IF YEAR([Date])=2010 THEN [OrderID] END)

A Tableau consultant is tasked with choosing a method of setting up row-level security (RLS) entitlements with tables during a Tableau implementation. The consultant has received a set of roles from a client in one normalized table, and a set of entitlements from the client in another normalized table.
The consultant plans on using the deepest granularity method. However, when the consultant gains access to the final set of data, they discover duplicate values at the lowest level. Most of the regions in the client's dataset contain sub-regions named 'East' and 'West'. However, some regions have a 'Null' value for sub-region.

How should the consultant proceed?

• A.Use sparse entitlements because it defines entitlements at every level of the hierarchy and can handle duplicate values in the dataset.
• B.Use sparse entitlements because it is the most performant and the duplicate values will be handled by the mapping table.
• C.Use the deepest granularity method because it defines entitlements at every level of the hierarchy and can handle duplicate values in the dataset.
• D.Use the deepest granularity method because it is the most performant and the duplicate values will be handled by the mapping table.