For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeAzure Solutions Architect Expert (AZ-305)Azure Solutions Architect Expert AZ-305 Practice Exam 4Question 23
    Medium1 markMultiple Choice
    Domain 2.2: Design Data IntegrationData IntegrationSynapseSpark

    AZ-305 · Question 23 · Domain 2.2: Design Data Integration

    Your company receives 500 GB of raw JSON telemetry data daily from IoT devices, stored in Azure Data Lake Storage Gen2.

    You need to design a data integration solution to transform this data into a structured format for reporting. The transformation logic requires complex data cleansing using Python and Spark. The solution must support orchestration of the pipeline and minimize cluster startup times.

    Which Azure service should you recommend?

    Answer options:

    A.

    Azure Data Factory with Mapping Data Flows

    B.

    Azure Synapse Analytics with Spark pools

    C.

    Azure Stream Analytics

    D.

    Azure SQL Database

    How to approach this question

    Look for 'Python and Spark' combined with 'orchestration'. Synapse Analytics provides both pipelines and Spark pools in a unified workspace.

    Full Answer

    B.Azure Synapse Analytics with Spark pools✓ Correct
    Azure Synapse Analytics with Spark pools
    Azure Synapse Analytics provides a unified workspace that includes Synapse Pipelines for orchestration and Apache Spark pools for complex data transformations using Python, Scala, or Spark SQL. It is specifically designed to process large volumes of data from Data Lake Storage.

    Common mistakes

    Choosing Data Factory. While ADF can orchestrate Databricks, Synapse provides a unified experience with built-in Spark pools, reducing complexity.
    Question 22All questionsQuestion 24

    Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 4

    55 questions · hints · full answers · grading

    Sign up freeTake the exam

    More questions from this exam

    Q01CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ02CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ03CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...HardQ04CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...MediumQ05CASE STUDY: Tailspin Toys Tailspin Toys is a global manufacturing company with 50,000 employees ...Hard
    View all 55 questions →