Power BI – Data Analytics & Visualization › Introduction to Power BI › Question #25386
Multiple Choice Difficult

QWhich scenario is MOST suitable for DirectQuery instead of Import Mode?

ID: #25386 Introduction to Power BI 3 views
Question Info
#25386Q ID
DifficultDifficulty
Introduction to Power BITopic
Start Quiz on This Topic
 Your Answer

Select All That Apply

Tick every correct option, then press Check Answer.

  • A A small Excel file containing annual employee data. ✔ ✖
  • B A report that requires near real-time access to a large SQL Server database. ✔ ✖
  • C A static product catalog updated once per year. ✔ ✖
  • D A report that must work completely offline. ✔ ✖
Correct Answer

Explanation

Option B is correct because DirectQuery retrieves data from the source when users interact with reports, making it suitable for large datasets and near real-time reporting requirements. Option A is a better candidate for Import Mode. Option C does not require real-time access. Option D is impossible because DirectQuery requires access to the source system.
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Why is data transformation important in Power BI? What type of users commonly use Power BI? Which of the following is a common use of Power BI? What is the primary purpose of Power BI? A report takes 20 seconds to load. Which Power BI tool should be used FIRST to identify which visuals or queri A Power BI developer notices that report performance is slow. The model contains many unnecessary columns that Which statement best describes filter context in DAX? A company wants managers to see only data from their own region in reports. Which Power BI feature should be u In a Star Schema, what is a Dimension Table? What does a KPI visual typically show?