TDS-C01 practice test

1. Question 1 · 1

   What are two methods for renaming a field in a visualization? (Choose two.)

   Choose all answers that apply.

   • From the Data pane, use the field’s drop-down menu and select Rename.
   • From the Data pane, right-click the field and select Replace References.
   • From the Data pane, click and hold on the field until the name is editable.
   • From the Format menu, select Field Labels.

2. Question 2 · 1

   Which string function should you use to find a substring within a column and return a Boolean value?

   Choose one answer.

   • RTRIM
   • SPLIT
   • CONTAINS
   • ENDSWITH

3. Question 3 · 1

   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.)

   Choose all answers that apply.

   • String
   • Dimension
   • Measure
   • Number (decimal)

4. Question 4 · 1

   Which statement accurately describes aliases?

   Choose one answer.

   • You can assign an alias to a field member before creating a visualization.
   • When you assign an alias, the name changes in the database.
   • You can create an alias for a discrete measure.
   • You can create an alias for a continuous dimension.

5. Question 5 · 1

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

   Choose one answer.

   • Border
   • Reversed
   • Opacity
   • Stepped Color

6. Question 6 · 1

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

   Choose one answer.

   • Select Connecting to Data.
   • Select More under To a File.
   • Select More under To a Server.
   • Select File on the menu, and then select New.

7. Question 7 · 1

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

   Choose one answer.

   • From the drop-down menu of the current connection, select Edit Connection.
   • From the Connections pane, select Add.
   • From the Data menu, select New Data Source.
   • From the File menu, select New.

8. Question 8 · 1

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

   Choose all answers that apply.

   • Relationships will query every table in a data model regardless of whether the fields are in the visualization.
   • Relationships will query only the tables and fields needed to create a visualization.
   • Relationships are only supported when using extracts.
   • Relationships are aware automatically of the native level of detail of logical tables.

9. Question 9 · 1

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

   Choose all answers that apply.

   • January 1, 1995
   • December
   • Wednesday
   • 2020-05-01

10. Question 10 · 1

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

    Choose all answers that apply.

    • You need to use a specific join type.
    • You need to create an extract that will have multiple tables.
    • You need to use row-level security.
    • You need to use a data model that supports shared dimensions.
    • You need to connect to multiple databases.

11. Question 11 · 1

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

    Choose all answers that apply.

    • A live connection to a data source provides the best performance for data connections.
    • Calculated fields perform better in workbooks connected to extracts than in workbooks with live connections to a data source.
    • Extracts are stored in memory (RAM), resulting in faster query performance as compared with live data connections.
    • An extract reduces the amount of data stored on a client computer as compared to a live data connection.
    • A live connection to a data source can be slow due to network and user traffic, whereas a connection to an extract improves performance.

12. Question 12 · 2

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

    Choose one answer.

    • Select Text on the Marks card.
    • Select Field Labels on the Format menu.
    • Right-click on the Field and select Format.
    • Right-click on the axis.

13. Question 13 · 2

    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?

    Choose one answer.

    • Measures on one shelf, and a date dimension on the other
    • Zero or more dimensions on one shelf, and 2 or more measures on the other
    • Zero or more measures on one shelf, and 2 or more dimensions on the other
    • A date dimension followed by a continuous measure on one shelf

14. Question 14 · 2

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

    Choose one answer.

    • To use both data sets across multiple sheets in a visualization.
    • The data sets are in two separate tables within a single spreadsheet.
    • The data sets include similar data aggregated at different levels of detail.
    • The data sets include similar data aggregated up to the highest level.

15. Question 15 · 2

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

    Choose one answer.

    • A measure
    • A dimension
    • A set
    • A parameter

Paid access to all 115 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.