Ch14,15,16

Select all statements that correctly describe business intelligence. Business Intelligence is one aspect of data mining. Data mining is a tool used for Business Intelligence. Data mining and business intelligence are synonyms. Business intelligence provides a framework for collecting operational data. Decision support systems can be an aspect of business intelligence.

Data mining is a tool used for Business Intelligence. Correct Business intelligence provides a framework for collecting operational data. Correct Decision support systems can be an aspect of business intelligence.

Select all that are correct about database security. A security policy might define how frequently the data should be audited and the also reference the procedures for auditing. Users writing passwords on Post-It Notes is an example of a security breach. Data integrity involves many aspects, including allowing only certain people to access the data. A user copying data to a flash drive is an example of a security vulnerability. Measures to secure the DBMS might include some network security measures.

A security policy might define how frequently the data should be audited and the also reference the procedures for auditing. A user copying data to a flash drive is an example of a security vulnerability. Correct Measures to secure the DBMS might include some network security measures.

Select all that correctly describe data warehouses. A data warehouse is integrated, meaning it provides a consistent view of an organization's data. Data warehouse designers do not focus on the processes that modify data when they design a data mart or data warehouse. Data warehouse data covers a shorter period of time than an operational database. Data warehouse data is never deleted. Data warehouse data is often organized into functional areas.

Data warehouse data is never deleted. Correct Data warehouse data is often organized into functional areas. Answers: Correct A data warehouse is integrated, meaning it provides a consistent view of an organization's data. Correct Data warehouse designers do not focus on the processes that modify data when they design a data mart or data warehouse.

Select all choices that correctly describe decision support data. Decision support data cover a specific time period. Decision support data can be modeled in fewer tables than can operational data. Decision support data can contain data anomalies. Queries against decision support data are less complex than queries against operational data. Real-time updates are critical to decision-support data.

Decision support data cover a specific time period. Correct Decision support data can be modeled in fewer tables than can operational data. Correct Decision support data can contain data anomalies.

Select all that are correct about sql embedded into procedural or imperative languages (embedded sql). Embedded SQL can be used in stored procedures. Host variables receive data from database queries. Embedded SQL follows a pre-defined standard with many host languages can follow. The execution plan for dynamic embedded sql needs to be re-optimized every time the query is run. Embedded SQL requires the user of cursors if the query returns multiply values.

Host variables receive data from database queries. Correct Embedded SQL follows a pre-defined standard with many host languages can follow. Correct The execution plan for dynamic embedded sql needs to be re-optimized every time the query is run. Correct Embedded SQL requires the user of cursors if the query returns multiply values.

Select all that are correct about data mining. In the data preparation phase of data mining, data is loaded into the data warehouse. Patterns and trends are uncovered in the data mining data analysis phase. Data mining might be used for a model to predict the weather. Data mining might be used to find out how long it takes to ship an order after the warehouse receives more than four inches of snow. Data mining might be used to find out how long it took to ship a package.

In the data preparation phase of data mining, data is loaded into the data warehouse. Correct Patterns and trends are uncovered in the data mining data analysis phase. Correct Data mining might be used for a model to predict the weather. Correct Data mining might be used to find out how long it takes to ship an order after the warehouse receives more than four inches of snow.

Select all that correctly describe fact tables in a dimensional schema. It is possible to define several fact tables for the same schema. The attributes in fact tables are typically made up entirely of numeric values. The primary key in a fact table is a composite of foreign keys to the dimension tables. Like dimension tables, fact tables are always normalized to 3NF to optimize performance. Fact tables are generally not as large as dimension tables, which may contain information such as customer data.

It is possible to define several fact tables for the same schema. Correct The attributes in fact tables are typically made up entirely of numeric values. Correct The primary key in a fact table is a composite of foreign keys to the dimension tables.

Select all that are correct about relational online analytical processing (ROLAP) and multidimensional online analytical processing (MOLAP) systems. A MOLAP system extends relational database technology to data warehouse technology. A ROLAP stores data in cubes for multidimensional data schema support. MOLAP databases tend to be faster for data retrieval especially with large data sets than ROLAP databases. It is more difficult to add a new dimension to a MOLAP database than it is to add a dimension to a ROLAP database. A MOLAP database works better for large data sets.

MOLAP databases tend to be faster for data retrieval especially with large data sets than ROLAP databases. Correct It is more difficult to add a new dimension to a MOLAP database than it is to add a dimension to a ROLAP database. Correct A MOLAP database works better for large data sets.

Select all that correctly describe the MapReduce model. MapReduce separates calculation logic from distributed programming logic. MapReduce is implemented on many frameworks, including Hadoop. MapReduce works with data structured as key/value pairs. The reduce phase of MapReduce compresses the keys to make reads more efficient. MapReduce functions as a transaction-based framework.

MapReduce separates calculation logic from distributed programming logic. Correct MapReduce is implemented on many frameworks, including Hadoop. Correct MapReduce works with data structured as key/value pairs

Select all choices that correctly describe online transaction processing (OLTP) databases. An OLTP database is likely to contain many frequent and complex queries. Most OLTP databases are designed mainly for read-only transactions. The data in an OLTP database is uploaded to the database at periodic intervals. An OLTP table will typically have fewer fields than a decision support system (DSS) table. OLTP data focuses on individual transactions rather than on data summaries.

OLTP data focuses on individual transactions rather than on data summaries. Correct An OLTP database is likely to contain many frequent and complex queries.

Select all that correctly describe Big Data. Big Data systems generally deal only with large amounts of structured data. Databases that manage Big Data can also manage the structure that is part of relational database. If the volume, velocity or veracity of the data exceeds a certain threshold, the data needs a Big Data solution. Velocity in the context of Big Data is determined by the speed it takes to process a query. One aspect of handling Big Data is parallelizing access to a Big Data schema.

One aspect of handling Big Data is parallelizing access to a Big Data schema.

Which of the following is an example of an attribute hierarchy in a dimensional schema? Child-parent-uncle-grandparent Hour-day-month-week-year Paragraph-page-chapter-book Street-town-state-country Car-truck-plane-rocket

Paragraph-page-chapter-book Correct Street-town-state-country

Select all statements that correctly describe star schemas. a. A star schema places events such as sales in fact tables, with dimensions of those facts, such as the date and location, in dimension tables. b. In a star schema the dimensions may contain many attributes that can help identify values of those dimensions useful for queries. For example, a time dimension may include an attribute for the day of the week. c. Attributes in a star schema can be arranged in a hierarchy. For example, the time concept could be broken into day, month, and year attributes. d. A fact table may contain non-dimensional attributes such as the weight sold or the amount of a sale, which can be aggregated.

a. A star schema places events such as sales in fact tables, with dimensions of those facts, such as the date and location, in dimension tables. Correctb. In a star schema the dimensions may contain many attributes that can help identify values of those dimensions useful for queries. For example, a time dimension may include an attribute for the day of the week. Correctc. Attributes in a star schema can be arranged in a hierarchy. For example, the time concept could be broken into day, month, and year attributes. Correctd. A fact table may contain non-dimensional attributes such as the weight sold or the amount of a sale, which can be aggregated.

Select all statements that correctly describe Business Intelligence (BI) architectural components. a. Data extraction, transformation, and loading (ETL) tools collect, filter, integrate, and aggregate operation data to be saved into a data store optimized for decision support. b. The data store is optimized for decision support and is generally implemented as a data warehouse or a data mart. c. The query tool and the presentation tool are the front end to the BI environment. d. The bulk of the extract, transform, and load process is usually performed directly by an HTTP server.

a. Data extraction, transformation, and loading (ETL) tools collect, filter, integrate, and aggregate operation data to be saved into a data store optimized for decision support. Correctb. The data store is optimized for decision support and is generally implemented as a data warehouse or a data mart. Correctc. The query tool and the presentation tool are the front end to the BI environment.

Which of the following are characteristics of data mining as distinct from data analysis? (Check all that are true.) a. Data mining discovers unexpected relationships that may be of value to the enterprise, while traditional data analysis computes predefined values and tests specified hypotheses. b. Data analysis operates on data warehouse and data mart data, but data mining operates on data from the web. c. Data mining automates certain aspects of data analysis. d. Data analysis is an antiquated concept that has been replaced by data mining.

a. Data mining discovers unexpected relationships that may be of value to the enterprise, while traditional data analysis computes predefined values and tests specified hypotheses. Correctc. Data mining automates certain aspects of data analysis.

Select all statements that correctly describe the role of Database Administrator (DBA). a. DBAs oftentimes need to plan and organize both people and data. b. DBAs may need to meet with end-users in order to gather data requirements. c. DBAs must attend to the security of the data in the database. d. DBAs should implement data backup and recovery for data in the database.

a. DBAs oftentimes need to plan and organize both people and data. Correctb. DBAs may need to meet with end-users in order to gather data requirements. Correctc. DBAs must attend to the security of the data in the database. Correctd. DBAs should implement data backup and recovery for data in the database.

Which of the following are valid database connectivity interfaces? (Check all that are true.) a. Open Database Connectivity (ODBC) b. Microsoft Database Connectivity (MDBC) c. Java Database Connectivity (JDBC) d. Object Link and Embedding for Database (OLE-DB)

a. Open Database Connectivity (ODBC) Correctc. Java Database Connectivity (JDBC) Correctd. Object Link and Embedding for Database (OLE-DB)

You have been asked to design a data warehouse for a chain of grocery stores. You have identified the following entity types and their attributes. The columns in the primary key are underlined. These are simplifications. Product(product_code, department, price) Sale(sale_id, date, total_sale_amount) Line_item(sale_id, product_code, quantity, extended_price) Promotion(promotion_id, promotion_type, date) The Sale table represents the information on your grocery store receipt that is not associated with individual things that you purchased, such as the date. The Line_item table represents the information about individual things that you purchased, such as a gallon of milk or two one pound bags of carrots. Select all answers that would be expected to be true of a dimensional data warehouse design for the grocery store business with the entities above. a. We would expect there to be a Product dimension in the design. b. We would not need a time dimension in this design, because the sales are sales, no matter when they occur. c. The design would probably include a fact table representing the atomic sales facts represented in the Line_item table. d. The design would probably contain dimensions, but no fact tables.

a. We would expect there to be a Product dimension in the design. Correctc. The design would probably include a fact table representing the atomic sales facts represented in the Line_item table.

Select all statements that correctly describe database Internet connectivity. a. A web browser is generally integrated directly into the database. b. Server-side extensions on a web server extend the web server by handling specific kinds of requests. c. Client-side extensions add functionality to the database so that the web browser can access that functionality. d. Web-application servers are applications that provide a range of services in addition to the basic web-server functionality.

b. Server-side extensions on a web server extend the web server by handling specific kinds of requests. Correctd. Web-application servers are applications that provide a range of services in addition to the basic web-server functionality.

Select all statements that correctly describe database connectivity mechanisms. a. Native SQL Connectivity provides a standard application programming interface (API) for many different DBMS created by different vendors. b. Applications that access relational databases must use a SQL client application such as Oracle SQL Developer or SQL Server management Studio in order to execute SQL to retrieve and write data. c. Java Database Connectivity (JDBC) is an application programming interface (API) that allows Java programs access many kinds of data sources including relational databases. d. ADO.NET provides data access for applications that use Microsoft's .NET application programming interface (API). e. Open Database Connectivity (ODBC) is a widely supported application programming interface (API) developed by Microsoft that allows applications to access relational data.

c. Java Database Connectivity (JDBC) is an application programming interface (API) that allows Java programs access many kinds of data sources including relational databases. Correctd. ADO.NET provides data access for applications that use Microsoft's .NET application programming interface (API). Correcte. Open Database Connectivity (ODBC) is a widely supported application programming interface (API) developed by Microsoft that allows applications to access relational data.