In ______, data is stored in memory but can also be retrieved from the original data source. This is useful when you are working with dimension tables, which can be queried with fact tables from the same source.
Options: Import mode, Direct Query mode, Dual Mode
______ does not have a predefined structure or format. It is best used for qualitative analysis and usually resides in non-relational databases or unprocessed file formats.
Options: Unstructured data, Semi-structured data, Structured data
Which of the following is required to initiate a workflow and prompt it to run?
Options: Trigger, Action
Answer (2)
The answers to the questions are: Direct Query mode for data retrieval from sources while querying dimension tables, Unstructured data for data without a predefined format, and Trigger for initiating a workflow.
;
Let's look at each part of your question:
The first question is about data storage and retrieval. The correct option is Direct Query mode .
Direct Query mode allows data to be stored in memory but also enables it to be retrieved directly from the original data source. This is particularly useful when working with dimension tables, as they can be queried alongside fact tables from the same source. In business intelligence tools like Power BI, Direct Query mode is chosen when you want to ensure real-time data updates and avoid large-scale data imports.
The second question asks about data without a predefined structure. The correct option is Unstructured data .
Unstructured data does not have a predefined structure or format. It includes things like text, audio, video, and social media content, which are best used for qualitative analysis. This type of data typically resides in non-relational databases or unprocessed file formats.
The third question is about initiating a workflow. The correct option is Trigger .
A trigger is required to initiate a workflow and prompt it to run. In the context of automation and workflow systems, a trigger can be an event or condition that starts the execution of a series of predefined actions.
In summary, the answers are:
In the first blank, the answer is Direct Query mode .
In the second blank, the answer is Unstructured data .
To initiate a workflow, the answer is Trigger .
