Advanced Tableau & BI Tools test (Advanced)

Sample questions

5 sample questions from the Advanced Tableau & BI Tools test, with the answers. Samples are taken out of the live test, so you will not meet these when you sit it.

1. Which of the following statements is true regarding nesting LOD FIXED expressions in Tableau?

   1. LOD FIXED expressions can be nested within other LOD expressions if the outer expression is an LOD EXCLUDE
   2. LOD FIXED expressions can be nested within other LOD expressions if the outer expression is an LOD INCLUDE
   3. LOD FIXED expressions can be nested within other LOD expressions if the inner expression is simplified
   4. LOD FIXED expressions cannot be nested within other LOD expressions

   Answer: D. LOD FIXED expressions cannot be nested within other LOD expressions

   In Tableau, LOD FIXED expressions are not allowed to be nested within other LOD expressions. This is a common mistake and a tricky edge case when working with LOD calculations. When attempting to nest LOD FIXED expressions, Tableau will return an error, indicating that the syntax is invalid. LOD INCLUDE and LOD EXCLUDE expressions can be nested under certain conditions, but LOD FIXED cannot be nested at all.

2. Which of the following statements correctly compares data retention policies with data archival policies and explains when each should be used?

   1. Data retention policies are applied to metadata only, whereas data archival policies are applied to raw data.
   2. Data retention policies are used for temporary storage of data, while data archival policies are used for real-time data processing.
   3. Data retention policies are used to increase data availability, while data archival policies are used to reduce data redundancy.
   4. Data retention policies define how long data should be kept before being purged, while data archival policies specify how data is stored for long-term access but not actively used.

   Answer: D. Data retention policies define how long data should be kept before being purged, while data archival policies specify how data is stored for long-term access but not actively used.

   Data retention policies focus on the duration for which data is retained, ensuring compliance with legal and regulatory requirements. Data archival policies, on the other hand, focus on the method and location of storing data for long-term access. Choosing between them depends on the organization's compliance needs and data usage patterns.

3. In a realistic project scenario involving data modeling for a BI tool, which of the following accurately describes the use of a star schema?

   1. Star schema uses a many-to-many relationship between fact and dimension tables to maximize data redundancy.
   2. Star schema is used to model data in a way that separates fact tables from dimension tables, ensuring that the fact table contains only measurable values and foreign keys to dimension tables.
   3. Star schema combines all tables into a single table, making it easier to manage complex relationships.
   4. Star schema is typically used for transactional databases rather than for data warehousing or BI projects.

   Answer: B. Star schema is used to model data in a way that separates fact tables from dimension tables, ensuring that the fact table contains only measurable values and foreign keys to dimension tables.

   In a star schema, the fact table is at the center, and dimension tables are connected to it. This structure is ideal for data modeling in BI tools as it simplifies query performance and allows for efficient analysis. Option 1 correctly describes this structure, while the other options either refer to snowflake schemas or describe incorrect modeling practices.

4. In a star schema applied to a large-scale data warehouse project, which statement best aligns with best practices for optimizing query performance?

   1. Dimension tables should be kept highly normalized for better scalability.
   2. Fact tables should be normalized to reduce data redundancy.
   3. Star schema performance is unaffected by the normalization of fact tables.
   4. Fact tables should be denormalized to avoid complex joins and improve query performance.

   Answer: D. Fact tables should be denormalized to avoid complex joins and improve query performance.

   In a star schema, fact tables are typically denormalized to reduce the number of joins required during query execution, which enhances performance. Normalizing dimension tables is common practice, but fact tables are kept denormalized for faster query processing. Other options suggest normalizing fact tables or overcomplicating the schema, which can lead to performance issues.

5. You are tasked with finding and fixing a bug related to governance data retention policies in a Tableau dashboard. What is the most appropriate action to take?

   1. Ensure that data lineage is properly documented and maintained across all data sources.
   2. Review data retention policies and audit data sources to ensure compliance with retention periods, then clean up any data that has exceeded its retention period.
   3. Optimize dashboard performance by reducing the number of calculated fields and using filters effectively.
   4. Implement row-level security to restrict user access based on their roles and responsibilities.

   Answer: B. Review data retention policies and audit data sources to ensure compliance with retention periods, then clean up any data that has exceeded its retention period.

   To address a bug related to governance data retention policies, it is essential to first review the policies and audit the data sources. This ensures that any data that has exceeded its retention period is identified and cleaned up, thus fixing the issue. Other options may focus on unrelated aspects such as performance or security, which do not directly address the bug related to data retention.