模拟题与复盘提示（整理版）
本页将原题按清晰格式重新排版，并提供"答案占位"和"复盘备注"区，便于练习与回顾。
使用说明
- 建议答题时先遮住"答案占位"，完成后再对照。
- 每题下方提供"复盘备注"空行，记录易错点或知识点链接。
题目清单
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.
复盘备注：
2) Which statement accurately describes aliases?
- A. You can assign an alias to a field 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.
复盘备注：
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
复盘备注：
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.
复盘备注：
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.
复盘备注：
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.
复盘备注：
7) What are two examples of a date value? (Choose two.)
- A. January 1, 1995
- B. December
- C. Wednesday
- D. 2020-05-01
复盘备注：
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.
复盘备注：
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.
复盘备注：
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.
复盘备注：
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
复盘备注：
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.
复盘备注：
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
复盘备注：
14) Which two types of fields appear blue? (Choose two.)
- A. Continuous measures
- B. Discrete dimensions
- C. Discrete measures
- D. Continuous dimensions
复盘备注：
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)
复盘备注：
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 column
- D. The current value
复盘备注：
17) Which two types of aggregations can be applied to string fields? (Choose two.)
- A. Minimum
- B. Sum
- C. Average
- D. Count Distinct
复盘备注：
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.
复盘备注：
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")
复盘备注：
20) You create a dual axis chart that shows sales and profit over time. What should you do to distinguish sales from profit? (Choose two)
- A. Adjust the time frame displayed.
- B. Change the mark types of sales and profit.
- C. Adjust the aggregations for sales and profit to be different.
- D. Change the color of sales and profit.
复盘备注：
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
复盘备注：
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
复盘备注：
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.
复盘备注：
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
复盘备注：
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
复盘备注：
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
复盘备注：
27) The option to create bins is available for which type of field?
- A. Boolean
- B. Numeric
- C. Date
- D. String
复盘备注：
28) Which mark type is used in a highlight table?
- A. Area
- B. Square
- C. Polygon
- D. Text
复盘备注：
答案占位（待核对后填写）
- Q1：__ __
- Q2：__
- Q3：__
- Q4：__
- Q5：__
- Q6：__ __
- Q7：__ __
- Q8：__ __ __
- Q9：__ __ __
- Q10：__
- Q11：__
- Q12：__
- Q13：__
- Q14：__ __
- Q15：__ __
- Q16：__
- Q17：__ __
- Q18：__
- Q19：__
- Q20：__ __
- Q21：__ __
- Q22：__ __ __
- Q23：__
- Q24：__
- Q25：__
- Q26：__
- Q27：__
- Q28：__