nerdexam
Microsoft

70-466 · Question #59

You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset. You need to include additional data sourced from a SQL Server database

The correct answer is B. Create a SQL Azure data source and then add a dataset that uses the new data source.. To include data from a different database in an SSRS report, you must create a new data source of the appropriate type and then add a dataset referencing it.

Build reports

Question

You are designing a SQL Server Reporting Services (SSRS) report. The report defines a single SQL Server data source and dataset. You need to include additional data sourced from a SQL Server database in the report. What should you do?

Options

  • ACreate a SQL Azure dataset that uses the existing data source.
  • BCreate a SQL Azure data source and then add a dataset that uses the new data source.
  • CCreate a SQL Server data source and then add a dataset that uses the new data source.
  • DGenerate an Atom-compliant data feed for the report.

How the community answered

(46 responses)
  • A
    2% (1)
  • B
    93% (43)
  • C
    4% (2)

Why each option

To include data from a different database in an SSRS report, you must create a new data source of the appropriate type and then add a dataset referencing it.

ACreate a SQL Azure dataset that uses the existing data source.

A SQL Azure dataset cannot use a SQL Server data source because the connection types and authentication mechanisms are incompatible.

BCreate a SQL Azure data source and then add a dataset that uses the new data source.Correct

When the additional data resides in an Azure SQL (SQL Azure) database, you must create a new SQL Azure data source with its own connection string and credentials, since the existing SQL Server data source targets a different server or instance. Once the new data source is defined, you create a dataset that references it to retrieve the additional data. Reusing the existing data source is not possible when the connection target differs.

CCreate a SQL Server data source and then add a dataset that uses the new data source.

A standard SQL Server data source type is not the correct choice for connecting to an Azure SQL (SQL Azure) database, which requires its own data source type.

DGenerate an Atom-compliant data feed for the report.

An Atom-compliant data feed is an output format for exporting report data, not a mechanism for consuming additional database data within a report.

Concept tested: SSRS adding additional data sources and datasets

Source: https://learn.microsoft.com/en-us/sql/reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs

Topics

#SSRS data sources#datasets#SQL Server#report data configuration

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice