A data warehouse database differs from an operational database because ________

C) data warehouse data are often stored in a dimensional database

Business Intelligence (BI) systems do which of the following?

Both Analyze current and past activities and Predict future events

Which of the following is not true of database recovery through reprocessing?

Reprocessing will always return the database to its exact previous state

Computer systems fail for which of the following reasons except?

Databases randomly changed field values

Which of the following is true about a shared lock?

It allows reads to the locked item.

Business Intelligence (BI) reporting systems can do which of the following operations?

Both Filter data and Group data

studbud

Intro to Databases Exam 3

100 termsStudBud Administration3 plays

Imported from external platform

Flashcards100 cardsFPractice quizPHost liveL

Questions 100

Answers

1
Which of the following is a reason that operational data are difficult to read?
Slow performance of the system
Missing values
Dirty data
Non-integrated data
2
A data warehouse database differs from an operational database because ________
A) data warehouse data are not stored in tables
D) Both B and C
C) data warehouse data are often stored in a dimensional database
B) data warehouse databases do not have metadata
3
Transaction which all steps must be completed successfully or none will be completed is called durable transaction
True
False
4
Dimensional databases are used for analytical data processing.
True
False
5
When distributed databases break database into sections and store the sections on different servers, this is known as
distributed two-phase locking
replication
disbursing
partitioning
6
50 records for customers w/ phone numbers that should use current area code 345. 10 still use an older area code of 567
inconsistent data
a "too much data" problem
dirty data
a "wrong format" problem
7
Business Intelligence (BI) systems support operational activities.
False
True
8
Preventing multiple applications from obtaining copies of the same record when record is about to be changed is called
concurrent processing
resource locking
serialized reading
block factoring
9
Business Intelligence (BI) systems obtain data from three possible sources.
False
True
10
Operational databases store historical data.
True
False
11
NoSQL really stands for "Not only SQL."
True
False
12
In the MapReduce process, the first step is the ________ step.
super column
map
reduce
column family
13
Business Intelligence (BI) systems do which of the following?
Predict future events
Both Analyze current and past activities and Predict future events
Record and process transactions
Analyze current and past activities
14
Microsoft Access 2019 databases cannot be secured by password encryption
False
True
15
In the MapReduce process, the Reduce step is followed by the Map step.
True
False
16
One way to prevent concurrent processing problems is to lock data that are retrieved for update
True
False
17
With optimistic locking, locks are first issued, then the transaction is processed, and then the locks are released
False
True
18
Which of the following is not true of database recovery through reprocessing?
Reprocessing takes same amount of time as did processing in the first place
Reprocessing will always return the database to its exact previous state
Processing cannot be resumed at a precise point
Reprocessing makes use of a database save
19
Generally, the more restrictive the transaction isolation level, the less the throughput of database processing
False
True
20
One advantage of optimistic locking is that the lock is obtained only after the transaction is processed
True
False
21
Computer systems fail for which of the following reasons except?
Databases randomly changed field values
Electrical power fails
People make mistakes
Programs have bugs
22
Report delivery is more important for data mining than it is for reporting systems.
False
True
23
Dimensional databases use the star schema.
False
True
24
CAP theorem defines three properties of distributed database systems; consistency, availability, and partition tolerance
False
True
25
When Microsoft Access 2019 creates a signed package with a digital signature, the database file will be a(n) ________.
*.mdb file
*.accdb file
*.mdw file
*.accdc file
26
Microsoft Access 2019 databases can be secured by deploying databases packaged with digital signatures
False
True
27
Data Mining uses statistical and mathematical techniques perform whatif analyses, make predictions, facilitate decisions
True
False
28
In terms of database security, a user can be assigned many roles, and a role can be assigned to many users
True
False
29
Purpose of concurrency control is to ensure that one user's work does not inappropriately influence another user's work
True
False
30
The term drill down refers to the capability of seeing the data in smaller and smaller units.
True
False
31
When Microsoft Access 2019 uses user-level security with an Access 2003 file, the database is stored in a(n) .accdb file
False
True
32
Virtualization is using hardware and software to simulate another software application.
False
True
33
The term DBA refers to the ________.
data business auditor
data business administrator
database auditor
database administrator
34
What problem occurs when transaction rereads data and finds new rows that were inserted by a different transaction?
Serialized reads
Unlocked reads
Dirty reads
Phantom reads
35
dirty read: problem with concurrent processing when transaction rereads data already read, finds modifications/deletions
True
False
36
We have obtained access to company's operational data. One record, we find customer age been recorded as "337." This is
non-integrated data
a "too much data" problem
dirty data
inconsistent data
37
Which is not a typical processing application for a database?
Disk Defragmenter
Web forms
SQL/Persistent Stored Modules
User-defined triggers
38
When Microsoft Access 2019 compiles VBA code in a database, the database file will be a(n) ________
*.mdw file
*.accde file
*.accdc file
*.accdb file
39
Two-phase locking can be used to ensure that transactions are serializable
True
False
40
What is the least restrictive isolation level that will prevent nonrepeatable reads?
Read Uncommitted
Serializable
Repeatable Read
Read Committed
41
Database security is easy to achieve since all security is handled by DBMS, which is single point of entry into database
False
True
42
All actions in an atomic transaction are completed successfully or none of the actions are completed at all
False
True
43
Which of the following is true about a shared lock?
It must use a two-phase locking scheme.
It allows reads to the locked item.
It locks the item from all access.
It allows only two transactions to update a record simultaneously.
44
BI reporting systems are used to filter data, sort data, group data and make simple calculations based on the data
False
True
45
Operational databases contain a fact table.
True
False
46
Microsoft Access 2019 uses a user-level security system
False
True
47
When Microsoft Access 2019 secures a database with just a password, the database file will be a(n) ________
*.accdb file
*.accde file
*.mdb file
*.mdw file
48
Which of the following is not a means of processing databases?
Applications invoking stored procedures
Programs coded in C#
Table Normalization
Internet applications using ASP
49
In a snowflake schema, each dimension table is normalized.
True
False
50
When distributed databases create copies of the database on different servers, this is known as ________
partitioning
replication
distributed two-phase locking
division
51
Business Intelligence (BI) reporting systems can do which of the following operations?
Filter data
Both Filter data and Group data
Group data
Modify data
52
Data warehouses are populated with data prepared by extract, transform, and load (ETL) systems.
True
False
53
Column family databases are indistinguishable from relational database tables.
True
False
54
Transactions should be written to the log before they are applied to the database itself
False
True
55
In comparison to reprocessing, rollforward does not involve the application programs
False
True
56
A Business Intelligence (BI) reporting system that uses extensions to SQL is ________.
OLAP
cluster analysis
RFM analysis
PHP
57
Microsoft Access 2019 databases can be secured using trusted locations for database storage
True
False
58
Big Data is the name given to the enormous datasets generated by Web 2.0 applications.
False
True
59
An ACID transaction is one that is all but ________
atomic
guaranteed
consistent
isolated
60
When creating OLAP report based on Access data, often good idea to create view equivalent query to organize data needed
True
False
61
Problematic data include so-called "dirty data."
False
True
62
Apache Cassandra is an example of a(n) ________ non-relational DBMS.
Key-value
Graph
Column family
Object-Oriented
63
Although Excel create PivotTable report using Access data it does not have formatting tools that can be used with report
True
False
64
technique in which database is returned to known state and all valid transactions are reapplied to database is known as
rollforward
transaction logging
checkpointing
reprocessing
65
Apache Cassandra is an example of a column family database.
True
False
66
Rollback requires the use of logs, but rollforward does not
False
True
67
Whether a lock applies to data at the record level, page level, table level, or database level is referred to as _______
lock phasing
lock sharing
serializable locking
lock granularity
68
Additional DBA responsibilities do not include ________
requests of changes to existing systems
editing E-R diagrams
problem and error reporting
controlling database configuration
69
Which of the following is true about data mining applications?
B. They use sophisticated statistical techniques.
C. Report delivery more difficult than report delivery for reporting system
A. They use sophisticated mathematical techniques.
D. Both A and B
70
The acronym DBA refers to either the office or the manager
False
True
71
A star schema resembles a star, with a dimension table at the center and fact tables radiating out from the center.
True
False
72
To create an OLAP report for an Access 2019 database, use the PivotTable tool in Excel 2019.
True
False
73
A data warehouse is a database system that has data and programs for, as well as personnel specialized in, BI processing
False
True
74
What problem occurs when a transaction reads a changed record that has not been committed to the database?
Unlocked reads
Nonrepeatable reads
Serialized reads
Dirty reads
75
Data warehouses use a(n) ________
dimensional database
structured storage
operational database
either operational database or dimensional database
76
When transaction functions such a way that either all transaction actions are completed or none of them, transaction is
atomic
locked
isolated
consistent
77
Only large database systems have a need for database administration
False
True
78
Excel 2019 allows us to connect directly to an Access 2019 database when building a PivotTable.
False
True
79
Excel 2019 cannot import Access 2019 data directly into PivotTable report, but must first place the data into worksheet
False
True
80
A data mart differs from a data warehouse in these ways except ________
data warehouses receive their data from the data marts
it deals with a particular component or functional area of the business
data marts receive their data from the data warehouse
data mart users dont have data management expertise of warehouse employees
81
A data mart is a collection of data that addresses a particular component or functional area of a business.
False
True
82
The simplest way to lease cloud services is SaaS.
False
True
83
BI systems summarize current status of business activities + compare status w/ past events but not predicted future ones
True
False
84
Lock granularity refers to whether lock is placed by DBMS automatically or placed by command from application program
False
True
85
Statementlevel consistency: statements within transaction access consistent rows across lifetime of entire transaction
False
True
86
When Microsoft Access 2019 uses user-level security with an Access 2003 file, the database is stored in a(n) ________
*.mdw file
*.accdb file
*.mdb file
*.accde file
87
When Microsoft Access 2019 secures database just by storing database in trusted location, database file will be a(n)
*.accdb file
*.mdw file
*.accde file
*.mdb file
88
Business Intelligence (BI) systems fall into which of the following categories?
Processing
Both Processing and Reporting
Reporting
Both Reporting and Data mining
89
OLAP provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.
False
True
90
Concurrent processing of a database only poses problems when two or more processes attempt to use the same data
True
False
91
Hadoop is a(n) ________.
Web server
OODBMS
distributed file system (DFS)
RDMBS
92
Data mining applications are used to accomplish all of the following tasks except ________
make predictions
classify entities
incorporate results into some other report/system
perform what-if analysis
93
Ensuring that each SQL statement independently processes consistent rows is known as ________
transaction-level consistency
statement-level consistency
process-level consistency
serializable consistency
94
The purpose of concurrency control is to ________
ensure that ASPs do not duplicate JSPs
ensure that each form has a corresponding report
ensure that one user's work does not interfere with another's
ensure that triggers do not invoke stored procedures
95
What is the least restrictive isolation level that will prevent dirty reads?
Read Committed
Atomic Read
Read Uncommitted
Serializable
96
What is the least restrictive isolation level that will prevent phantom read problems?
Read Uncommitted
Serializable
Read Committed
Atomic Read
97
Which type of lock assumes that no conflicts will occur?
Optimistic locks
Granular locks
Shared locks
Open locks
98
Non-relational DBMSs associated with the NoSQL movement include all of the following except ________
Graph
Hierarchical
Document
Column family
99
The simplest and most feasible means of recovering a database is through reprocessing
False
True
100
Business Intelligence (BI) systems are information systems that help users analyze and use data.
False
True

Intro to Databases Exam 3 Flashcards | StudBud