Quiz
FINAL IT 2
This quiz has question types that open in the usual player.
Questions in this quiz (42)
1To format an Excel 2016 PivotTable report, we use the [blank_start]design[blank_end] command tab.
- Adesign
2Excel 2016 allows us to [blank_start]connect directly[blank_end] to an Access 2016 database when building a PivotTable.
- Aconnect directly
3To create an OLAP report for an Access 2016 database, use the [blank_start]PivotTable[blank_end] tool in Excel 2016.
- APivotTable
4The term [blank_start]drill down[blank_end] refers to the capability of seeing the data in smaller and smaller units.
- Adrill down
5To arrange the PivotTable columns and rows in Excel 2013, we use the:
- APivotTable Control
- BPivotTable dialog box.
- CPivotTable Field List.
- DPivotTable Wizard.
- EPivotTable command tab.
6To use the Access 2013 database in an Excel 2013 PivotTable, it is generally useful to:
- Acreate a view-equivalent query in Access to organize the data.
- Bstore the needed data in an Excel worksheet.
- Cstore the needed data in a Word document.
- Dstore the needed data in a PowerPoint slide show.
- Estore the needed data in a Visio diagram.
7The term drill down means the user wants to:
- Asummarize data
- Bget older data
- Csort data
- Dget more details
- Eaggregate data
8Excel 2016 cannot import Access 2016 data directly into a PivotTable report, but must first place the data into a worksheet.
- ATrue
- BFalse
9When creating an OLAP report based on Access 2016 data, it is often a good idea to create a view equivalent query to organize the data needed for the OLAP report
- ATrue
- BFalse
10To create an OLAP report for an Access 2016 database, use the PivotTable tool in Access 2016
- ATrue
- BFalse
11The term drill down refers to the capability of seeing the data in smaller and smaller units.
- ATrue
- BFalse
12To deal with historical data values, dimensional databases use a(n) [blank_start]time dimension[blank_end].
- Atime dimension
13In the snowflake schema, the [blank_start]dimension[blank_end] tables are normalized.
- Adimension
14A dimensional database uses a(n) [blank_start]star schema[blank_end].
- Astar schema
15Data warehouse data is often stored in a(n) [blank_start]dimensional database[blank_end].
- Adimensional database
16Snowflake schemas have normalized:
- Afact tables
- Bdimension tables
- Cmap tables
- Dreduce tables
- Enone of the above
17Dimensional databases are used to track historical data and therefore must have a:
- Atime dimension
- Bcustomer dimension
- Csales dimension
- DEither A (time) or B (customer)
- EBoth A (time) and B (customer)
18Data warehouses use a(n):
- Aoperational database
- Bdimensional database
- Cstructured storage
- DEither A (operational) or B (dimensional)
- EAll of the above
19In a snowflake schema, each dimension table is normalized.
- ATrue
- BFalse
20Operational databases contain a fact table.
- ATrue
- BFalse
21Dimensional databases are used for analytical data processing
- ATrue
- BFalse
22A data warehouse database differs from an operational database because:
- Adata warehouse data are not stored in tables.
- Bdata warehouse databases do not have metadata.
- Cdata warehouse data are often stored in a dimensional database.
- DBoth B and C
- EAll of the above
23We have obtained access to the company's operational data. In one record, we find that a customer's age has been recorded as "337." This is an example of:
- Adirty data
- Binconsistent data
- Cnon-integrated data
- Da "wrong format" problem
- Ea "too much data" problem
24Which of the following is a reason that operational data are difficult to read?
- Adirty data
- Bmissing values
- Cnon-integrated data
- DBoth A and B
- EAll of the above
25A data mart is a collection of data that addresses a particular component or functional area of a business.
- ATrue
- BFalse
26A data warehouse is a database system that has data and programs for, as well as personnel specialized in, BI processing.
- ATrue
- BFalse
27Report delivery is more important for data mining than it is for reporting systems.
- ATrue
- BFalse
28Big Data is the name given to the enormous datasets generated by Web 2.0 applications.
- ATrue
- BFalse
29When distributed databases create copies of the database on different servers, this is known as:
- Areplication
- Bpartitioning
- Cdisbursing
- Ddistributed two-phase locking
- Enone of the above
30Business Intelligence (BI) [blank_start]data mining[blank_end] uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.
- Adata mining
31Business Intelligence (BI) systems obtain data in [blank_start]three[blank_end] different ways.
- Athree
32A(n) [blank_start]business intelligence system[blank_end] is an information system that helps users analyze and use data.
- Abusiness intelligence system
33Which of the following is true about data mining applications?
- AA) They use sophisticated mathematical techniques.
- BB) They use sophisticated statistical techniques.
- CC) Their report delivery is more difficult than report delivery for reporting systems.
- DD) Both A (math) and B (stats)
- Eall of the above
34A Business Intelligence (BI) reporting system that uses extensions to SQL is:
- Acluster analysis
- BOLAP
- Cregression analysis
- DRFM analysis
- Eall of the above
35Business Intelligence (BI) systems fall into which of the following categories?
- AProcessing
- BReporting
- CData mining
- DBoth A (processing) and B (reporting)
- EBoth B (reporting) and C (data mining)
36BI reporting systems summarize the current status of business activities and compare that status with past events but not with predicted future activities.
- ATrue
- BFalse
37Business Intelligence (BI) reporting systems can analyze data using standard SQL.
- ATrue
- BFalse
38Business Intelligence (BI) reporting systems are used to filter data, sort data, group data and make simple calculations based on the data.
- ATrue
- BFalse
39Business Intelligence (BI) systems support operational activities.
- ATrue
- BFalse
40Apache Cassandra is an example of a(n) ________ non-relational DBMS.
- AKey-Value
- BDocument
- CColumn Family
- DGraph
- EObject-Oriented
41In the MapReduce process, the Reduce step is followed by the Map step.
- ATrue
- BFalse
42Apache Cassandra is an example of a column family database.
- ATrue
- BFalse
Information
- Description
- Quiz on FINAL IT 2, created by E I on 11/03/2021.
- Author
- E I
- Language
- English
- Views
- 0
- History
- Created on 11 Mar 2021 · updated on 11 Mar 2021
- Rating
- No ratings yet Rate this quiz