Bob is learning Power BI.
Exl technical mcq question, verified with a worked answer. Free to practise - no sign-up.
Bob is learning Power BI. To encourage self-service analytics within the company, he is asked to set up Q&A in the reports. Which of the following data storage/modeling modes supports configuring and running the Q&A feature directly according to this scenario?
Show answer & explanation
The Q&A feature in Power BI relies on the internal data engine's ability to index and query the data model efficiently. Import mode stores data in-memory using the VertiPaq engine, which provides the full set of modeling capabilities and performance required to support the natural language processing (NLP) engine of Q&A.
Step-by-step Derivation:
Step 1: Analyze the requirements for the Q&A feature. Q&A requires a robust data model where synonyms, linguistic schemas, and rapid querying are supported to translate natural language into DAX queries.
Step 2: Evaluate 'DirectQuery'. While some Q&A functionality exists, DirectQuery has significant limitations regarding the types of calculations and the speed of response required for an interactive NLP experience, often restricting the full configuration of Q&A features.
Step 3: Evaluate 'Live Connection'. Live Connection connects to a pre-defined Analysis Services model. While Q&A can work if the model is configured on the server side, the 'configuration' of the Q&A feature (like adding synonyms in the Power BI Desktop interface) is limited because the model is not owned by the report file.
Step 4: Evaluate 'Import'. Import mode provides the highest level of flexibility. It allows the user to fully configure the data model, define synonyms, and utilize the full power of the in-memory engine to execute the generated DAX queries instantly.
Step 5: Compare options. Import mode is the primary and most fully supported mode for configuring and running the Q&A feature directly within the Power BI Desktop/Service environment.