Which data source type should you use?

HOTSPOT
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular
database configured in DirectQuery mode.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.

HOTSPOT
You are developing a SQL Server Reporting Services (SSRS) solution.
You plan to create reports based on a SQL Server Analysis Services (SSAS) tabular
database configured in DirectQuery mode.
You need to configure a shared data source.
Which data source type should you use?
To answer, select the appropriate type from the drop-down list in the answer area.

Answer:

Explanation:

Show Hint

Leave a Reply 3

Your email address will not be published. Required fields are marked *

SZ

SZ

OLEDB

Reply

Miguel

Miguel

Agree

Reply

Jane

Jane

Why? Can’t find any MSDN source material that explains why OleDB is the answer. Based on my research there is nothing that says Microsoft SQL Server datasource wouldn’t work.

Reply