A company uses Azure Logic Apps to automate a business process that involves multiple systems: an on-premises SQL Server, a SaaS CRM, and an email service. The process must handle errors gracefully and retry failed steps. The company wants to minimize development effort. What should you do?

Use Azure Databricks to orchestrate the process with notebooks.

Use Azure Functions with a custom retry mechanism and call them from Logic Apps.

Use Azure Data Factory with a self-hosted integration runtime and a retry activity.

Use the built-in retry policy and scope actions to handle errors within the Logic App.

A healthcare company uses Azure Synapse Analytics to store patient data. They want to use Azure Machine Learning to build a predictive model for patient readmission. The data science team wants to use the data in Synapse without copying it to another store. What should you do?

Use Power BI to train the model and then deploy it to Azure Machine Learning.

Export the data from Synapse to a CSV file and upload it to Azure Machine Learning.

Use Azure Databricks to read from Synapse and then train the model in Databricks.

Use Azure Machine Learning's data store to connect directly to Synapse and create a dataset for training.

A company uses Azure Logic Apps to integrate a SaaS application with an on-premises database. The integration must handle occasional large payloads (up to 50 MB) and ensure reliable delivery. The current Logic App uses the HTTP connector and times out. What should you do?

Increase the timeout setting on the HTTP action.

Use Azure Functions to handle the payload and call the database.

Switch to Azure Data Factory for the integration.

Use the on-premises data gateway with the SQL Server connector in Logic Apps.

Azure Solutions Architect Expert

Domain 2Objective 3

Design Data Integration AZ-305 Practice Questions (Page 4)

Part of the Design data storage solutions domain, which makes up ~25% of our current practice bank. Microsoft does not publish an official question count, but from its 120-minute exam (~50–80 total, ~13–20 in this domain), expect 4–7 from this objective — we provide 28 practice questions to prepare you well beyond it. (estimate)

28questions here

6free pages

7concepts

Questions 16–20

16expert · hard
A company uses Azure Logic Apps to automate a business process that involves multiple systems: an on-premises SQL Server, a SaaS CRM, and an email service. The process must handle errors gracefully and retry failed steps. The company wants to minimize development effort. What should you do?
Select an answer first
17foundation · easy
A data science team wants to use Apache Spark to run distributed machine learning training jobs and collaborate using shared notebooks. They also need to integrate with Azure Active Directory for single sign-on. Which Azure service provides these capabilities with a fully managed Spark environment?
Select an answer first
18application · medium
A healthcare company uses Azure Synapse Analytics to store patient data. They want to use Azure Machine Learning to build a predictive model for patient readmission. The data science team wants to use the data in Synapse without copying it to another store. What should you do?
Select an answer first
19foundation · easy
A data science team needs a collaborative environment where they can write Python and Scala code, run Spark jobs, and create interactive dashboards for machine learning experiments. Which Azure service is best suited for this advanced analytics workload?
Select an answer first
20expert · hard
A company uses Azure Logic Apps to integrate a SaaS application with an on-premises database. The integration must handle occasional large payloads (up to 50 MB) and ensure reliable delivery. The current Logic App uses the HTTP connector and times out. What should you do?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to AZ-305

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “AZ-305” is a trademark of its owner, used for identification only.

Design Data Integration AZ-305 Practice Questions (Page 4)

Questions 16–20

A company uses Azure Logic Apps to automate a business process that involves multiple systems: an on-premises SQL Server, a SaaS CRM, and an email service. The process must handle errors gracefully and retry failed steps. The company wants to minimize development effort. What should you do?

A data science team wants to use Apache Spark to run distributed machine learning training jobs and collaborate using shared notebooks. They also need to integrate with Azure Active Directory for single sign-on. Which Azure service provides these capabilities with a fully managed Spark environment?

A healthcare company uses Azure Synapse Analytics to store patient data. They want to use Azure Machine Learning to build a predictive model for patient readmission. The data science team wants to use the data in Synapse without copying it to another store. What should you do?

A data science team needs a collaborative environment where they can write Python and Scala code, run Spark jobs, and create interactive dashboards for machine learning experiments. Which Azure service is best suited for this advanced analytics workload?

A company uses Azure Logic Apps to integrate a SaaS application with an on-premises database. The integration must handle occasional large payloads (up to 50 MB) and ensure reliable delivery. The current Logic App uses the HTTP connector and times out. What should you do?

Keep studying — Design data storage solutions