Quiz
FINAL IT 2
Este quiz tem tipos de pergunta que abrem no player de sempre.
Perguntas do 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.
- AVerdadeiro
- BFalso
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
- AVerdadeiro
- BFalso
10To create an OLAP report for an Access 2016 database, use the PivotTable tool in Access 2016
- AVerdadeiro
- BFalso
11The term drill down refers to the capability of seeing the data in smaller and smaller units.
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
20Operational databases contain a fact table.
- AVerdadeiro
- BFalso
21Dimensional databases are used for analytical data processing
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
26A data warehouse is a database system that has data and programs for, as well as personnel specialized in, BI processing.
- AVerdadeiro
- BFalso
27Report delivery is more important for data mining than it is for reporting systems.
- AVerdadeiro
- BFalso
28Big Data is the name given to the enormous datasets generated by Web 2.0 applications.
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
37Business Intelligence (BI) reporting systems can analyze data using standard SQL.
- AVerdadeiro
- BFalso
38Business Intelligence (BI) reporting systems are used to filter data, sort data, group data and make simple calculations based on the data.
- AVerdadeiro
- BFalso
39Business Intelligence (BI) systems support operational activities.
- AVerdadeiro
- BFalso
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.
- AVerdadeiro
- BFalso
42Apache Cassandra is an example of a column family database.
- AVerdadeiro
- BFalso
Informações
- Descrição
- Quiz sobre FINAL IT 2, criado por E I em 11-03-2021.
- Autor
- E I
- Idioma
- English
- Visualizações
- 0
- Histórico
- Criado em 11 mar 2021 · atualizado em 11 mar 2021
- Avaliação
- Ainda sem avaliações Avalie este quiz