ExamGecko
Question list
Search
Search

Question 234 - TDS-C01 discussion

Report
Export

Which two actions can you perform when you join tables from multiple connections? Choose two.

A.
Create a union.
Answers
A.
Create a union.
B.
Use a stored procedure.
Answers
B.
Use a stored procedure.
C.
Add a data source filter.
Answers
C.
Add a data source filter.
D.
Create an extract.
Answers
D.
Create an extract.
Suggested answer: C, D

Explanation:

You can perform two actions when you join tables from multiple connections: add a data source filter and create an extract. A data source filter is a filter that you can apply to the data source before it is loaded into Tableau. This can help improve performance and reduce the amount of data in the view.A data source filter can be applied to any data source, including those that use cross-database joins2An extract is a snapshot of data that is stored locally on your computer or on Tableau Server. An extract can also improve performance and enable offline analysis.You can create an extract from any data source, including those that use cross-database joins3You cannot perform the other two actions when you join tables from multiple connections: create a union or use a stored procedure. A union is a method for combining data by appending rows of one table onto another table. To union your data in Tableau, the tables must come from the same connection.You cannot union tables from different data sources or connections4A stored procedure is a set of SQL statements that can be executed on a database server. Tableau does not support using stored procedures as part of a cross-database join.You can only use stored procedures with some single-connection relational data sources, such as Microsoft SQL Server, Oracle, or PostgreSQL5

asked 23/09/2024
Randhir Singh
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first