1. Business intelligence is a framework that allows a business to transform data into information, information into Remember, and Remember into wisdom.
True
2. Analyzing the company data can provide insightful information about short term tactical evaluations.
True
3. The goal of data visualization is to allow the user to see the data’s small picture quickly and efficiently by identifying trends, patterns, and relationships.
False
4. The idea of the data lake is to store the data in its raw/natural state after it is processed
False
5. Operational data and decision support data serve the same purpose.
False
6. Data lakes make it easy to follow the “right tool for the job” approach.
True, because storage can be decoupled from processing and ingestion.
7. Sasha is a software vendor; the client is asking for an application that analyzes multilevel decisions for a specific group of users. Which application should be demonstrated?
autonomous application
8. Data contained within data warehouses are organized and summarized by table, such as CUSTOMER and ADDRESS.
False
9. The leadership of John’s company is interested in a database that allows them to evaluate if current strategies meet organization goals. What type of database would you recommend?
Operational database
10. At what level of the organization does data analysis happen?
Every level
11. A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search.
False
12. The end-user analytical interface is not one of the most critical OLAP components.
False
13. John’s bosses need him to create a denormalization of a table how would he do this?
Optimizes data performance by clustering data and adding redundant data.
14. Which of the following is a disadvantage of normalization?
Creating a longer task
15. Multidimensional data analysis techniques include advanced computational functions.
True
16. Your boss wants you to explain the features of Advanced OLAP. What are these Features?
more useful when access to them is kept simple.
17. What happens during the Remember acquisition phase?
The data-mining tool selects the appropriate modeling or Remember acquisition algorithms.
18. OLAP stands for
Online analytical processing
19. The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one.
False
20. If you need to be in materialized viewed what is the basic syntax for this?
CREATE MATERIALIZED VIEWS, BUILD, REFRESH ON COMMIT.
21. Your boss is asking for your input on a way that would optimize decision support and is generally represented by a data warehouse or a data mart. What would you use?
data store
22. Organizations are turning to what, as a new source for information to gain competitive advantages?
Social Media
23. If you were to use a portal what type of vendor would you use?
SAP
24. When using an intelligence framework, with data being captured from a production system, this data is placed in what?
data warehouse
25. If Postcard company needs a framework that is more comprehensive and integrated decision support what would their company choose?
Business Intelligence
26. If a decision needs to be made using a BI system, what type of reporting style would you use to define metrics and other key performance indicators to evaluate different aspects of an organization?
Monitoring and Alerting
27. ___ allows companies to support tasks that require more than one person to work on the task.
A Communication-driven DSS
28. When using Operational data, they are commonly stored in many tables, and the stored data represents information about what?
a given transaction only
29. When working with Schema, and your post asks what supports complex (non-normalized) data representations, what type of schema, would you tell your boss to use?
decision support database
30. Data _____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
integration
31. What can be used as a test vehicle for companies exploring the potential benefits of data warehouses?
Data marts
32. Identify among the following, which system of data warehousing is mostly used.
reporting and data analysis
33. The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.
dimensions
34. Computed or derived facts, at run time, are sometimes called _____ to differentiate them from stored facts.
metrics
35. At work you are asked to use a star schema that will help with searching a certain product for your boss. What attribute are using?
facts
36. What is known as a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows?
Materialized View
37. When looking at a star schema representation the fact table would be related to the dimension table in what type of relationship?
many-to-one (M:1)
38. The proliferation of _______ tools has fostered the development of SQL extensions to support multidimensional data analysis.
OLAP
39. You need a clause that can help you dictate when to update the materialized view. What clause can you use to do this?
REFRESH
40. You needs to indicate that the updates to the materialized view will take place as part of the commute process. When doing this, what Clause would you need to use to make sure this is done?
ON COMMIT
41. Your boss needs to use a specific SQL statement that will help collect extra information from the database. What SQL statement do they need to use?
SELECT
42. The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
normalization
43. Decision support data tends to be non-normalized, _____, and pre-aggregated.
duplicated
44. If you were using SQL and need to differentiate between access requirements for data warehouse data and operational date, what would you use to do this?
ROLAP
45. A _____ index is based on 0 and 1 bits to represent a given condition.
bitmapped
46. While using a MDBMS, how would you store the end user visualization?
data cube
47. What phases of data mining are data sets, to be used by the data-mining operation, identified and cleansed of any data impurities.
Data preparation
48. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
materialized view
49. Which SQL statement is used to insert new data in a database?
INSERT INTO
50. With SQL, how do you select all the columns from a table named “College”?
SELECT * FROM College
51. With SQL, how can you return all the records from a table named “College” sorted descending by “CollegeName”?
SELECT * FROM Colleges ORDER BY CollegeName DESC
52. How can you change “Smith” into “Jones” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Jones’ WHERE LastName=’Smith’
53. With SQL, how can you return the number of records in the “College” table?
SELECT COUNT(*) FROM College
54. Which SQL statement is used to create a database table called ‘Students’?
CREATE TABLE Students
55. Your boss wants to be able to have a flexible universal storage component and a way to organize and navigate its information. What type of storage should they use?
data lake
56. What is the full meaning of OLAP?
Online analytical processing
57. A more comprehensive and integrated decision support framework within organizations has become known as __.
Business intelligence
58. What type of database is read only and used to optimize data analysis and query processing?
data warehouse
59. If we wanted to use a data warehouse subject that helps provide decision support to a small group, what would we use?
data marts
60. As a database developer, what collection option below would you use to optimize data warehouse data to provide answers to questions from diverse functional areas within a company?
Subject-oriented
61. As a database developer, you could confirm that the only difference between a data mart and a data warehouse is the size and __ of the problem being solved.
Scope
62. As a Database developer, how many main architectural components would you utilize in an OLAP system?
Three
63. You are a database developer; you should use a relational online analytical processing (ROLAP) to provide OLAP functionality by using ____ and familiar relational query tools to store and analyze multidimensional data.
Relational databases
64. The most distinctive characteristic of modern OLAP tools is their capacity for _____ analysis.
Multidimensional
65. To deliver efficient decision support, OLAP tools must have advanced data _____ features.
Access
66. You are a database analyst, you should use the ___ with the GROUP BY clause to generate aggregates by the listed columns, including the last one.
Cube extension
67. In general, there are two types of data that can be presented in quantitative and __ data.
Qualitative
68. The term __ can be used to describe numeric facts or measures of data. This type of data can be counted, ordered, and aggregated.
Quantitative
69. What type of science does data visualization have its roots in?
cognitive
70. A __ is a mega data repository that stores all company data (structured, semi-structured, and unstructured) in its raw/natural format.
data lake
Other Links:
See other websites for quiz:
Check on QUIZLET