stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
ICS212 Final Exam Review - Fall, 2024 Flashcards | StudBud
Explore
/
ICS212 Final Exam Review - Fall, 2024
ICS212 Final Exam Review - Fall, 2024
62 terms
·
StudBud Administration
·
373 plays
Imported from external platform
Flashcards
62 cards
F
Practice quiz
P
Host live
L
Questions
62
Answers
1
An example of a degenerate dimension in a retail datamart would be
Dimensional tables using surrogate keys
The quantity sold
The amount of a sale
A transaction number
2
Which is not an installation option of Oracle's?
Shared Server
Dedicated Server
Optimized Server
RAC
3
If your mongo queries are executing in 60ms in your development environment
You should consider adding an SSD and more memory to your server
That's too slow and the query needs to be optimized
That's excellent performance and nothing more needs to be done
You should consider adding another server to your mongo cluster
4
Of these, which is not a feature of MongoDB
Compound Indexes
Execution plans
Primary Keys
Sequences
5
ETL stands for
Extract, Transform, Load
Extend, Transform, Load
Extract, Transfer, Load
Extend, Transfer, Load
6
Conformed dimensions
Are used across datamarts
Are computed
grow quickly
Are unique to each datamart
7
Oracle, SQL Server and MongoDB are all examples of
Database Management Systems
Open Source Databases
NoSQL Databases
Relational Databases
8
If my app's raw data is 1GB, how much disk space should I plan for my database?
3GB
1GB
4GB
2GB
9
A datamart is
A subset of a data warehouse
A collection of data warehouses
A collection of OLTPs
A subset of an OLTP
10
The data warehouse process that is concerned with determining what has changed since the last time data was imported is
Load
Staging
Transform
Extract
11
Within certain limits, it's usually possible to scale up?
False
True
12
It's a best practice to have a separate schema for each new application
False
True
13
The Oracle Redo Log...
Enables increased performance
Enables usage reporting
Enables enhanced auditing
Enables point-in-time recovery
14
Which can be found in Oracle's System Global Area
Table Space
Listener Process
Disk Block Cache
Log Writer
15
Well designed data warehouses are highly normalized
True
False
16
The Oracle security model consists of
Roles
Schemas
Users
Privileges
17
A stored procedure is an example of an Oracle schema object
False
True
18
In general, you can always scale out (horizontally)
True
False
19
Oracle keeps track of its schema objects in
the registry
its data dictionary
in an RMAN backup
its control files
20
Datamart data always comes from an organization's existing operational (OLTP) systems
True
False
21
A tool to use when importing a CSV file into Oracle is
SQL*Plus
IMPDP
IMP
SQL*Loader
22
The granularity of a datamart tracking monthly bus pass usage would probably be
The number of trips a bus makes on a particular route on a given day
A passenger scanning their pass as they get on the bus
The purchase of the bus pass from a convenience store
The number of riders using a bus pass ar least once every month
23
Surrogate keys are unique keys that occur naturally within source data - for example: a British Columbia Health Number
False
True
24
The primary purpose of a data warehouse is to
Support strategic decision making throughout an organization
Lower the cost of technology in a business
Ensure business processes are completed accurately
Service the analysis needs of a department within a business
25
MongoDB sort operations are aided by
Compound Indexes
Bitmap Indexes
Unique Indexes
More CPU cores
26
If a business changes, it could be reflected in a data warehouse by
Creating a new surrogate key
Creating a new data mart
Adding facts , dimensions and dimensional attributes
Changing the grain of a fact table
27
The granularity of a datamart is
How many dimensions there are
What a row in a fact table represents
What a dimensional record represents
How many facts there are
28
To load a CSV file into MongoDB collection, you would use
sqlLoader
mongoimport
mongoload
mongosh
29
Documents in MongoDB are stored in
Buckets
Rows
Collections
Tables
30
To backup a mongoDB database you would use...
mcopydb
rman
mongocopy
mongodump
31
A star schema
Is a 4-step data warehouse design process
Is an efficient way to organize facts and dimensions in a data mart
Is an oracle construct where users, tables, and indexes are stored
Is the collection of data marts within a data warehouse
32
Data warehouse projects are hard because.. (multiselect)
Technological challanges
Compliance issues
Politics get in the way
Data sources aren't standardized
33
Reasons to use a computed fact in a fact table would be
Accuracy
Memory Efficiency
Storage Efficiency
Performance Efficiency
34
The way to represent a hierarchy in a dimension is
By relating a dimensional table to another dimension table
By adding attributes to the dimensional table
Using a dotted numbering scheme
Within the fact table
35
If I wanted to add 5 to a field in a MongoDB document atomically (in one step) , I could use
$set
$inc
$dec
$push
36
Which is not a feature of a relational database?
Flexible table structure
ACID transations
Security
SQL Language
37
In general, Mongo indexes help regular expressions execute with fewer comparisons
True
False
38
When investigating a problem, you should consult
windows event viewer
alert log
collegues
users
39
In Oracle, a role is
A group of users
A background process in the Oracle architecture
A type of schema object
A named set of privileges
40
A data warehouse is essentially a very large datamart
True
False
41
When restoring from an inconsistent backup created using RMAN, you would
Perform an RMAN recover, followed by an RMAN restore
Perform an RMAN restore, followed by an RMAN recover
Perform an RMAN restore
Perform an RMAN recover
42
to see how a MongoDB query executes a query you would use
db.find(...).perf('executionStats')
db.find(...).explain('executionStats')
db.find(...).show('executionStats')
db.find(...).profile('executionStats')
43
In a retail sale datamart, unit price and number sold are best kept in a(n)
transactional fact table
factless fact table
numeric fact table
periodic fact table
44
Freshly acquired data is cleaned in
a data source
A database
On the file system
a staging area
45
A NoSQL database is essentially a simpler version of a Relational Database
False
True
46
Which index type would you use to make a search for 2 or more fields faster?
Binary
Unique
Compound
Functional
47
If your app requires results from your MongoDB data layer to be returned in sorted order you would best
Sort your results in the client app
Create a compound index
Ensure your server has a lot of memory
Use Mongo's sort API
48
To change the port number that mongo uses you would
rerun mongo's installation program
Modify your firewall rules
Edit the mongod.conf file
Restart the mongod service
49
Which is not part of the Mongo data model
Databases
Collections
Documents
Tables
50
PL/SQL
Is executed on the client
Is standardized by ANSI
Is executed on the server
Is proprietary to Oracle
51
Which properties can you set in an Oracle user profile
Password complexity
Default table space
Lockout Period
Default role
52
The two files you commonly need to modify to change Oracle's network settings are
oracle.ora
listener.ora
dbhome.cfg
tnsnames.ora
53
Which security methods are supported by MongoDB Community Edition?
OAuth
SCRAM
X.509 Certificate Authentication
LDAP
54
In a trigger,
:old
refers to a row before it is added to a table
True
False
55
The two types of Oracle privileges are
Object
User
Schema
System
56
You can (and should) build everything in MongoDB that you do in Oracle
False
True
57
Which are foreground processes in the Oracle Architecture
Checkpoint process
Process Monitor
Dedicated or Shared Server Process
Log Writer
58
Data in dimensional tables
Is highly denormalized
Is highly normalized
Is always taken from a single data source
Is generally additive
59
Numeric keys that data warehouses use to relate facts to dimensions are called
Unique keys
Foreign keys
Primary keys
Surrogate keys
60
The Enterprise Data Warehouse Bus Architecture Matrix
Describes the physical layout of tables within a data warehouse
Is created collaboratively by a cross-funtional group of stakeholders
Is part of a 4-step design process
Will improve the performance of a database cluster hosting a Data Warehouse
61
In Oracle, indefinite blocking can be caused by
Long running queries
Uncomitted transactions
Syntax errors in SQL Statements
RMAN
62
Attempts to normalize dimensional tables is called
Factoring
Dimensional Modelling
Entity Modelling
Snow Flaking
