100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
ITSS 4351(Exam 2) || Questions and 100% Verified Answers. $10.99   Add to cart

Exam (elaborations)

ITSS 4351(Exam 2) || Questions and 100% Verified Answers.

 9 views  0 purchase
  • Course
  • ITSS 4351
  • Institution
  • ITSS 4351

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 Wind...

[Show more]

Preview 2 out of 7  pages

  • August 23, 2024
  • 7
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • ITSS 4351
  • ITSS 4351
avatar-seller
FullyFocus
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.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller FullyFocus. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $10.99. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

67163 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$10.99
  • (0)
  Add to cart