nerdexam
Microsoft

70-467 · Question #54

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

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.

Design a reporting solution

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

How the community answered

(64 responses)
  • A
    3% (2)
  • B
    89% (57)
  • C
    6% (4)
  • D
    2% (1)

Why each option

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.

AOData

OData is a REST-based protocol designed for consuming web service feeds and is not appropriate for a direct relational SQL Server database connection.

BMicrosoft SQL ServerCorrect

The Microsoft SQL Server connection type in SSRS uses the System.Data.SqlClient managed provider, which is purpose-built for SQL Server and natively supports stored procedures, T-SQL syntax, integrated Windows authentication, and connection pooling. It is the recommended and most performant option for SQL Server databases and provides full compatibility with all SQL Server engine features used in reporting.

CODBC

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.

DOLE DB

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

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

Topics

#SSRS data source#SQL Server connection#shared data source#data connection type

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice