Data Methods and Warehousing
What is the full name for the abbreviated term of "SQL"? Question options: 1) Structure Query List 2) Structured Query Language 3) Sample Query Language 4) None of the answers are correct 5) All of the answers are correct
2) Structured Query Language
Which of the following statements is FALSE? 1) The data dictionary contains information about the structure of the database. 2) The internal-level schema provides a high-level view of the database. 3) The DDL is used to build the data dictionary. 4) The conceptual-level schema is the organization-wide view of the entire database.
2) The internal-level schema provides a high-level view of the database.
An example of unstructured data is: Question options: 1) Metadata of image file 2) exported Price Market report from ERPsim system 3) spreadsheet with sales data 4) Blog web posts 5) Business invoice to customer
4) Blog web posts
The main computer systems that collect all of the internal company data are: Question options: 1) Company database 2) Internet website 3) Accounting programs 4) Enterprise Resource Planning (ERP) systems 5) Retail point of sale transaction systems
4) Enterprise Resource Planning (ERP) systems
The data analysis method of sentiment analysis collects unstructured textual user data and provides: Question options: 1) Quantifies the use of words by frequency and complexity 2) Counts number of letters, words and sentences 3) None of the answers are correct 4) Provides positive and negative 'affect' or emotional analysis 5) Provides reports from Enterprise Resource Planning (ERP) systems
4) Provides positive and negative 'affect' or emotional analysis
An SQL _____ statement retrieves data records from a database table according to SQL clauses that specify criteria. Question options: 1) WHERE 2) FROM 3) UPDATE 4) SELECT
4) SELECT
An analytics mindset includes the ability to: Question options: 1) use of statistical analysis tools 2) understanding the business area (domain) 3) produce data visualizations 4) all answers are correct 5) asking the right questions and seeking appropriate data to address them
4) all answers are correct
How is a relational database system different from file-oriented systems? 1) none of the answers are correct 2) provides a well-defined structure to organize data 3) avoids anomalies when updating data or deleting data 4) all of the answers are correct 5) reduces the storage of some erroneous data by enforcing data types and ranges (length of data elements)
4) all of the answers are correct
In an inventory table, the most likely nonkey would be 1) item number 2) color 3) price 4) b and c 5) a and c
4) b and c
Performing Extract, Transform and Load (ETL) process includes ALL of the following skill(s) or application(s) except for: Question options: 1) merging or splitting data files 2) reformatting data which may use data tools such as data edit tools, notepad, Excel, Alteryx, etc. 3) performing database queries and joins 4) building visualizations 5) importing .csv and spreadsheet files
4) building visualizations
Performing Extract, Transform and Load (ETL) process includes the following skill(s) or application(s): Question options: 1) visualization tools such as MS PowerBI or Tableau 2) Python coding 3) all of the answers are correct 4) data cleanup and reformatting 5) building a regression analysis model
4) data cleanup and reformatting
In a database management system (DBMS combining files into larger "pools" of data that many application programs can access is an example of database management goal of ______ which makes it easier for information to be combined in unlimited ways. 1) cross-functional analysis 2) none of the above 3) minimal data redundancy 4) data integration 5) data independence
4) data integration
A set of interrelated files forms a _________ (e.g., a customer sales database may include customer file, inventory file, and sales file). 1) field 2) table 3) file 4) database 5) record
4) database
The characteristic of Big Data Analytics that covers the real time data produces by devices including the Internet of Things, sensors, geographic locations, etc. is: Question options: 1) no answer is correct 2) high volume 3) high veracity 4) high velocity 5) high variety
4) high velocity
Unstructured data is contained in all the following types of files exceptfor: Question options: 1) data with mix of various differing spacing including comma, blank-space, colon and tab separated 2) photo in a .bmp file 3) video in a .mp4 file 4) metadata with labels and standard measures for the file 5) social media text content
4) metadata with labels and standard measures for the file
Data analytics has different categories of data analysis. To provide a view of likely upcoming results based on a trend analysis over time, one would perform: Question options: 1) prescriptive analytics 2) intuitive analytics 3) historic analytics 4) predictive analytics 5) descriptive analytics
4) predictive analytics
Data that is easiest to quickly import into Microsoft PowerBI and visualize is: Question options: 1) a compressed spreadsheet file with multiple worksheets 2) an SQL relational database 3) a website scraped using web-crawler software 4) a flat file of continuous data values (without End of Line or End of File control characters) 5) a single .csv file
5) a single .csv file
The characteristic of Big Data Analytics that covers the wide range of non-numeric and unstructured data is: Question options: 1) high veracity 2) high velocity 3) high volume 4) no answer is correct 5) high variety
5) high variety
The definition of "analytics" includes all below exceptfor: Question options: 1) usage of data and statistical methods 2) create explanatory and predictive models 3) main goal is to drive management decisions and actions 4) extensive use of quantitative analysis 5) main goal is to provide visualizations of company performance
5) main goal is to provide visualizations of company performance
In a database management system (DBMS), any data item is usually stored only in one table location in the database. This supports the database management goal of: 1) data independence 2) none of the above 3) cross-functional analysis 4) data sharing 5) minimal data redundancy
5) minimal data redundancy
A set of interrelated fields forms a _________ (e.g., a customer table has a single row containing the customer's first name, last name, phone number and customer ID). 1) database 2) field 3) file 4) table 5) record
5) record
The 4 general interactions performed to a database table include all except: Question options: 1) Update an existing record 2) Create new record 3) Read a record 4) Delete a record 5) All of these answers are correct
5) All of these answers are correct
Which of the following is not an advantage of database systems? 1) Data privacy 2) Data independence 3) Data sharing 4) Data integration
1) Data privacy
Performing the steps of relational database normalization requires 1) all of the answers are correct 2) identifying a primary key for every table 3) a process of doing steps of 1NF, 2NF and 3NF 4) table design by performing iterative (repeated) steps that must be repeated going back to 1NF rule every time a change is made 5) are general steps because information to be stored in a database varies widely
1) all of the answers are correct
The elements in database hierarchy display a top-down order, from the largest aggregated collection of data, down into smallest individual attribute found in a database management system (DBMS). That order from top (complete collection) to smallest element of a DBMS (from left to right) is: 1) database, file, record, field 2) file, database, field, record 3) database, file, field, record 4) record, field, file, database
1) database, file, record, field
A majority of time in the data analytics process is spend doing: Question options: 1) extract, transform and loading of data (ETL) 2) asking business questions 3) presenting results of data analysis 4) producing descriptive statistics 5) presenting results of data analysis
1) extract, transform and loading of data (ETL)
Data that is structured is defined with the following characteristics exceptfor: Question options: 1) lacking identifiable organization or structure 2) all of the answers apply 3) machine-readable 4) computer can process 5) highly organized, usually in rows and columns
1) lacking identifiable organization or structure
The way data are physically arranged and stored in the computer system is: 1) physical view 2) logical view 3) schema view 4) system view
1) physical view
In a Sales Table, the most likely primary key would be 1) sales invoice number 2) inventory item number 3) customer number 4) customer name
1) sales invoice number
Database anomalies can occur if a database table is not designed properly. An Insert Anomaly occurs when: Question options: 1) there is no record within the table to store data until another event occurs to provide the primary key 2) when the database will not delete a value when issued an SQL remove instruction. 3) the same data is stored in multiple places such that the data value(s) are not all properly changed across database 4) all answers are correct 5) when duplicate data appears in several rows in a table's foreign key field
1) there is no record within the table to store data until another event occurs to provide the primary key
Fields contain one attribute about one entity such as one customer who has fields stored such as the customers address, customer name, and phone number. 1) True 2) False
1) True
If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default Question options: 1) DESC 2) ASC 3) There is no default value 4) Descending
2) ASC
Which type of JOIN is used to returns rows that do not have matching values? Question options: 1) Natural JOIN 2) Outer JOIN 3) EQUI JOIN 4) All of the above
2) Outer JOIN
Data that is structured can be found in file format(s) exceptfor: Question options: 1) normalized relational database 2) compressed file in .zip format with unknown data type(s) 3) multiple worksheets of a spreadsheet file 4) none of the answers ensure the file contains structured data 5) comma separated value file
2) compressed file in .zip format with unknown data type(s)
In a typical business's relational database that handles transaction processing for sales, a customer's phone number would most likely be a: 1) database 2) field 3) file 4) record 5) primary key
2) field
The data view that shows how the user or programmer conceptually organizes and understands the data is the 1) record layout view 2) logical view 3) physical view 4) none of the answers is correct 5) all of the answers is correct
2) logical view
All the fields for one specific customer form a record which can be stored in one row in both the customer table (file) and the sales table (file). 1) True 2) False
2) False
In a typical business's relational database that handles transaction processing for sales, which of the following would be identified as a file? 1) A customer's name 2) Data about one customer 3) All inventory records 4) Data about one inventory item 5) None of the answers is correct
3) All inventory records
On the internet's world wide web (www) the standard method for presenting unstructured data in a visual format is using Question options: 1) XBRL tags to control the arrangement of unstructured content on a computer screen 2) including images and links to other websites 3) HTML tags to control the arrangement of unstructured content on a computer screen 4) table formats with columns and rows 5) all of the answers are correct
3) HTML tags to control the arrangement of unstructured content on a computer screen
Find the city's (cities') name(s) with the condition and temperature from table 'weather' where (condition = sunny or cloudy) but (temperature >= 60). Question options: 1) SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' AND condition = 'sunny' OR temperature >= 60 2) SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' OR condition = 'sunny' OR temperature >= 60 3) SELECT city, temperature, condition FROM weather WHERE (condition = 'sunny' OR condition = 'cloudy' ) AND temperature >= 60 4) SELECT city, temperature, condition FROM weather WHERE (condition = 'sunny' AND condition = 'cloudy' ) AND temperature >= 60 5) None of the answers are correct
3) SELECT city, temperature, condition FROM weather WHERE (condition = 'sunny' OR condition = 'cloudy' ) AND temperature >= 60
The main computer systems that collect external unstructured and user generated data are: Question options: 1) Enterprise Resource Planning (ERP) systems 2) Accounting programs 3) Social media apps and world wide web sites 4) Google search engine website 5) Retail point of sale transaction systems
3) Social media apps and world wide web sites
In the relational database approach to data management, data are input into the database _______, stored in a particular location, and available for use by _______ applications and users. 1) once, only the transaction processing 2) twice, security-oriented 3) once, multiple 4) automatically, ERP
3) once, multiple
Database anomalies can occur if a database table is not designed properly. An Update Anomaly occurs when: Question options: 1) when the same data appears more than once in a table's foreign key field 2) all answers are correct 3) the same data is stored in multiple places such that the data value(s) are not all properly changed across database 4) when the database will not change a value when issued an SQL update instruction. 5) when the primary key is not unique in a table
3) the same data is stored in multiple places such that the data value(s) are not all properly changed across database
Database anomalies can occur if a database table is not designed properly. A Delete Anomaly occurs when: Question options: 1) the primary key in one table matches another table's foreign key field 2) no answers are correct 3) deleting some data results in removal of other useful data, i.e. unintended loss of valuable data in the table 4) when the database will not delete a value when issued an SQL remove instruction. 5) the same data is stored in multiple places such that the data value(s) are not all properly changed across database
3) deleting some data results in removal of other useful data, i.e. unintended loss of valuable data in the table
Which operator is used to select values within a given range? Question options: 1) ANY 2) BETWEEN 3) ALL 4) IN
BETWEEN
True or False: The primary key of a table cannot consist of multiple fields.
False
Which of the following is true about the SQL AS clause? Question options: 1) The AS clause in SQL is used to change the column name in the output or assign a name to a derived column. 2) The SQL AS clause can only be used with the JOIN clause. 3) The AS clause in SQL is used to defines a search condition. 4) None of the mentioned answers are correct 5) All of the mentioned answers are correct
The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.
True or False: Data in the primary key of a table cannot be NULL.
True
______ is an operator that combines two or more results from multiple field selections from two or more tables into a single result set. Question options: 1) INTERSECT 2) UNION 3) SELECT 4) COMBINE 5) none of the answers are correct
UNION
Data that is structured is defined with the following characteristic of: Question options: 1) varying in length of character strings 2) none of the answers apply 3) lacking identifiable patterns 4) can be analyzed using probability statistical analysis 5) interpretable mainly only by humans
can be analyzed using probability statistical analysis
Database anomalies can occur if a database table is not designed properly. A Delete Anomaly occurs when: Question options: 1) the primary key in one table matches another table's foreign key field 2) when the database will not delete a value when issued an SQL remove instruction. 3) the same data is stored in multiple places such that the data value(s) are not all properly changed across database 4) no answers are correct 5) deleting some data results in removal of other useful data, i.e. unintended loss of valuable data in the table
deleting some data results in removal of other useful data, i.e. unintended loss of valuable data in the table
Data that is structured is most often stored and available in the following format: Question options: 1) analog vinyl recording 2) digital solidstate memory 3) none of the answers apply 4) digital audio magnetic tape 5) digital streaming media
none of the answers apply
Unstructured data is contained in all the following types of files except for: Question options: 1) webpages in html files 2) tab separated numeric data in rows 3) pictures in .jpeg files 4) video and audio in .mov files 5) audio in .wav file
tab separated numeric data in rows