Question 1

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 2

Within the data warehouse model,the external databases are competitor information,industry information,mailing lists and stock market analysis.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following asks users to write lines of code to answer questions against a database?

Accepted Answer

A)   Structured query language
B)   Relational query language
C)   Structured elements
D)   Data mining toolsE) A) and B)
F) A) and C)

Question 4

Relational integrity constraints enforce business rules vital to an organisation's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 5

A data mart is the process of analysing data to extract information not offered by the raw data alone.

Accepted Answer

A) True 
 B)False  False

Question 6

Data __________ issues occur when a system produces incorrect,inconsistent or duplicate data.

Accepted Answer

The answer of Data __________ issues occur when a system...

Question 7

Identify the business benefits of a relational database.

Accepted Answer

Relational databases offer several business benefits, including:

1. Data Integrity: Relational databases use constraints and rules to ensure that data is accurate and consistent, which helps to maintain data integrity and reliability.

2. Flexibility: Relational databases allow for complex queries and data manipulation, making it easier for businesses to analyze and extract valuable insights from their data.

3. Scalability: Relational databases can easily scale to accommodate growing amounts of data, making them suitable for businesses of all sizes.

4. Security: Relational databases offer robust security features, such as user authentication and access control, to protect sensitive business data from unauthorized access.

5. Integration: Relational databases can easily integrate with other systems and applications, allowing businesses to streamline their operations and improve efficiency.

6. Data Consistency: Relational databases ensure that data is consistent across different tables, which is essential for accurate reporting and decision-making.

Overall, the business benefits of a relational database include improved data integrity, flexibility, scalability, security, integration, and data consistency, all of which contribute to better decision-making and operational efficiency for businesses.

Question 8

Explain the four primary traits that determine the value of information.

Accepted Answer

The answer of Explain the four primary traits that determine...

Question 9

Explain ETL and the role of a data mart in business.

Accepted Answer

The answer of Explain ETL and the role of a...

Question 10

What are rules that enforce basic and fundamental information-based constraints?

Accepted Answer

A)   Information integrity
B)   Integrity constraint
C)   Business-critical integrity constraint
D)   Relational integrity constraintE) None of the above
F) A) and B)

Question 11

Define a data warehouse,and provide a few reasons it can make a manager more effective.

Accepted Answer

Not Answer

Question 12

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?

Accepted Answer

A)   Data-driven website
B)   Interactive website
C)   Database performing website
D)   Data processing websiteE) None of the above
F) A) and B)

Question 13

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Accepted Answer

A)   Transactional information
B)   Analytical information
C)   Timeliness
D)   QualityE) C) and D)
F) A) and D)

Question 14

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

Accepted Answer

A) True 
 B)False

Question 15

Explain the business benefits of a data-driven website.

Accepted Answer

The answer of Explain the business benefits of a data-driven...

Question 16

Which of the below questions can be answered using business intelligence?

Accepted Answer

A)   Where has the business been?
B)   Where is the business now?
C)   Where is the business going?
D)   All the answers are correct.E) A) and B)
F) B) and C)

Question 17

Which of the following fall in the category of external databases in the data warehouse model?

Accepted Answer

A)   Marketing,sales,inventory and billing
B)   Data mart 1,data mart 2 and data mart 3
C)   Competitor and industry information,mailing lists and stock market analysis
D)   Marketing information,sales information and stock market analysisE) B) and D)
F) None of the above

Question 18

A data driven _________ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Accepted Answer

The answer of A data driven _________ is an interactive...

Question 19

Standardising of data elements allows for:

Accepted Answer

A)   Greater accuracy,completeness and consistency
B)   Stabilised pivot tables
C)   Faster processing of clients
D)   Increased security featuresE) B) and D)
F) B) and C)

Question 20

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Accepted Answer

A)   Statistical detection
B)   Cluster analysis
C)   Association detection
D)   None of the answers is correctE) A) and C)
F) A) and B)

Exam 8: Databases-Business Intelligence

A foreign key provides details about data.

Correct Answer
verified

Within the data warehouse model,the external databases are competitor information,industry information,mailing lists and stock market analysis.

Correct Answer
verified

Which of the following asks users to write lines of code to answer questions against a database?

Correct Answer
verified

Relational integrity constraints enforce business rules vital to an organisation's success and often require more insight and knowledge than relational integrity constraints.

Correct Answer
verified

A data mart is the process of analysing data to extract information not offered by the raw data alone.

Correct Answer
verified
False

Data __________ issues occur when a system produces incorrect,inconsistent or duplicate data.

Correct Answer
verified

Identify the business benefits of a relational database.

Explain the four primary traits that determine the value of information.

Correct Answer
verified

Explain ETL and the role of a data mart in business.

Correct Answer
verified

What are rules that enforce basic and fundamental information-based constraints?

Correct Answer
verified

Define a data warehouse,and provide a few reasons it can make a manager more effective.

Correct Answer
verified
Not Answer

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?

Correct Answer
verified

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Correct Answer
verified

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

Correct Answer
verified

Explain the business benefits of a data-driven website.

Correct Answer
verified

Which of the below questions can be answered using business intelligence?

Correct Answer
verified

Which of the following fall in the category of external databases in the data warehouse model?

Correct Answer
verified

A data driven _________ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Correct Answer
verified

Standardising of data elements allows for:

Correct Answer
verified

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Correct Answer
verified

Exam 8: Databases-Business Intelligence

A foreign key provides details about data.

Correct AnswerverifiedShow Answer

Within the data warehouse model,the external databases are competitor information,industry information,mailing lists and stock market analysis.

Correct AnswerverifiedShow Answer

Which of the following asks users to write lines of code to answer questions against a database?

Correct AnswerverifiedShow Answer

Relational integrity constraints enforce business rules vital to an organisation's success and often require more insight and knowledge than relational integrity constraints.

Correct AnswerverifiedShow Answer

A data mart is the process of analysing data to extract information not offered by the raw data alone.

Correct AnswerverifiedFalse

Data __________ issues occur when a system produces incorrect,inconsistent or duplicate data.

Correct AnswerverifiedShow Answer

Identify the business benefits of a relational database.

Explain the four primary traits that determine the value of information.

Correct AnswerverifiedShow Answer

Explain ETL and the role of a data mart in business.

Correct AnswerverifiedShow Answer

What are rules that enforce basic and fundamental information-based constraints?

Correct AnswerverifiedShow Answer

Define a data warehouse,and provide a few reasons it can make a manager more effective.

Correct AnswerverifiedNot Answer

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database?

Correct AnswerverifiedShow Answer

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Correct AnswerverifiedShow Answer

A data warehouse is a logical collection of information,gathered from many different operational databases,that supports business analysis activities and decision-making tasks.

Correct AnswerverifiedShow Answer

Explain the business benefits of a data-driven website.

Correct AnswerverifiedShow Answer

Which of the below questions can be answered using business intelligence?

Correct AnswerverifiedShow Answer

Which of the following fall in the category of external databases in the data warehouse model?

Correct AnswerverifiedShow Answer

A data driven _________ is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Correct AnswerverifiedShow Answer

Standardising of data elements allows for:

Correct AnswerverifiedShow Answer

What is the technique used to divide information sets into mutually exclusive groups such that the members of each group are as close together as possible to one another and the different groups are as far apart as possible?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Not Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified