Question #1
What are the two methods for renaming a field in a visualization? (Choose two)

A. From the Data pane, use the field’s drop-down menu and select Rename.

B. From the Data pane, right-click the field and select Replace References.

C. From the Data pane, click and hold on the field until the name is editable.

D. From the Format menu, select Field Labels.

Question #2

Which statement accurately describes aliases?

A. You can assign an alias to a eld member before creating a visualization.

B. When you assign an alias, the name changes in the database.

C. You can create an alias for a discrete measure.

D. You can create an alias for a continuous dimension.

Question #3

You need to invert the color intensity of a quantitative range. Which option should you use?

A. Border

B. Reversed

C. Opacity

D. Stepped Color

Question #4

You need to display the complete list of potential data connections when you connect to a server. What action should you perform?

A. Select Connecting to Data.

B. Select More under To a File.

C. Select More under To a Server.

D. Select File on the menu, and then select New.

Question #5

When creating a data source, how can you add additional connections to different databases?

A. From the drop-down menu of the current connection, select Edit Connection.

B. From the Connections pane, select Add.

C. From the Data menu, select New Data Source.

Question #6

What are two characteristics of relationships? (Choose two.)

A. Relationships will query every table in a data model regardless of whether the fields are in the visualization.

B. Relationships will query only the tables and fields needed to create a visualization.

C. Relationships are only supported when using extracts.

D. Relationships are aware automatically of the native level of detail of logical tables.

Question #7

What are two examples of a date value? (Choose two.)

A. January 1, 1995

B. December

C. Wednesday

D. 2020-05-01

Question #8

What are three reasons to use joins instead of relationships? (Choose three.)

A. You need to use a specific join type.

B. You need to create an extract that will have multiple tables.

C. You need to use row-level security.

D. You need to use a data model that supports shared dimensions.

E. You need to connect to multiple databases.

Question #9

What are three benefits of using an extract as compared to a live connection to a data source? (Choose three.)

A. A live connection to a data source provides the best performance for data connections.

B. Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.

C. Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.

D. An extract reduces the amount of data stored on a client computer as compared to a live data connection.

E. A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.

Question #10

How can you access options to apply bold formatting to an axis in the view?

A. Select Text on the Marks card.

B. Select Field Labels on the Format menu.

C. Right-click on the Field and select Format.

D. Right-click on the axis.

Question #11

With the Marks card drop-down menu set to Automatic, a line chart will be created whenever you place what on the Rows shelf and the Columns shelf?

A. Measures on one shelf, and a date dimension on the other

B. Zero or more dimensions on one shelf, and 2 or more measures on the other

C. Zero or more measures on one shelf, and 2 or more dimensions on the other

D. A date dimension followed by a continuous measure on one shelf

Question #12

When should you use a relationship instead of a join for two data sets?

A. To use both data sets across multiple sheets in a visualization.

B. The data sets are in two separate tables within a single spreadsheet.

C. The data sets include similar data aggregated at different levels of detail.

D. The data sets include similar data aggregated up to the highest level.

Question #13

What is created by a calculated field that has a formula of SUM(Sales) / SUM(Profit)?

A. A measure

B. A dimension

C. A set

D. A parameter

Question #14

Which two types of fields appear blue? (Choose two.)

A. Continuous measures

B. Discrete dimensions

C. Discrete measures

D. Continuous dimensions

Question #15

Which two Filter modes can you use with dimension filters? (Choose two.)

A. Range of Values

B. At most

C. Wildcard Match

D. Multiple Values (drop-down)

Question #16

When viewing quick table calculations, such as Percent Difference from, that use a value in the previous column, what will be the first data value in the visualization?

A. Zero (0)

B. Null

C. Duplicated from the nearest columnfi

D. The current value

Question #17

Which two types of aggregations can be applied to string fields? (Choose two.)

A. Minimum

B. Sum

C. Average

D. Count Distinct

Question #18

You create a crosstab that shows a list of 100 hotel chains alongside their average nightly cost.
You also create two groups showing, respectively, the top 10 and bottom 10 hotel chains by cost, with subtotals.
What should you do to improve the crosstab and compare the two groups to all the remaining hotel chains?

A. Create a new view.

B. Color encode the hotel chain names.

C. Include an Other group.

D. Include the Summary card.

Question #19

You have the following string value: Sales Data. Which calculated field produces an output of Sales?

A. LEFT (“Sales Data”)

B. LEFT (“Sales Data”, 5)

C. LTRIM (“Sales Data”)

D. RTRIM (“Sales Data”)

Question #20

You create a dual axis chart that shows sales and product over time. What should you do to distinguish sales from product? (Choose two)

A. Adjust the time frame displayed.

B. Change the mark types of sales and product.

C. Adjust the aggregations for sales and profit to be different.

D. Change the color of sales and product.

Question #21

What are two use cases for creating hierarchies from the Data pane? (Choose two.)

A. To organize related fields together

B. To add drilldown functionality for fields

C. To create faster-performing queries

D. To concatenate all fields into a single field

Question #22

From which three locations can you sort a visualization? (Choose three.)

A. The Analysis menu

B. Tooltip on the Marks card

C. An axis

D. The Worksheet menu

E. A field label

F. A header

Question #23

Which statement accurately describes creating a group by selecting headers in a view?

A. The grouped dimension is added to Color.

B. A newly created group only exists in the current view.

C. A new group updates the aliases from the selected headers.

D. The grouped dimension replaces the original dimension field on Rows or Columns

Question #24

You want to provide additional information when hovering over a field in the data pane as shown in the following exhibit.

What should you configure for the field?

A. An alias

B. A header label

C. A default comment

D. A hierarchy

Question #25

You are creating a combined axis chart.

Where should you drag the second measure after dragging the first measure to the Rows shelf?

A. The Marks card

B. The Filter card

C. The horizontal axis in the view

D. The vertical axis in the view

Question #26

To best improve the display of a scatter plot that has overlapping shapes, you should adjust the _____ of the marks.

A. mark size

B. mark borders

C. color opacity

D. color palette

Question #27

The option to create bins is available for which type of field?

A. Boolean

B. Numeric

C. Date

D. String

Question #28

Which mark type is used in a highlight table?

A. Area

B. Square

C. Polygon

D. Text

Mock Up Questions 模拟题