Domain 4: Publish & Manage Content on Server/Cloud (9%) Flashcards

1
Q

When publishing a workbook, how do you add tags with spaces?

A

Tags help users find related workbooks when they browse the server. Normally, you can simply separate tags using a comma or space. But to add a tag that contains a space, put the tag in quotation marks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What happens when you publish a workbook and select “Show Sheets as Tabs?”

A

The various sheets in a workbook can be navigated with tabs at the top of the visualization.

When a workbook shows sheets as tabs, workbook-level permission rules are applied to the sheets.

When the sheets aren’t shown as tabs, any changes made to workbook permissions don’t apply to the individual sheets (aka views).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

When publishing a workbook, what does the “Preview device layouts” selection allow you to do?

A

To see how your designs appear on mobile devices, click Preview device layouts in the browser when publishing is complete.

Then choose a device type above the viz, and a specific dashboard from the menu at the right.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do you set up row level security using user-based filtering?

A

User-based filtering is one option to help secure your data source or workbook using RLS. This procedure is best for a small and fairly static set of users or groups, and only a small number of workbooks that need user filters.

1) In Tableau Desktop, open the workbook and connect to the data you want to filter.

2) Navigate to the worksheet that you want to apply a filter to.
Select Server > Create User Filter. Then select the field you want to use for filtering the view, such as Region.

3) If prompted, sign in to your server or site.

4) In the User Filter dialog box, name the filter. We’ll use Regional Managers.

5) Select a user or group on the left, then indicate which values on the right they should be able to see. Repeat this process for each user or group, and click OK when you’re done mapping users to values.

6) After you create the user filter, it appears in the Sets area of the Data pane.

7) Drag the user filter to the Filters shelf. The filter becomes a context filter, and the view adjusts to show data that you are allowed to see.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

How do you set up row-level security so that users cannot remove the user filter(s) you set up?

A

To secure user filters, the following capabilities must be set to Deny, either during publishing, or afterward on the server.

Workbooks:
* Web Edit
* Download/Save a copy
* Set Permissions

Data sources:
* Save
* Download
* Set Permissions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Explain the row-level security concept of a dynamic filter, using a security field in the data?

A

Using this method, you create a calculated field that automates the process of mapping users to data values. This method requires that the underlying data include the security information you want to use for filtering.

The most common way to do this is to use a reference (“look-up,” “entitlements,” or “security”) table that contains this information. For example, if you want to filter a view so that only supervisors can see it, the underlying data must be set up to include user names and specify each user’s role.

Because filtering is defined at the data level and automated by the calculated field, this method is more secure than mapping users to data values manually.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What does a Data Policy do with regards to row-level security?

A

Starting in Tableau 2021.4, when the Data Management Add-On is enabled in Tableau Server or Tableau Cloud, users with a Creator license can implement row-level security through data policies on virtual connections. Because virtual connections are centralized and reusable, you can manage row-level security for each connection in one place, safely and securely, across all content that uses that connection.

Unlike the above solutions for row-level security in Tableau, this method doesn’t carry the same risk of exposing information if an author neglects to properly secure permissions on the workbook or data source, because the policy is enforced on the server for every query.

Row-level security through virtual connection data policies was developed to address shortcomings of other row-level security solutions. We recommend this solution in most situations where it’s an option.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

How do you set up row-level security using a dynamic filter (using a field in the data)?

A

1) In Tableau Desktop, open the workbook and connect to the data you want to filter. In this example, we use a table called Orders.

2) Double click the Orders table to open the join canvas. Add the reference table (People) with a left join. For this example, join on the field Region.

3) On the worksheet, select Analysis > Create Calculated Field, and create the following field, named “User is a manager”.
USERNAME() = [Manager]
This calculation returns TRUE if the user name of the person signed in to the server exists in the manager column of the People table.

4) Add the User is a manager field to the Filters shelf.

5) In the Filter dialog box, select True, and then click OK.
This sets the filter so that only people who are managers can see the data in the view. If you are not listed in the Manager field, your view while authoring might appear as a blank canvas.

6) See how the view looks to a particular person: in the lower-right, open the Filter as User menu, and select someone you know is a manager.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Can row-level security exist in the database themselves?

A

Yes. It is not necessarily easier or better to implement a built-in RLS model vs. building it with Tableau in mind; these techniques are generally leveraged when an organization has already invested in these technologies and they want to take advantage of that investment, or when they need to apply the same security policies to other database clients in addition to Tableau.

The main benefit of using built-in RLS is that administrators can implement and control their data security policy in one place: their databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

How do you publish a data source that is connected to your workbook?

A

1) On Tableau Server, open a workbook in web authoring.

2) Click the tab for any worksheet.

3) From the Data pane, click the drop-down menu for the data source you want to share, and click Save as Published Data Source.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Name the four primary components of a Tableau data source.

A

1) The data connection information that describes what data you want to bring into Tableau for analysis (includes joins, field names, etc.).

2) An extract, if you decide to create one.

3) Information about how to access or refresh the data. Examples of this type of information include:
* The path to an original Excel file.
* Embedded credentials or OAuth access tokens for accessing the data directly.
* Alternatively, no credentials, so that users are prompted to enter them when they want to access the data (whether it’s to view a workbook that connects to it, or to connect a new workbook to it).

4) Customization and cleanup that helps you and others use the data source efficiently (calculations, sets, groups, bins, and parameters, etc.).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

When is Tableau Bridge needed?

A

To keep data sources that connect to on-premises data fresh after publishing to Tableau Cloud, Tableau Bridge is required.

Tableau Cloud relies on Bridge to facilitate the connection between it and data accessible only from inside a private network.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the two primary ways to export a data source to a .csv?

A
  • From the Data Source page:
    On the Data Source page, select Data > Export Data to CSV to export all the data in your data source to .csv file.
  • From the view:
    On the sheet tab, drag a field to the Columns or Rows shelf, click the View Data icon in the Data pane, and click the Export All button.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

How do you export the data needed to render the view only - as a .csv?

A

Export the data that is used to generate the view as an Access database (Windows only) or .csv file (Mac only).

In Tableau Desktop, select Worksheet > Export > Data.

Note: you can similarly copy to your clipboard or Export to Excel.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What does a .tds contain?

A

A .tds contains only the information you need to connect to the data source, including the following:
* Data source type
* Connection information specified on the data source page; for example, database server address, port, location of local files, tables
* Groups, sets, calculated fields, bins
* Default field properties; for example, number formats, aggregation, and sort order.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How do you save a .tds/.tdsx?

A

1) In Tableau Desktop, open the workbook that has the connection to the data you want to save as a file.

2) At the top of the Data pane, right-click (Control-click on Mac) the name of the data source, and then select Add to Saved Data Sources.

3) Enter a file name, select the file type (.tds or .tdsx), and then click Save.

14
Q

How do you set up extract refreshes?

A

To schedule refreshes you need to have administrator or data owner permissions.

Sign in to the server, go to the Schedules page, and click New Schedule.

15
Q

Where does a Server Admin go to monitor Server extracts?

A

You can monitor scheduled tasks by viewing Background Tasks for Extracts on the Status page.

16
Q

How do you set up subscriptions for yourself or others?

A

1) From the Explore section of your site, select All Workbooks or All Views, or open the project that contains the view you want to subscribe to.

2) Open a view either directly, or after opening the containing workbook.

3) On the view toolbar, select Watch > Subscriptions.

4) Add the Tableau users or groups you want to receive the subscription. To receive a subscription, users must have the View and Download Image/PDF permissions.

17
Q

If you subscribe a group to your view, will it dynamically update as members of the group go in and out?

A

No. When you subscribe a group, each user is added individually at the time the subscription is created.

If more users are added to the group later, you must re-subscribe the group for those new users to receive the subscription.

Likewise, users later removed from the group will not have their subscriptions removed automatically unless their permissions to the subscribed view are removed.

18
Q

If a subscription fails to successfully send the email and/or attachment, will it immediately notify you?

A

No. But if a subscription fails more than five times, you’ll receive a notification email that your subscription has been suspended.

Subscriptions fail because of an issue with the workbook or a problem loading the view.

You can renew your subscription by going to the “My Content” area of Tableau web pages, an icon appears in the Last update column to indicate that the subscription is suspended. Select … > Resume Subscription to resume.

19
Q
A