100% tevredenheidsgarantie Direct beschikbaar na je betaling Lees online óf als PDF Geen vaste maandelijkse kosten
logo-home
Eerder door jou gezocht
Eerder door jou gezocht
logo
ITSS 4351(Exam 2) || Questions and 100% Verified Answers. €10,84
In winkelwagen
Snel navigeren naar
Voorbeeld
  2.  
  3. ITSS 4351
  4.  
  5. ITSS 4351

Tentamen (uitwerkingen)

ITSS 4351(Exam 2) || Questions and 100% Verified Answers.
 0 keer verkocht
  • Vak
  • ITSS 4351
  • Instelling
  • 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...

[Meer zien]

Voorbeeld 2 van de 7  pagina's

Document informatie

  • 23 augustus 2024
  • 7
  • 2024/2025
  • Tentamen (uitwerkingen)
  • Vragen en antwoorden

Onderwerpen

  • report viewer

Geschreven voor

  • ITSS 4351
  • ITSS 4351

Verkoper

avatar-seller
FullyFocus

Ontvangen beoordelingen

Voorbeeld van de inhoud

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.

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper FullyFocus. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €10,84. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 69411 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis
€10,84
  • (0)
In winkelwagen
Toegevoegd