70-467 Question #54: Real Exam Question with Answer & Explanation

The correct answer is B: Microsoft SQL Server. For a shared SSRS data source connecting to SQL Server, the Microsoft SQL Server connection type uses the native SqlClient managed provider, which offers the best performance and full SQL Server feature support.

Question

You need to create the Sales Reporting shared SSRS data source. Which SSRS data connection type should you use?

Options

AOData
BMicrosoft SQL Server
CODBC
DOLE DB

Explanation

For a shared SSRS data source connecting to SQL Server, the Microsoft SQL Server connection type uses the native SqlClient managed provider, which offers the best performance and full SQL Server feature support.

Common mistakes.

A. OData is a REST-based protocol designed for consuming web service feeds and is not appropriate for a direct relational SQL Server database connection.
C. ODBC is a generic connectivity layer that introduces an additional translation overhead and lacks native SQL Server feature support compared to the dedicated Microsoft SQL Server provider.
D. OLE DB is an older COM-based data access technology with reduced support in newer versions of SSRS and SQL Server, and it is not the recommended provider for SQL Server reporting connections.

Concept tested. SSRS shared data source connection type for SQL Server

Reference. https://learn.microsoft.com/en-us/sql/reporting-services/report-data/sql-server-connection-type-ssrs

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice