ICTDBS601: Complete Solution to Data Warehouse Written Test

This document presents a solution to a written test for the ICTDBS601 Build a Data Warehouse unit. It covers key concepts such as the definition of a data warehouse, differences between databases and data warehouses, different types of databases suitable for building a data warehouse (Oracle, Cloud, NoSQL), the purpose of a database design document, strategies for confirming database design, relevant documents for informing the design, potential clients for a data warehouse, the relationship between knowledge management and data warehouse strategies, security plans and common threats, benefits of a well-managed data warehouse, information gathering methods, required communication skills, principles of user interface design, and the relationship between big data and data warehousing. References to relevant books and journals are also included. Desklib offers more solved assignments and past papers for students.

ASSESSMENT 1 – Written Test
This cover sheet is to be completed by the assessor and used as a record of outcome of this assessment task.
Student Name:
Student ID No:
Unit Title: Build a data warehouse
Date of Submission:
Student Declaration I declare that:
 These tasks are my own work, and none of this
work has been completed by any other
person.
 These tasks are not plagiarised or colluded
with any other student/s.
 I have correctly referenced all resources and
reference texts throughout these
assessment tasks.
 I have read and understood the policy on
Plagiarism, cheating and collusion and understand
that if I am found to be in breach of this policy,
disciplinary action may be taken against me.
 I have a copy of my assessment work with
me, which I can produce if the original is lost.
Student name: Signature:
Date: / /
Assessment No: 1 Satisfactory / Not Satisfactory
Assessment Type: Written Test
Comments/ Feedback (If the student is deemed Not Satisfactory the Assessor MUST state the circumstances and reasons
why this judgment has been made):
Assessor Declaration:
I declare that I have conducted a fair, valid, reliable, and flexible assessment with this student, and I have provided
appropriate feedback.
Assessor Name: Signature:
Date: / /

ASSESSMENT 1 – WRITTEN TEST
Questions:
1. Define a data warehouse.
It refers as the type of data management system, which is usually developed to enable and cooperate the
business intelligence. This system is solely intended to lay out the queries and also stored the huge
amount of historical data (Dehdouh, Boussaid and Bentayeb, 2020). Warehousing makes the data
mining efficient and possible, which helps the businesses to look into the data pattern, it provides
forward path, so that businesses makes the efficient decision in order to maximize the sales and profit.
2. Describe the differences between a database and a data warehouse.
Databas
e
Data
Warehouse
An database define as a system that collects and
organize the data which can be easily retrieved
and accessed.
Data warehouse is a “type of database”, it generally
integrates the transactional data and provide them it
for analytical use.
It is developed for storing or records the data. It is created for analyzing the data.
It is application oriented system for collecting
data.
Data warehouse is subject oriented data collection.
Student Instructions: Time Allowed: 3 Hour
This is an open book written assessment. In the time allocated, you are to answer all of the following
questions. Make sure you:
Print Clearly
Answer all questions
Do not use any sheet to answer other than the provided
Use only black or blue pen to write assessment
Ask your assessor if you do not understand a question. Whist your assessor cannot tell you the answer,
he/she may be able to re-word the question for you

It usually uses the OLTP which is “online
transactional processing”
It uses the OLAP that is “ Online analytical
processing”

3. List four different databases that can be used to build a data warehouse. What are the features of
each?
1. Oracle database: It gives the data warehousing and analytics through which the businesses can
easily look into the data, that helps in efficient decision making process. Its features are scalability
and efficient performance, backup, security. It gives the availability of the data when there is
downtime or failures.
SQL: For designing the data warehouse, by using the SQL components to implement the design for
warehouse. Its features are It keeps the computing process separate from the storage, it can also used
to scaling up and down the computations (Al Faris and Nugroho, 2018).
2. Cloud database: It manage the services in a public cloud which processed the business
intelligence and analytics, because it is found that data present in cloud data warehouse are
present in structured form. Its features are it offers the flexibility is SQL query, it offers the
complete data extraction.
3. NO SQL database: It enables to consider the various approaches for warehousing the data, which
can be from the multidimensional data. Its features are as it stores the data in a various models
such as in JSON, BSON, it gives the data in structured form.
4. Describe the purpose of a database design document.
Main purpose of database design document is that it efficiently maps the logical data mode to targets the
DBMS to accounts the system performance and its requirements. It helps in transforming the conceptual
data model. Documentation provides the functional and also nonfunctional utilization of the records,
tables and other key considerations. Thus it is essential to document to fulfill the several needs, such as
it enables the common language among the businesses and IT personnel, with this they can easily
understand the flow chart that leads in making decision.

5. Describe the strategy that you would use to confirm the database design of a data warehouse.
Mention the sequence you would follow.
It usually views the data warehouse as database system which made to answer queries, main purpose of
the designing is to analyses how the r4ecorded data which can be from different data sources should
extracted.
Top down design strategy: It initiated from the general moves to specific move. In this data warehouse
is define as the subject oriented, in which system stores the atomic information, in this data is collected
and integrated first.
Sequences are to analyze the business objectives, gathers information then finding the business core
approaches. After this development of conceptual data begins and then tracking duration to implement
plan.
6. List the documents that might inform the database design
A document refers as the record, which usually collects the data about objects and its metadata, it stores
the data values in pairs that can be of structure type, string type, arrays. For documenting the database
design there are certain tools which are word processor, spreadsheet. Document can also be written
using the Entity relationship diagram explanation which highlights the utilization of table, columns and
their relationship with other tables.

7. Describe potential clients for a data warehouse.
Data warehouse is needed by the user who wants to make efficient decision, such as business man, users
Who requires customized and complicated processed to gathers the data from various sources. It also
needed by the customer who prefers the simplest technologies to access the data. Most of the clients are
business bodies who wants that their information should stores in files and documents so that it can be
used further for making decisions (Gunawan and Kurnia, 2018).

8. Describe the relationship between the organisation’s knowledge management strategy and a data
warehouse.
Organizational knowledge management strategy helps in balancing the work culture and to develop the
timely business capabilities. Knowledge management organize the data in a systematical order which
can be easily accessed by the employees. As to store the data can be beneficial to make the futuristic
decision.
9. Describe the relationship between the organisation’s security plan and the data warehouse. Mention
common security threats.
Data warehouse security allows to make the necessary step for preventing the information from any
malicious attacks. Its services involves the stricter user control, only who manage the data warehouse
can have the access. Some common threats are internal and external DW threat, phishing, malware.
Organization uses the encrypted data services, and cloud data techniques to protect the data.

10. Describe the benefits to an organisation of a well managed data warehouse.
It is beneficial for the businesses to maintain their data warehouse; it will allow them to easily access the
information. It enables in enhancing the performance, as cloud data warehouse offers the great speed
and flexibility, it also offers the sheer backup protection. With this organization can easily analyses the
insight view that guides them in making good marketing strategies which allows them to compete with
their rivalries. As by efficiently feeding the contextual data to BI software, it drives productive data
strategy.
11. Describe at least four information gathering methods that could be used to ensure that the data
warehouse will meet the needs of users.
1 Interview: It gives the face to face interaction with the user and one of the optimum solution for
collecting the data that can be stored and further use for betterment.
2 Barcode: By using barcode, one requires to scan barcode that are available on inventory, it
automatically captures the information, as for the transaction it stores the data like receiving, issuing
and picking.
3 Work in target environment: Working with the target users help in identifying their needs, so that
there queries solution can be made by analyzing the data.
4 Organize workshops: These are the better option for analyzing the requirements, it reduces the
time consumption, but usually it is expensive data collection method.
12. Describe the communication skills required to liaise effectively with users and technical staff.
Communication skills plays an crucial role as it helps in conveying the message clearly. It is the key tool
that helps in increasing the productivity of any process. Thus for an example if the company is selling a
tech savvy product, in such it is their responsibility to give information to customer about product, thus

user will enable to make purchase (Friedrichs, 2021). As for the technical staff, there work consists of
the complexities which means they must have to interact with their colleagues to find the solution,
otherwise it will cause hindrance in their work.

13. Summaries the principles of effective user interface design.
Principles of user interface design helps in enhancing the Quality, it should be simple and clears so that
it can be understood by the user.
Visibility: It means to optimizing the design elements that meets the goals of the user. Design should
consists of all the required options that allow the user to interact with system without any distractions.
Consistency: This principle is about as what makes it easy for the clients to develop sense what they are
seeing on system interface.
14. Describe the term ‘big data’ and state how it relates to data warehousing.
Big data is the technology that manage and analyses the large amount of data. As it is impossible for the
traditional tools to processed the large data, thus this big data is introducing for processing the large data
set. As data warehouse collects the historical data, where it uses to develop the insight view of the data.
Big data and data warehouse are the different topic, both can be used by the organization on the basis of
their requirements (Nadikattu, 2019).

REFERENCES
Books and journals
Al Faris, F.Z. and Nugroho, A., 2018, September. Development of data warehouse to improve services in IT
services company. In 2018 International Conference on Information Management and Technology
(ICIMTech) (pp. 483-488). IEEE.
Dehdouh, K., Boussaid, O. and Bentayeb, F., 2020. Big data warehouse: Building columnar nosql OLAP
cubes. International Journal of Decision Support System Technology (IJDSST. 12(1). pp.1-24.
Friedrichs, M., 2021. BioDWH2: an automated graph-based data warehouse and mapping tool. Journal of
integrative bioinformatics. 18(2). pp.167-176.
Gunawan, A. and Kurnia, S.G., 2018, September. Knowledge Management Study in Data Warehouse.
In 2018 International Conference on Information Management and Technology (ICIMTech) (pp. 1-
5). IEEE.
Nadikattu, R.R., 2019. Data Warehouse Architecture–Leading the Next Generation Data Science. Rahul
Reddy Nadikattu" Data Warehouse Architecture–Leading the next generation Data Science"
International Journal of Computer Trends and Technology. 67(2019). pp.78-80.

ASSESSMENT 1 CHECKLIST
Questions Satisfactory
Question 1  Yes  No
Question 2  Yes  No
Question 3  Yes  No
Question 4  Yes  No
Question 5  Yes  No
Question 6  Yes  No
Question 7  Yes  No
Question 8  Yes  No
Question 9  Yes  No
Question 10  Yes  No
Question 11  Yes  No
Question 12  Yes  No
Question 13  Yes  No
Question 14  Yes  No
RESULT: S | NS
S= Satisfactory |
NS= Not Satisfactory