nerdexam
Microsoft

70-466 · Question #100

You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?

The correct answer is B. Use the Windows Azure SQL Database data source type and then set a username and password for the credentials. SSRS requires the correct data source type and compatible authentication method when connecting to Azure SQL Database.

Build reports

Question

You need to develop an SSRS report that retrieves currency exchange rate data. How should you configure the data source for the report?

Exhibit

70-466 question #100 exhibit

Options

  • AUse the Windows Azure SQL Database data source type and then set Windows authentication for the credentials.
  • BUse the Windows Azure SQL Database data source type and then set a username and password for the credentials.
  • CUse the SQL Server data source type and then set a username and password for the credentials.
  • DUse the SQL Server data source type and then set Windows authentication for the credentials.

How the community answered

(50 responses)
  • A
    2% (1)
  • B
    94% (47)
  • C
    4% (2)

Why each option

SSRS requires the correct data source type and compatible authentication method when connecting to Azure SQL Database.

AUse the Windows Azure SQL Database data source type and then set Windows authentication for the credentials.

Windows Authentication is not supported by Azure SQL Database - it requires SQL authentication or Azure Active Directory authentication, making this credential type incompatible.

BUse the Windows Azure SQL Database data source type and then set a username and password for the credentials.Correct

Azure SQL Database requires the 'Windows Azure SQL Database' data source type in SSRS to use the appropriate connection driver and features. Windows Authentication (Kerberos/NTLM) is not supported for Azure SQL Database, so SQL authentication with a username and password must be used instead. This combination ensures SSRS can authenticate and connect successfully to the cloud-hosted database.

CUse the SQL Server data source type and then set a username and password for the credentials.

The SQL Server data source type targets on-premises SQL Server instances and does not use the driver optimized for Azure SQL Database connectivity.

DUse the SQL Server data source type and then set Windows authentication for the credentials.

The SQL Server data source type is incorrect for Azure SQL Database, and Windows Authentication is also unsupported in that environment, making both configuration choices wrong.

Concept tested: SSRS data source configuration for Azure SQL Database

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

Topics

#Azure SQL Database#SSRS data source#credentials#SQL Azure

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-466 Practice