TDS-C01 practice questions 1–10

1. Question 1 · 121 in bank

   Select 2

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

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

   Show answer

   Answer: AC

   Next question

2. Question 2 · 121 in bank

   Which statement accurately describes aliases?

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

   Show answer

   Answer: A

   Next question

3. Question 3 · 121 in bank

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

   • ABorder
   • BReversed
   • COpacity
   • DStepped Color

   Show answer

   Answer: B

   Next question

4. Question 4 · 121 in bank

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

   • ASelect Connecting to Data.
   • BSelect More under To a File.
   • CSelect More under To a Server.
   • DSelect File on the menu, and then select New.

   Show answer

   Answer: C

   Next question

5. Question 5 · 121 in bank

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

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

   Show answer

   Answer: B

   Next question

6. Question 6 · 121 in bank

   Select 2

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

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

   Show answer

   Answer: BD

   Next question

7. Question 7 · 121 in bank

   Select 2

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

   • AJanuary 1, 1995
   • BDecember
   • CWednesday
   • D2020-05-01

   Show answer

   Answer: AD

   Next question

8. Question 8 · 121 in bank

   Select 3

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

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

   Show answer

   Answer: ACD

   Next question

9. Question 9 · 121 in bank

   Select 3

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

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

   Show answer

   Answer: BCE

   Next question

10. Question 10 · 121 in bank

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

    • ARTRIM
    • BSPLIT
    • CCONTAINS
    • DENDSWITH

    Show answer

    Answer: C

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

TDS-C01 practice, question 1. 121 questions available.