DRAG DROP
You are designing a SQL Server Reporting Services (SSRS) solution.
A report project must access multiple SQL Azure databases. Each database is on a different
host. The databases have identical schema and security configurations.
You have the following requirements:
• The report must support subscriptions.
• Users must be able to select the host when running the report.
What should you do?
To answer, drag the appropriate phrase or phrases from the list to the correct location or
locations in the answer area. (Answer choices may be used once, more than once, or not
all.)
Answer: 
Explanation:
Note:
PassCertification.com- 70-467 Exam Questions and Answers 2
* To include data in a report, you must first createdata connections, also known asdata
sources, and then create datasets.
* A data connection includes the data source type, connection information, and the type of
credentials to use. There are two types of data sources: embedded and shared. An
embedded data source is defined in the report and used only by that report (fits this
scenario). A shared data source is defined independently from a report and can be used by
multiple reports.
* Built-in data extensions include the following data connection types:
• Microsoft SQL Server
• Microsoft SQL Server Analysis Services
• Microsoft SharePoint List
• Windows Azure SQL Database
Etc.
* Expression-based connection strings are evaluated at run time. For example, you can
specify the data source as a parameter, include the parameter reference in the connection
string, and allow the user to choose a data source for the report.
* Credentials You provide the credentials that are needed to access the data. The data
source owner must have granted you the appropriate permissions to access both the data
source and the specific data on the data source.
Data Connections, Data Sources, and Connection Strings (SSRS)
6, 2, 7, 4
The info mentioned in the report are some of the most beneficial readily available.
Check below, are some absolutely unrelated internet sites to ours, however, they’re most trustworthy sources that we use.
always a huge fan of linking to bloggers that I like but dont get quite a bit of link love from
Correct!
https://docs.microsoft.com/en-us/sql/reporting-services/report-data/data-connections-data-sources-and-connection-strings-report-builder-and-ssrs
Zyta is on the money, correct link provided.
1. Create Embedded Data Source in the Report.
2. Create Parameter so the users can choose the SQL Azure DB/Host they need.
3. Create an expression-based connection string to link the Parameter to the Data Source Connection.
4. Report must support Subscriptions so Data Source must use Stored Credentials.
https://docs.microsoft.com/en-us/sql/reporting-services/report-data/manage-report-data-sources
Just passed this exam in January after many years of trying, it is a very hard exam to pass, like all other Microsoft Exams. Even when you have the experience, skills, and knowledge, you must prepare well in order to pass. Download the free version of the Microsoft Tools and practice as much as possible, use index cards and memorize. These questions are a great study guide as these are in fact on the exam. Good luck!