Question 1 of 30
A financial analyst is tasked with creating a Power BI report that needs to display real-time data from a large SQL database containing millions of records. The analyst is considering two data connectivity options: DirectQuery and Import mode. Given the requirement for real-time data access and the potential performance implications, which approach should the analyst choose to ensure optimal performance while maintaining the ability to analyze the most current data?
DirectQuery
Import mode
A hybrid approach using both modes
Using a dataflow to preprocess data

Preparing for Microsoft PL-400 Microsoft Power Platform Developer? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free