Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Your organization keeps hourly clickstream JSON files in an Azure Data Lake Storage Gen2 container. Data engineers must ingest the files, flatten nested JSON arrays, perform several joins, and load the results into Azure SQL Database every hour. They want a managed, code-free service that can orchestrate the workflow, provide visual data-lineage, automatically spin up and shut down compute clusters, and integrate with Azure Monitor-while minimizing operational overhead. Which Azure service best meets these requirements?

  • An Azure Stream Analytics job that processes the JSON files with SQL-style queries

  • An Azure Logic Apps workflow that moves files from ADLS Gen2 to Azure SQL Database

  • Azure Data Factory Mapping Data Flows executed on managed Spark clusters

  • Azure Functions triggered by Event Grid that call stored procedures to load data

Microsoft Azure Solutions Architect Expert AZ-305
Design data storage solutions
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot