Azure Solutions Architect Expert
Domain 2Objective 3
Design Data Integration AZ-305 Practice Questions (Page 3)
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 11–15
- 11
A company uses Dynamics 365 and needs to automatically update a SQL Server database on-premises whenever a new opportunity is created in Dynamics. The solution must be low-code and support on-premises connectivity. Which service should you use?
Select an answer first - 12
A logistics company uses Azure Data Factory to load data from a CSV file in Azure Blob Storage into an Azure Synapse Analytics dedicated SQL pool. The pipeline runs daily. Recently, the source file format changed to include an extra column. The pipeline now fails. What should you do to handle the schema change?
Select an answer first - 13
A financial services company needs to integrate data from multiple sources: an on-premises SQL Server, a SaaS application with a REST API, and a third-party data feed. The integration must run on a schedule and transform the data before loading into Azure SQL Database. The company wants to minimize the number of services to manage. What should you use?
Select an answer first - 14
A solution architect needs to recommend a service that can query data directly from files in Azure Data Lake Storage without loading the data into a database. The queries should be written in T-SQL and the service should be billed based on the amount of data processed. Which capability of Azure Synapse Analytics should the architect use?
Select an answer first - 15
A solution architect is designing a data integration solution that must ingest data from multiple sources, including Azure Blob Storage, an on-premises FTP server, and a SaaS application. The solution must also orchestrate the data flow and handle failures with retries. Which Azure service should the architect use?
Select an answer first
Finished these 5 questions?
Review the revealed explanations, or continue through the curriculum.
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.