TDS-C01
Free trial
Verified
Question 1
What are 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 string function should you use to find a substring within a column and return a Boolean value?
- A: RTRIM
- B: SPLIT
- C: CONTAINS
- D: ENDSWITH
Question 3
You want to assign the Latitude geographic role to a field.
What should be the data type and the data role of the field? (Choose two.)
- A: String
- B: Dimension
- C: Measure
- D: Number (decimal)
Question 4
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.
Question 5
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 6
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 7
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.
- D: From the File menu, select New.
Question 8
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 9
What are two examples of a date value? (Choose two.)
- A: January 1, 1995
- B: December
- C: Wednesday
- D: 2020-05-01
Question 10
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 11
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 12
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 13
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 14
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 15
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 16
Which two types of fields appear blue? (Choose two.)
- A: Continuous measures
- B: Discrete dimensions
- C: Discrete measures
- D: Continuous dimensions
Question 17
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 18
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
Question 19
Which two types of aggregations can be applied to string fields? (Choose two.)
- A: Minimum
- B: Sum
- C: Average
- D: Count Distinct
Question 20
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 21
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 22
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.
Question 23
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 24
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
That’s the end of your free questions
You’ve reached the preview limit for TDS-C01Consider upgrading to gain full access!
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!