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 flexible queries.
You need to choose the connection type for the data source.
Which connection type should you choose?
A.
XML
B.
Microsoft Azure SQL Database
C.
Microsoft SharePoint List
D.
ODBC
B?
Not B – its going to Azure Marketplace not an Azure SQL Server Database.
A is correct I think.
A is correct
If we would use sql azure database than B would be OK.
But we are using data from azure datamarket. Here data is available in ODATA format which is a specific XML. Also a query would be encapsulated in XML (you can specify filters, authentication and so on)
https://msdn.microsoft.com/en-us/magazine/gg309173.aspx
https://msdn.microsoft.com/en-us/library/dd220468.aspx
If we would use sql azure database… but we are not.
Data in azure datamarket is available in OData format what is a kind of XML. Also query ia an XML, where you can put information what data should be downloaded, which authentication to use, which filter to apply. So XML is correct answer.