Tableau Expert Quiz
1) Which one is incorrect with respect to data blending?
- data blending resolves many data granularity problem
- data blending resolves collocation problem
- data blending adapts the need of exploratory visual analytics
- data blending helps in optimizing the data volume in multiple data sources
2) Which attribute doesn’t come under VizQL model in tableau metadata?
- aggregations
- table joins
- filters
- roles
3) Which is not related to Tableau’s security?
- Access Security
- Platform Security
- Object Security
- Network Transmission Security
4) Data blending in Tableau means-
- combine multiple data sources on the fly
- drag and drop the dimensions in the application layer
- blending metadata
- union of 2 tables
5) Tableau’s underlying technology is called
- VizQL
- QVD
- C++
- SQL
6) Which one is not the function of Tableau Server
- Publishing dashboard
- Authentication Management
- Row level security implementation
- Scheduling reports
7) Tableau Server enforces different security for different views if they are served on the mobile devices
- TRUE
- FALSE
8) You can publish a new view or republish a tableau view from a browser
- TRUE
- FALSE
9) You can filter the secondary data source without requiring the linked field during data blending
- TRUE
- FALSE
10) Tableau has three desktop editions, which edition allows you to publish visualizations to Tableau server?
- Public Edition
- Personal Edition
- Professional Edition
- Enterprise Edition
11) When you share workbook with others using Tableau server, by default they can access all the data shown in the views. Alternatively, you can create filters to limit the data that any given person can see. Using user filters and row level security. Name th
- User group filter and project filter
- Manually and Automatically
- Filter by hierarchy and by groups
- Filter can be applied using parameters only
12) Which authentication method only works for Microsoft SQL server data sources that have been configured for impersonation.
- Impersonate via embedded password
- Prompt User
- Server Run as Account
- Embedded Password
13) You use this custom sql query in Tableau to connect to your data (SELECT * from authors, titleauthor where authors.au_id=titleauthor.au_id). Although the query is valid, you will get an error anytime you use the au_id field in your view. Why?
- When you use au_id, Tableau does not know which table you are referring to.
- The sql query used is incorrect
- This occurs when you have not used a linking field in the view
- Tableau does not support this type of custom sql
14) Occasionally, asterisks (*) appear in some fields used in the view when blending primary and secondary data sources. This is because…
- There are more than one matching member in the secondary data source
- Data blending is incorrectly configured
- There are more than one matching member in the primary data source
- This occurs when you have not used a linking field in the view
15) Advanced concept to help people combine data sets from two different data source that might be partially related to each other.
- Data Source Connector
- Data Blending
- Data Mapping
- Data linking
16) When publishing workbook to the server, one of the options is to select whether to include external files. Select the best answer that describes what happens when this option is selected
- a copy of any referenced external file data sources or background images are published along with the workbook
- all workbook views are displayed on the server
- When this option is selected, a copy of the external file on the tableau server are published along with the workbook
- A copy of files from user’s local drive are copied to the Tableau server. This method improves dashboard performance since files are now residing on the server.
17) A user who accesses a view that connects to a Tableau Server data source must at least have both __________ permission for the workbook and _______ permission for the data source.
- read, write
- write, read
- view, connect
- connect, view
18) Tableau defines project as
- temporary activity designed to produce a unique product, service or result
- a collection of related workbooks
- a collection of related views
- an individual or collaborative enterprise planned and designed to achieve an aim
19) As a general role, who can create new projects in Tableau?
- Project Managers
- Project Leader
- Tableau administrators
- Tableau Desktop Users
20) To move workbooks into projects, you need to have at least an interactor license and one of the three conditions must be true. Please identify which one is not a valid condition.
- You have been given permission to write to the project
- You have been given project leader permission for the project
- You have been granted the admin right
- You have been granted Tableau Desktop admin access
21) Which of the following statement is true
- A workbook can only be moved when the workbook owner leaves the company
- A workbook can be part of multiple projects
- A workbook can only be part of a single project
- A workbook can only be moved to the Default project
22) Who can delete the Default project
- Publisher
- Administrator
- Project Leader
- nobody
23) Returns true if the string argument can be converted to a date
- ISDATE(string)
- DAY(date)
- Now()
- Today()
24) Before extract refresh can work, this setting has to be enabled on the server maintenance page.
- Embedded Credentials
- Scheduling
- Saved Passwords
- Enable Guest
25) The Tableau repository holds workbooks, bookmarks, and data sources. Where is this normally located by default?
- On the Tableau server under my documents
- On Tableau’s proprietary database
- On a client’s computer under ‘my documents/my tableau repository’
- On a client’s computer under ‘download/my tableau repository’
26) You can use this to organize users in Tableau to make it easier to manage multiple user access.
- Projects
- Groups
- Folders
- Sets
