nerdexam
Microsoft

AZ-204 · Question #57

Member of the finance department for a company review and make changes to a Microsoft Excel workbook that is hosted on OneDrive. The workbook contains projected costs and revenue for a project. You…

The correct answer is B. A group subscription E. An Excel table input binding. To ingest data from a modified Excel workbook on OneDrive into an Azure Function, you need a mechanism to trigger the function upon modification and a way to read the Excel data.

Submitted by suresh_in· Mar 30, 2026Connect to and consume Azure services and third-party services

Question

Member of the finance department for a company review and make changes to a Microsoft Excel workbook that is hosted on OneDrive. The workbook contains projected costs and revenue for a project. You need to develop an Azure Function that ingests data from the modified workbook and place it into a Microsoft Word document. Which two objects should you implement? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Options

  • AAn auth token input binding
  • BA group subscription
  • CAn Excel table output binding
  • DA group conversation subscription
  • EAn Excel table input binding

How the community answered

(66 responses)
  • A
    14% (9)
  • B
    74% (49)
  • C
    5% (3)
  • D
    8% (5)

Why each option

To ingest data from a modified Excel workbook on OneDrive into an Azure Function, you need a mechanism to trigger the function upon modification and a way to read the Excel data.

AAn auth token input binding

An auth token input binding facilitates token acquisition for authentication but does not directly handle data ingestion or triggering based on file modification.

BA group subscriptionCorrect

A group subscription, specifically a Microsoft Graph webhook configured for a drive item within a Microsoft 365 group, can notify the Azure Function when the Excel workbook is modified, triggering the data ingestion process.

CAn Excel table output binding

An Excel table output binding is used for writing data *to* an Excel table, whereas the requirement is to *ingest data from* the workbook.

DA group conversation subscription

A group conversation subscription is used for notifications related to conversations within a group (e.g., chat messages), not for file modifications.

EAn Excel table input bindingCorrect

An Excel table input binding (implemented through integrating Microsoft Graph API within the function) enables the Azure Function to programmatically read and ingest specific data from a designated table within the Excel workbook.

Concept tested: Azure Function Microsoft Graph integration and event-driven processing

Source: https://learn.microsoft.com/en-us/graph/api/subscription-post-subscriptions?view=graph-rest-1.0

Topics

#Azure Functions#Microsoft Graph#Excel bindings#OneDrive integration

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-204 Practice