ITSS 4351(Exam 2) || Questions and 100% Verified Answers.
Report Viewer correct answers The primary mechanism for viewing reports over the Web.
Report Manager is the name of the website that SSRS sets up. It provides a very clean and neatly
organized user interface for end users. Developers can also embed a Report Viewer control into
both ASP.NET and Windows Forms applications.
Report Builder correct answers The tool that provides users with a front end for ad hoc reporting
against a SQL Server or Analysis Services database. Unlike most ad hoc reporting tools, users of
Report Builder do not need to know Structured Query Language (SQL) or anything about joins
or grouping to create reports.
Report Designer correct answers The tool that takes on the job of building advanced reports.
Although Report Builder does a good job as an ad hoc reporting tool, Report Designer was made
to tackle really advanced reports.
Report Development Lifecycle (Authoring Stage) correct answers During this stage, the report
author defines the report layout and sources of data. For authoring, SSRS maintains all the
features of SS and adds some new features. Report models are metadata models describing the
physical structure and layout of the underlying SQL Server database.
Report Development Lifecycle (Managing Stage) correct answers During this stage, the report
author publishes the report to a central location where it can be managed by a report
administrator in terms of security and delivery. This central location is an SSRS database. After
the report is published, the administrator can use Report Manager, SharePoint, custom written
scripts, third-party tools, or SQL Server Management Studio to manage published reports.
Report Development Lifecycle (Delivery Stage) correct answers During this stage, the report is
distributed to the report's users and is available in multiple output formats. The SSRS retrieval
mechanism enables users to quickly change an output format. SSRS supports various delivery
methods: email, interactively online (usually through a web browser, a portal such as SharePoint,
or custom application), printer (requires custom extension), or file system. If the delivery method
of interest is not available by default from SSRS, you can relatively easily develop custom
delivery extensions.
Per processor correct answers Licenses are paid for each processor on the machine running SQL
Server. This license is optimal for web-facing or business-to-business machines running SQL
Server. It is also helpful for very large user populations.
Server license plus device client access licenses (CALs) correct answers Licenses are paid for the
machine running SQL Server, and for every device connecting to SQL Server. An ideal situation
for this type of licensing (CALs) is kiosks for which there are multiple users per device.
Server license plus user CALs correct answers Licenses are paid for the machine running SQL
Server and per user accessing the machine. This is useful for enterprises in which every user can
access the SQL Server machine for multiple devices.
, ETL INTRO correct answers The data in a Data Warehouse system is loaded with an ETL
(Extract, Transform, Load) tool. As the name suggests, it performs the following three
operations:
- Extracts the data from your transactional system which can be an Oracle, Microsoft, or any
other relational database.
- Transforms the data by performing data cleansing operations, and then,
- Loads the data into the OLAP data Warehouse.
ETL Example correct answers Let us assume there is a manufacturing company having multiple
departments such as sales, HR, Material Management, EWM, etc.
All these departments have separate databases which they use to maintain information w.r.t. their
work.
Each database has a different technology, landscape, table names, columns, etc.
If the company wants to analyze historical data and generate reports, all the data from these data
sources should be extracted and loaded into a Data Warehouse to save it for analytical work.
An ETL tool extracts the data from all these heterogeneous data sources, transforms the data
(like applying calculations, joining fields, keys, removing incorrect data fields, etc.), and loads it
into a Data Warehouse. Later, you can use various Business Intelligence (BI) tools to generate
meaningful reports, dashboards, and visualizations using this data.
Difference between ETL and BI Tools correct answers An ETL tool is used to extract data from
different data sources, transform the data, and load it into a DW system; however a BI tool is
used to generate interactive and ad-hoc reports for end-users, dashboard for senior management,
data visualizations for monthly, quarterly, and annual board meetings.
The most common ETL tools include: SAP BO Data Services (BODS), Informatica - Power
Center, Microsoft - SSIS, Oracle Data Integrator ODI, Talend Open Studio, Clover ETL Open
source, etc.
Some popular BI tools include: SAP Business Objects, SAP Lumira, IBM Cognos, JasperSoft,
Microsoft BI Platform, Tableau, Oracle Business Intelligence Enterprise Edition, etc
ETL - Extraction correct answers It involves extracting the data from different heterogeneous
data sources. Data extraction from a transactional system varies as per the requirement and the
ETL tool in use. It is normally done by running scheduled jobs in off-business hours like running
jobs at night or over the weekend.
ETL- Transformation correct answers It involves transforming the data into a suitable format that
can be easily loaded into a DW system. Data transformation involves applying calculations,
joins, and defining primary and foreign keys on the data. For example, if you want % of total
revenue which is not in database, you will apply % formula in transformation and load the data.
