70-466 · Question #139
You are developing a SQL Server Reporting Services (SSRS) report for a company that has a subscription to a dataset from the Microsoft Azure Data Market. The dataset permits textbox queries. You need
The correct answer is A. XML. Azure Data Market datasets expose data as OData feeds, and SSRS connects to OData sources using the XML data extension, which supports textbox-style OData queries.
Question
Options
- AXML
- BMicrosoft Azure SQL Database
- CMicrosoft SharePoint List
- DODBC
How the community answered
(40 responses)- A93% (37)
- B3% (1)
- D5% (2)
Why each option
Azure Data Market datasets expose data as OData feeds, and SSRS connects to OData sources using the XML data extension, which supports textbox-style OData queries.
The SSRS XML data extension supports OData protocol in addition to standard XML sources, making it the correct connection type for Azure Data Market. When the dataset 'permits textbox queries,' it means OData query strings can be entered directly in the query designer's textbox mode, and the XML extension is the SSRS data extension that handles these OData/Atom-formatted responses from the Data Market.
Microsoft Azure SQL Database is a relational database connection type for Azure SQL, not for OData-based Data Market feeds.
Microsoft SharePoint List connects to SharePoint list data using the SharePoint REST API and is unrelated to Azure Data Market OData feeds.
ODBC is a generic relational database connectivity standard and cannot consume OData REST endpoints provided by the Azure Data Market.
Concept tested: SSRS XML data extension connecting to OData feeds
Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/xml-connection-type-ssrs
Topics
Community Discussion
No community discussion yet for this question.