Filters
Question type

Study Flashcards

The primary purpose of a data ___________ is to combine information (specifically,strategic information) throughout an organisation into a single repository in such a way that the people who need that information can make decisions and undertake business analysis.

Correct Answer

verifed

verified

Enterprise application integration (EAI) connects the plans,methods and tools aimed at integrating separate enterprise systems.Why doesEAI review how legacy systems fit into the new shape of the organisation's business processes?A.To reuse what already exists while adding new systems and data


A) Systemic and analytic integration
B) Enhanced and relational integration
C) Forward and backward integration and central repositoryintegration
D) Independent repository integration and hierarchicalintegration

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

There are two main primary traits that help you determine the value of information including timeliness and quality.

A) True
B) False

Correct Answer

verifed

verified

If employees are using a supply chain management system to make decisions,they may find that their suppliers send information in different ways.One supplier may send detailed information in a spreadsheet,another supplier may send summary information in a word-processed document and still another may send aggregate information from a database.These different ways of sending informationwould be categorised as occurring in different ____________.


A) information levels
B) information formats
C) information ranks
D) information focuses

E) A) and D)
F) A) and C)

Correct Answer

verifed

verified

What are two common methods used for integrating databases?


A) Accounting
B) Manufacturing
C) Engineering
D) Marketing

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

Which of the following would not be considered part of the 'accurate' characteristic of high-quality information?


A) All the values are correct
B) The email address is invalid
C) The dollar amount is recorded properly
D) Aggregate information is in agreement with detailed information

E) None of the above
F) A) and C)

Correct Answer

verifed

verified

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

A) True
B) False

Correct Answer

verifed

verified

Which of the following are examples of transactional information?


A) Airline ticket, sales receipts and packing slips
B) Trends and sales statistics
C) Product sales results, grocery receipts and growth projections
D) Airline tickets and sales growth spreadsheets

E) All of the above
F) A) and D)

Correct Answer

verifed

verified

Gender can be referred to in many ways (male,female,M/F,1/0) in a data warehouse.What is this an example of?


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

E) C) and D)
F) None of the above

Correct Answer

verifed

verified

Relational ____________ constraints are rules that enforce basic and fundamental information-based constraints.

Correct Answer

verifed

verified

Describe a database,a database management system and the relational database model.

Correct Answer

verifed

verified

Broadly defined,a database maintains inf...

View Answer

Which of the following describes ETL?


A) A process that extracts information from internal and external databases
B) A process that transforms information using a common set of enterprise definitions
C) A process that loads information into a data warehouse
D) All the answers are correct

E) B) and D)
F) C) and D)

Correct Answer

verifed

verified

What is a foreign key?


A) A field (or group of fields) that uniquely identifies a given entity in a table
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
C) Characteristics or properties of an entity
D) A field (or group of fields) that uniquely identifies a given attribute in a table

E) B) and D)
F) All of the above

Correct Answer

verifed

verified

In the relational database model,what is a person,place,thing,transaction or event about which information is stored?


A) Entity
B) Relationships
C) Attribute
D) Foreign key

E) A) and B)
F) A) and C)

Correct Answer

verifed

verified

What is data mining?


A) The common term for the representation of multi-dimensional information
B) A particular attribute of information
C) Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behaviour and guide decision making
D) Process of analysing data to extract information not offered by the raw data alone

E) A) and B)
F) None of the above

Correct Answer

verifed

verified

Business intelligence processes data from data warehouses or data marts using computing technologies for the identification,___________ and analysis of business data.

Correct Answer

verifed

verified

What are the primary differences between a data warehouse and a data mart?


A) Data warehouses make quick decisions, data marts make slow decisions
B) Data warehouses tackle ethical issues, data marts tackle hypothetical issues
C) Data warehouses have a more organisation-wide focus, data marts have functional focus
D) Data warehouses have a physical focus, data marts have logical focus

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

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


A) Structured query language
B) Relational query language
C) Structured elements
D) Data mining tools

E) B) and C)
F) All of the above

Correct Answer

verifed

verified

The financial industry uses business intelligence to predict hardware failures.

A) True
B) False

Correct Answer

verifed

verified

Which of the following is not a typical drawback of not integrating databases?


A) Combine strategic information
B) Organise departments
C) Interface between the computer and employees
D) All the answers are correct

E) B) and C)
F) None of the above

Correct Answer

verifed

verified

Showing 61 - 80 of 80

Related Exams

Show Answer