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

Questions 6–10

1. 6application · medium

   A manufacturing company uses Azure Synapse Analytics to store sensor data from factory equipment. Data engineers run SQL queries to analyze machine performance. The company wants to provide business analysts with a way to create interactive reports without writing SQL. What should you do?

   • AConnect Power BI to the Synapse Analytics SQL pool and let analysts build reports using Power BI Desktop.
   • BGive analysts direct access to the Synapse SQL pool and require them to write SQL queries.
   • CUse Azure Data Factory to copy Synapse data to a SharePoint list for analysts to view.
   • DCreate a Databricks notebook that generates static CSV files for analysts to open in Excel.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   An organization needs to automate a business process that sends an approval email when a new file is uploaded to a SharePoint site, and then updates a record in a CRM system. Which Azure service is best suited for this integration scenario?

   • AAzure Logic Apps
   • BAzure Databricks
   • CAzure Data Factory
   • DAzure Synapse Analytics
   Reveal Solution Discussion Select an answer first
4. 8foundation · easy

   A data science team wants to use a trained machine learning model to score new data that is stored in Azure Data Lake Storage. They plan to use Azure Databricks for data preparation and then call the model for predictions. Which Azure service should they integrate with Databricks to manage the model lifecycle and deploy the model as a web service?

   • APower BI
   • BAzure Machine Learning
   • CAzure Logic Apps
   • DAzure Synapse Analytics
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A nonprofit organization uses Azure Logic Apps to process donation forms submitted via a website. The Logic App is triggered by an HTTP request, validates the form data, and then inserts a record into a SQL database. The organization wants to add a step to send a confirmation email to the donor. What should you do?

   • AModify the website code to send the email directly.
   • BCreate a separate Logic App for the email and trigger it from the first Logic App.
   • CUse a custom Azure Function to send the email and call it from the Logic App.
   • DAdd an Office 365 Outlook connector action to send the email after the SQL insert.
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A telecommunications company needs to analyze call detail records (CDRs) stored in Azure Data Lake Storage. The data volume is large (petabytes) and the analysis requires complex transformations using Spark. The company also wants to run ad-hoc SQL queries on the same data. What should you use?

   • AUse only Azure Synapse Analytics with Spark pools for both transformations and SQL queries.
   • BUse only Azure Databricks with SQL analytics for both transformations and SQL queries.
   • CUse Azure Databricks for the Spark transformations and Azure Synapse Analytics for the SQL queries.
   • DUse Azure Data Factory to transform the data and then load it into a SQL database for queries.
   Reveal Solution Discussion Select an answer first