Q&A Hero

Q: ODBC works on the____________ operating system.a. Kronosb. UNIXc. Windowsd. Mac

Q: ___________is a collection of technologies used to access any type of data source and manage the data through a common interface.a. DAOb. UDAc. ODBCd. OLE-DB

Q: The initial costs of using cloud services tend to be significantly higher than building on-premise IT infrastructures.a. Trueb. False

Q: Cloud services allow any organization to quickly and economically add information technology services to its IT portfolio. a. True b. False

Q: A document type definition (DTD) can be referenced by many Extensible Markup Language (XML) documents of the same type. a. True b. False

Q: In a document type definition (DTD) file, a plus (+) symbol beside an element indicates that it is an optional child element within its parent. a. True b. False

Q: The first line of an XML document represents the document declaration, and it is mandatory. a. True b. False

Q: HTML is designed to facilitate the extraction and manipulation of data from structured documents over the Internet. a. True b. False

Q: A plug-in is an external application that is automatically invoked by a web browser when needed.a. Trueb. False

Q: The use of HTML does not equip a web browser with computational abilities beyond formatting output text and accepting form field inputs. a. True b. False

Q: The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client. a. True b. False

Q: The label "stateless system" indicates that, at any given time, there is an open communication line between the server and each client accessing it. a. True b. False

Q: The browser's interpretation and presentation capabilities are sufficient to develop webbased applications. a. True b. False

Q: APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.a. Trueb. False

Q: An application programming interface (API) uses script files that perform specific functions based on the client's parameters that are passed to the web server. a. True b. False

Q: The Common Gateway Interface (CGI) is a newer web server interface standard that is much more efficient and faster than a dynamic link library (DLL). a. True b. False

Q: Extending the web server functionality implies that the web server and the web-to-database middleware will properly communicate with each other. a. True b. False

Q: A client-side extension is a program that interacts directly with the web server to handle specific types of requests. a. True b. False

Q: In the database query scenario, the web server generates the webpage contents before it sends the page to the client web browser. a. True b. False

Q: When an end user uses a web browser to dynamically query a database, the client browser actually requests a web page from the web server. a. True b. False

Q: A web server is the main hub through which all Internet services are accessed.a. Trueb. False

Q: The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface. a. True b. False

Q: The effects of bad database design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred.a. Trueb. False

Q: Whether you purchase online or by standing in line, the system-level transaction details are essentially the same, and they require the same basic database structures and relationships. a. True b. False

Q: Having a web-based database interface eliminates the design and implementation issues of a database system.a. Trueb. False

Q: Among the three levels of compliance of the ODBC API standards, Level-1 provides support for procedural SQL and cursors. a. True b. False

Q: A good API makes it easy to develop a program by providing all of the building blocks. a. True b. False

Q: An API (application programming interface) is defined as a set of routines, protocols, and tools for building software applications. a. True b. False

Q: Database connectivity software is also known as database middleware because it interfaces between the application program and the database. a. True b. False

Q: What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

Q: Describe the use of SQL in relation to ROLAP.

Q: Explain the concept of data analytics. What are the various tools of data analytics?

Q: What is the difference between decision support data and operational data from the point of view of data analyst?

Q: What is data visualization? Name different techniques of data visualization.

Q: _____ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

Q: _____ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Q: OLAP systems are designed to use both operational and data _____ data.

Q: To deliver efficient decision support, OLAP tools must have advanced data_____________ features.

Q: The most distinctive characteristic of modern OLAP tools is their capacity for _____ analysis.

Q: _____ makes a copy of a table and places it in a different location to improve access time.

Q: The____________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.

Q: In multidimensional terms, the ability to focus on slices of the cube to perform a more detailed analysis is known as _____.

Q: _____ are qualifying characteristics that provide additional perspectives to a given fact.

Q: _____ are numeric measurements (values) that represent a specific business aspect or activity.

Q: A data _____ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

Q: A data _____ is a centralized, consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.

Q: _______________is a read-only database optimized for data analysis and query processing.

Q: To support a(n) _____ adequately, the DBMS might be required to support advanced storage technologies, and even more importantly, to support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or a massively parallel processor (MPP).

Q: _____ are quantifiable measurements (numeric or scale based) that assess a company's effectiveness or success in reaching its strategic and operational goals.

Q: Data _____ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

Q: _____ use web-based technologies to present key business performance indicators or information in a single integrated view, generally using graphics in a clear, concise, and easy to understand manner.

Q: ______________is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

Q: _______________functionality ranges from simple data gathering and transformation to very complex data analysis and presentation.

Q: ______________is a term used to describe a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information used to support business decision making.

Q: A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.a. SQL viewb. materialized viewc. star schemad. data cube

Q: An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in____________n-dimensional arrays.a. table-likeb. matrix-likec. network-liked. cube-like

Q: Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a__________ .a. multi-cubeb. database cubec. data cubed. hyper cube

Q: A______ index is based on 0 and 1 bits to represent a given condition.a. logicalb. multidimensionalc. normald. bitmapped

Q: ____________extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.a. ROLAPb. OLAPc. DBMSd. BI

Q: Decision support data tend to be non-normalized,______ , and pre-aggregated.a. uniqueb. duplicatedc. optimizedd. sorted

Q: The reliance on________ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.a. normalizationb. denormalizationc. star schemad. multidimensional schema

Q: _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time. a. Normalization b. Meta modeling c. Replication d. Partitioning

Q: A __________schema is a type of star schema in which dimension tables can have their own dimension tables.a. snowflakeb. starflakec. dimensiond. matrix

Q: In a typical star schema, each dimension record is related to thousands of________ records.a. attributeb. factc. keyd. primary

Q: Fact and dimension tables are related by_______ keys.a. sharedb. primaryc. foreignd. linked

Q: The attribute hierarchy provides a top-down data organization that is used for two main purposes:______ and drill-down/roll-up data analysis.a. decompositionb. de-normalizationc. normalizationd. aggregation

Q: In star schema representation, a fact table is related to each dimension table in a _________relationship.a. many-to-one (M:1)b. many-to-many (M:M)c. one-to many (1:M)d. one-to-one (1:1)

Q: In a star schema, attributes are often used to search, filter, or classify___________ .a. tablesb. salesc. factsd. dimensions

Q: Computed or derived facts, at run time, are sometimes called__________ to differentiate them from stored facts.a. schemasb. attributesc. metricsd. dimensions

Q: The basic star schema has four components: facts,________ , attributes, and attribute hierarchies.a. keysb. relationshipsc. cubesd. dimensions

Q: Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n)_____________ .a. data warehouseb. multidimensional cubec. OLAP toold. star schema

Q: _____________can serve as a test vehicle for companies exploring the potential benefits of data warehouses.a. Data networksb. Data martsc. Data cubesd. OLAPs

Q: Data __________implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.a. visualizationb. analyticsc. miningd. integration

Q: The__________ schema must support complex (non-normalized) data representations.a. snowflakeb. online analytical processingc. decision support databased. multidimensional database

Q: Operational data are commonly stored in many tables, and the stored data represent information about a given________________only.a. transactionb. databasec. tabled. concept

Q: From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and_________ .a. usabilityb. dimensionalityc. transaction processingd. sparsity

Q: Which of the following is a personal analytics vendor for BI applications? a. IBM b. Kognitio c. Netezza d. MicroStrategy

Q: _____________tools focus on the strategic and tactical use of information.a. Businessb. Relational database managementc. Business intelligenced. Networking

Q: In business intelligence framework, data are captured from a production system and placed in___________ on a near real- time basis.a. decision support systemb. portalc. data warehoused. dashboard

Q: _____ provide a unified, single point of entry for information distribution.a. Decision support systemsb. Portalsc. Data warehousesd. Dashboards