Which of the following implies that aggregate or summary information is in agreement with detailed information?
answer
Consistency
question
Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.
answer
Change
question
Which of the following represent the four primary traits that help determine the value of information?
answer
information type, information timeliness, information quality, and information governance
question
What are information integrity issues?
answer
occurs when a system produces incorrect, inconsistent, or duplicate data
question
Which of the following would not be considered part of the complete characteristic of high-quality information?
answer
Is each transaction represented only once in the information?
question
Which of the following would not be considered part of the timely characteristic of high-quality information?
answer
Is the zip code missing in the address?
question
Which of the following would not be considered part of the consistent characteristic of high-quality information?
answer
Is the two-digit state code missing in the information?
question
What is data governance?
answer
refers to the overall management of the availability, usability, integrity, and security of company data
question
Which of the following occurs during data cleansing?
answer
All of these are correct.
question
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?
answer
database management system
question
Which of the following is a disadvantage of database-stored information?
answer
increased information redundancy
question
12. Which of the following is a problem associated with dirty data
answer
duplicate data
incorrect data
violates business rules
question
Which of the following is true in regard to the elimination of redundant information?
answer
Improves information quality
question
What compiles all of the metadata about the data elements in the data model?
answer
data dictionary
question
What is a primary key? (Be careful, tricky choices!
answer
Field (or group of fields) that uniquely identifies a given record in a table.
question
What is the primary difference between an entity and an attribute?
answer
An entity is a table that stores information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entity
question
What is the role of a foreign key?
answer
A primary key field from one table that you include as a field in a second table to form a relationship between the two tables.
question
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored?
answer
Entity
question
What are rules that help ensure the quality of information?
answer
integrity constraints
question
The purpose of a data warehouse is to:
answer
to aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities.
question
The visual advantages of dashboards include the ability to click on values and view more detail, otherwise known as:
answer
drill down
question
In terms of big data what is veracity?
answer
Biases, noise, abnormalities.
question
In terms of big data what is variety?
answer
The many sources from which Big Data can be drawn.
question
What is ETL?
answer
Extract, transform, load
Extraction, Information, and Loading
question
What is data mining?
answer
get data, "mine" it to get something new
question
What is structured data?
answer
info with a high degree of organization
question
What is web analytics?
answer
analyzes unstructured data associated with websites to identify consumer behavior and website navigation
question
What is another term for data that is already contained in a database or a spreadsheet?
answer
Structured data
question
What are forecasts?
answer
Prediction
question
Which of the following contains a subset of data warehouse information?
answer
data mart
question
Which of the following is a problem associated with dirty data?
answer
-*duplicate
-misleading data
-incorrect data
-*non-formatted data
-*violates business data rules
-*non-integrated
-inaccurate data
question
Before we begin building a database, we need to have a design and an overall idea of the objects about which we want to collect data; we diagram our entities and designate relationships between them using a/an:
answer
Entity-Relationship Diagram
question
What occurs when two entities can be related to each other in many instances?
answer
Many to Many
question
What occurs between two entities in which an instance of one entity can be related to many instances of a related entity?
answer
One to many
question
What is a characteristic of a table?
answer
columns and rows
question
What is composed of rows and columns that represent an entity?
answer
Table
question
What is a collection of related data elements?
answer
Record
question
What is a statement that defines an aspect of a business?
answer
Business Rule
question
What is a foreign key?
answer
defined in a second table, but it refers to the primary key in the first table.
question
A DBMS controls all access to data in a Database.
answer
FALSE
question
A single instance of an Entity is more like a Field than a Record.
answer
TRUE
question
To start building a Visualization, what is the first thing you do?
answer
Drag Field
question
In Power BI, wWhich feature would you use to remove a piece of unwanted data from fields?
answer
replace
question
In Power BI, the area where you create your visuals is called the _________________
answer
Canvas
question
Which type of Visual was used to create the Chart shown at bottom?
Select the Visual Type from among the 6 options shown in the first row below.
answer
Number 3
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
