Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.

6.4.4. Analytics & Visualization Questions

Question 14

A company needs to move data from an on-premises Oracle database to Azure Data Lake every night at 2 AM. Which Azure service should orchestrate this data movement?

  • A. Azure Stream Analytics
  • B. Azure Data Factory
  • C. Azure Databricks
  • D. Power BI
Answer: B. Azure Data Factory

Explanation: Data Factory is the orchestration service for scheduled data movement (ETL/ELT). It supports 90+ connectors including Oracle. Stream Analytics is for real-time streaming, not batch. Databricks processes data but doesn't orchestrate movement.

Question 15

An analytics team needs to store raw data files in a location optimized for big data analytics with support for hierarchical directories, fine-grained access control, and efficient folder renames. Which should they use?

  • A. Azure Blob Storage (standard)
  • B. Azure Data Lake Storage Gen2
  • C. Azure Files
  • D. Azure SQL Database
Answer: B. Azure Data Lake Storage Gen2

Explanation: Data Lake Gen2 combines Blob Storage scalability with hierarchical namespace (HNS). HNS enables atomic directory operations and POSIX-style ACLs. Without HNS, renaming a "folder" requires renaming every blob individually.

Question 16

A data analyst needs to query 5 TB of Parquet files stored in Azure Data Lake without loading them into a database. They want to pay only for data scanned. Which Synapse component should they use?

  • A. Dedicated SQL Pool
  • B. Serverless SQL Pool
  • C. Apache Spark Pool
  • D. Synapse Pipelines
Answer: B. Serverless SQL Pool

Explanation: Serverless SQL Pool queries data in-place using T-SQL without provisioning resources. You pay per TB scanned. Dedicated SQL Pool requires provisioned capacity (pay even when idle). Spark Pool is for Python/Scala processing, not ad-hoc SQL.

Question 17

An executive needs a single-page view showing KPIs from three different department reports: Sales, Marketing, and Operations. What Power BI artifact should be created?

  • A. A Power BI Report with three pages
  • B. A Power BI Dashboard
  • C. Three separate Power BI Reports
  • D. A Power BI Dataflow
Answer: B. A Power BI Dashboard

Explanation: Dashboards are single-page summaries that pin tiles from multiple reports. They're designed for executive overview. Reports are multi-page deep-dive documents. The scenario explicitly requests "single-page" combining multiple sources—classic dashboard use case.

Question 18

A data engineer builds reports in Power BI Desktop and needs to share them with the finance team for viewing and collaboration. Where should they publish the reports?

  • A. Power BI Desktop (shared folder)
  • B. Power BI Service
  • C. Power BI Report Server
  • D. Microsoft Excel
Answer: B. Power BI Service

Explanation: Power BI Desktop is the authoring tool; Power BI Service (cloud) is where reports are published for sharing and collaboration. Report Server is for on-premises only. Desktop files cannot be directly shared for collaboration.

Alvin Varughese
Written byAlvin Varughese
Founder•15 professional certifications