Crucial Exams

Microsoft Azure Solutions Architect Expert AZ-305 Practice Question

Your company stores transactional data in Azure SQL Database and semi-structured data as Parquet files in Azure Data Lake Storage Gen2. Data scientists want to run ad-hoc T-SQL queries that can join the Parquet files with snapshots of the relational data, create quick visualizations in Power BI, and avoid provisioning or managing any clusters. They are willing to copy a small subset of the Azure SQL Database tables into the lake on demand but do not want a nightly ETL schedule. Which Azure service best meets these requirements while keeping administration and cost to a minimum?

  • Create an Azure Synapse Analytics workspace and use the built-in serverless SQL pool to query the data lake and exported relational snapshots.

  • Build an Azure Stream Analytics job that outputs the combined data to Power BI for interactive reporting.

  • Deploy Azure Data Factory pipelines to copy all data into a dedicated SQL pool and schedule nightly batch processing.

  • Provision Azure Analysis Services and import both data sets into a tabular model for reporting.

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