An advantage of implementing ETL rather than ELT

Ability to implement business rules and filter data before analysis

An advantage of implementing ETL in a business

Ability to bring together different sources of data into a warehouse

The main reason for using multiple data sources is?

One data source will not give a full picture of the truth

ETL can only deal with ...

it can only deal with structured data

studbud

BCS Certificate 1.1 and 1.2

16 termsStudBud Administration23 plays

Data Integration - Dashboards, ETL etc

Flashcards16 cardsFPractice quizPHost liveL

Questions 16

Answers

1
Which of these is a non-functional requirement?
Speed
Query
Billing aggregate
Customer data
2
Report visualising progress against KPIs
Virtual machines
SQL Query
Scorecard
Dashboard
3
Which of these is a functional requirement?
Timeliness
Query performance
Speed
Customer billing history
4
Method to ensure improved picture of performance in a business
Filter data
SQL Query
Scorecard
Use multiple sources
5
An advantage of implementing ETL rather than ELT
Ability to implement business rules and filter data before analysis
Transforming data is the quickest part of the process
Can handle unstructured data
Allows dashboards to be created
6
An advantage of implementing ETL in a business
Processing operational data faster
Ability to bring together different sources of data into a warehouse
To align with other businesses
Improved customer billing runs
7
Method to improve the quality and amount of results
Query
Head
Truncating
Filtering
8
If you didn't know what data source to use when building a user interface, which would be best:
All of these would work
Dashboard
Scorecard
Dynamic
9
Accessing and integrating multiple external sources through the internet
Dynamic integration
Scorecard
ETL
Dashboard
10
Cloud computing has been enabled by modern technology allowing
People backing up data online
Virtual machines
Big Tech companies to takeover
High communication speeds
11
Which of these is a non-functional requirement?
Availability
Quality of data
Management opinion
Stakeholder request
12
Report showing the measures achieved versus targets
Dashboard
Scorecard
SQL Query
Virtual machines
13
a strategy performance management tool that can be used by managers to keep track of activities
Transformation
Dashboard
Dynamic Spreadsheet
Scorecard
14
The main reason for using multiple data sources is?
One data source will not give a full picture of the truth
Multiple data sources allow once source to be checked against another
Once data source only increases the likelihood of corruption
Security
15
ETL can only deal with ...
It can deal with both structured and unstructured data
It does not deal with either
it can only deal with structured data
It can only deal with unstructured data
16
Which of these is not a factor of using data from multiple sources?
Data variation
Better security
Increased sample size
Greater market understanding

BCS Certificate 1.1 and 1.2 Flashcards | StudBud