Question 1

Uploading data is putting:

Accepted Answer

A)  Scrubbed files into the operational database.
B)  Files from each HIP system into the operational database.
C)  Standardized files onto local desktop systems for access.
D)  Files from each HIP system into the data warehouse.E) B) and D)
F) B) and C)

Question 2

Select the false statement from those provided.

Accepted Answer

A)  Batch processing attains a greater efficiency than real-time processing for large amounts of data items.
B)  Batch processing has a faster response time than real-time processing due to the grouping of like data items.
C)  Batch processing should be utilized for payroll type processes as it groups these similar data items.
D)  Real-time data processing has more complex audit trails for data items than batch processing.E) A) and D)
F) All of the above

Question 3

High-impact processes (HIPs) :

Accepted Answer

A)  Determine the structure of the data in the data warehouse.
B)  Address the short-term goals of the organization.
C)  Must compromise user requirements for organizational needs.
D)  Determine the structure of the data in the operational database.E) A) and B)
F) None of the above

Question 4

The advantages of cloud-based computing includes all of the following, EXCEPT:

Accepted Answer

A)  Scalability - as the company grows, it can easily purchase additional capacity.
B)  Expanded access - once the data are store in the cloud, it can be accessed by multiple devices form different locations.
C)  Increased infrastructure - the company has more need for servers and data storage.
D)  Cost savings - because of the advantages related to cloud-based computing, there are usually significant cost savings recognized.E) C) and D)
F) None of the above

Question 5

The various types of online analytical processing (OLAP)  does NOT include:

Accepted Answer

A)  MOLAP - Multidimensional online analytical processing.
B)  NOLAP - Notational online analytical processing.
C)  ROLAP - Relational online analytical processing.
D)  All of the above, A, B, and C are types of OLAP systems.E) A) and B)
F) None of the above

Question 6

Flat file records are:

Accepted Answer

A)  Kept in random order.
B)  Kept is sequential order.
C)  Linked to other records by a common attribute.
D)  Interactive and real-time processed.E) None of the above
F) A) and B)

Question 7

Which of the following is NOT one of the three rules of data normalization?

Accepted Answer

A)  Eliminate repeating groups
B)  Eliminate redundant data
C)  Eliminate blank fields
D)  Eliminate columns not dependent on the primary keysE) B) and D)
F) All of the above

Question 8

Data normalization:

Accepted Answer

A)  Requires repeated groups to be deleted from the same row.
B)  Requires repeated groups to be deleted from the same column.
C)  Allows repeated groups if contained within the column.
D)  Allows repeated rows of information within two or more tables.E) B) and D)
F) A) and C)

Question 9

The prevention of industrial espionage is aided by all EXCEPT:

Accepted Answer

A)  Password protection
B)  Smart cards.
C)  Federal and state laws.
D)  Encryption of data.E) A) and B)
F) A) and C)

Question 10

A record is:

Accepted Answer

A)  An entire set of fields for a specific entity.
B)  A series of characters.
C)  A collection of files.
D)  Another name for a database.E) A) and C)
F) B) and C)

Question 11

Cleansed or scrubbed data:

Accepted Answer

A)  Has had all viruses removed.
B)  Has had all fields standardized.
C)  Has had errors and problems fixed.
D)  Is data that has been stored in the data warehouse.E) A) and B)
F) A) and C)

Question 12

Each table in a database must meet all of the following conditions EXCEPT:

Accepted Answer

A)  Each row must be uniquely named
B)  Items in a column must all be of the same type of data
C)  Each cell at the intersection of a row and column must contain only one data item
D)  Each row must be unique in at least one attributeE) All of the above
F) C) and D)

Question 13

Which of the following terms is most closely related to data redundancy?

Accepted Answer

A)  Relational database
B)  Concurrency
C)  Batch processing
D)  One-to-many relationshipsE) All of the above
F) B) and C)

Question 14

Describe a data warehouse and the purpose.

Accepted Answer

Management often needs data from several...

Question 15

A record pointer is a:

Accepted Answer

A)  Column value that relates to all other values in the row.
B)  Column value that points to the next address with the linked attribute.
C)  Row value that points to the next address with the linked attribute.
D)  Link that is only required in one-to-many relationships.E) B) and D)
F) None of the above

Question 16

Select the false statement from those provided.

Accepted Answer

A)  Real-time processing is more complex because of the interactive nature of data processing.
B)  Real-time processing must use sequential storage concepts.
C)  The audit trail is as complex within both real-time and batch processing systems.
D)  Control totals are difficult within real-time processing due to the lack of data item groupings.E) All of the above
F) C) and D)

Question 17

Data is becoming more varied and now includes each of the following EXCEPT:

Accepted Answer

A)  Text messages.
B)  Photos and videos.
C)  Meetings.
D)  Tweets.E) A) and D)
F) A) and C)

Question 18

Which of the following statements is not true with regard to a relational database?

Accepted Answer

A)  It is flexible and useful for unplanned, ad hoc queries.
B)  It stores data in tables.
C)  It stores data in a tree formation.
D)  It is maintained on direct access devices.E) All of the above
F) A) and B)

Question 19

Ethical responsibilities are shared by:

Accepted Answer

A)  Company employees only.
B)  Company employees and management only.
C)  Company employees, IT, and management only.
D)  All concerned including employees, customers, and management.E) A) and D)
F) A) and C)

Question 20

Select the false statement from the following.

Accepted Answer

A)  A character is a single letter, number, or symbol.
B)  A field is a set of characters.
C)  A field can be thought of as a column of data.
D)  A file is the entire set of fieldsE) C) and D)
F) A) and D)

Exam 13: Data and Databases

A record is:

Correct AnswerverifiedShow Answer

Cleansed or scrubbed data:

Correct AnswerverifiedShow Answer

A record pointer is a:

Correct AnswerverifiedShow Answer

The advantages of cloud-based computing includes all of the following, EXCEPT:

Correct AnswerverifiedShow Answer

High-impact processes (HIPs) :

Correct AnswerverifiedShow Answer

Which of the following statements is not true with regard to a relational database?

Correct AnswerverifiedShow Answer

Ethical responsibilities are shared by:

Correct AnswerverifiedShow Answer

Select the false statement from those provided.

Correct AnswerverifiedShow Answer

Select the false statement from those provided.

Correct AnswerverifiedShow Answer

Data is becoming more varied and now includes each of the following EXCEPT:

Correct AnswerverifiedShow Answer

Uploading data is putting:

Correct AnswerverifiedShow Answer

Flat file records are:

Correct AnswerverifiedShow Answer

Which of the following is NOT one of the three rules of data normalization?

Correct AnswerverifiedShow Answer

Data normalization:

Correct AnswerverifiedShow Answer

Describe a data warehouse and the purpose.

Correct AnswerverifiedManagement often needs data from several...View AnswerShow Answer

Each table in a database must meet all of the following conditions EXCEPT:

Correct AnswerverifiedShow Answer

Which of the following terms is most closely related to data redundancy?

Correct AnswerverifiedShow Answer

Select the false statement from the following.

Correct AnswerverifiedShow Answer

The various types of online analytical processing (OLAP) does NOT include:

Correct AnswerverifiedShow Answer

The prevention of industrial espionage is aided by all EXCEPT:

Correct AnswerverifiedShow 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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Management often needs data from several...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified