ExamGecko
Question list
Search
Search

Question 137 - TDS-C01 discussion

Report
Export

When working with Excel, text file data, JSON file, .pdf file data, you can use _________________ to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection.

A.
Regex Search
Answers
A.
Regex Search
B.
Union Search
Answers
B.
Union Search
C.
Pattern Search
Answers
C.
Pattern Search
D.
Wildcard Search
Answers
D.
Wildcard Search
Suggested answer: D

Explanation:

You can use Wildcard Search to set up search criteria to automatically include tables in your union. Use the wildcard character, which is an asterisk (*), to match a sequence or pattern of characters in the Excel workbook and worksheet names, Google Sheets workbook and worksheet names, text file names, JSON file names, .pdf file names, and database table names.

When working with Excel, text file data, JSON file, .pdf file data, you can also use this method to union files across folders, and worksheets across workbooks. Search is scoped to the selected connection. The connection and the tables available in a connection are shown on the left pane of the Data source page.

asked 23/09/2024
Godavari, Rakesh
43 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first