Business Intelligence mcq with answer

Q1. —- can handle large amounts of data to help identify and evolve new opportunities for the business.
Answer: Business Intelligence

Q2. BI (Business Intelligence) refers to set of techniques which assist in —-, digging out and —- best data from the large amount of data to improve conclusion making.
Answer: Spotting, investigating

Q3. An —- was required for data exchange, collection, and analysis that could supply a unified view of an enterprise’s data.
Answer: Infrastructure

Q4. —- utilities for the moving of data from the diverse data sources to the common data warehouse.
Answer: Extract, Transform, and Load (ETL)

Q5. The first data warehouses were fed by —- prepared by the various systems inside the association.
Answer: Magnetic tapes

Q6. The data fed to the data warehouse from the —- was converted to a format significant to the data warehouse.
Answer: Enterprise systems

Q7. The job of —- is to request a series of rules to extracted data so that it is properly formatted for loading into the data warehouse.
Answer: Transform function

Q8. The —- function permits the consolidation of multiple data sources into a well-structured database for use in complex analysis.
Answer: ETL

Q9. In compare to offline ETL, —- supplies present but varying answers to successive queries.
Answer: Online ETL

Q10. —- represents a pattern that connects information and usually presents a high grade of predictability as to what is recounted or what will happen next.
Answer: Knowledge

Q11. A —- is a special type of a data warehouse focused on a single subject (or functional area), such as Sales, Finance, or Marketing.
Answer: Data mart

Q12. The primary use for a data mart is —- applications.
Answer: Business Intelligence (BI)

Q13. The first task BI has to do is to gather the necessary data about the business.
(a) True
(b) False
Answer: (a) True

Q14. Business intelligence system do not supports the latest information technologies.
(a) True
(b) False
Answer: (b) False

Q15. The value of the DB2 OLAP server lies in its ability to generate and manage relational tables that contain multidimensional data.
(a) True
(b) False
Answer: (a) True

Q1. —- is an Informational analysis on data which takes into account numerous distinct connections, each of which comprises a dimension.
Answer: Multi-Dimensional analysis

Q2. Information about each dimension is stored in one or more —- .
Answer: Dimension tables

Q3. The key attribute represents the —- in the dimension table.
Answer: Primary key column or columns

Q4. An —- can also be bound to one or more additional columns for a specific task.
Answer: Attribute

Q5. A hierarchy is a set of parent-child relationships between attributes within a dimension.
(a) True
(b) False
Answer: (a) True

Q6. Level-based hierarchies can also contain parent-child relationships.
(a) True
(b) False
Answer: (a) True

Q7. A Ragged Hierarchy describes a self-referencing relationship, or self-join, within a dimension main table.
(a) True
(b) False
Answer: (b) False

Q8. Parent attribute is also known as an unbalanced hierarchy.
(a) True
(b) False
Answer: (b) False

Q9. Skip-level is hierarchies of attributes that are used in service of Microsoft SQL Server to arrange the members of a dimension into hierarchical structures.
(a) True
(b) False
Answer: (b) False

Q10. User-defined is a hierarchy in which certain members do not have values for certain higher levels are known as skip-level hierarchy.
(a) True
(b) False
Answer: (b) False

Q11. Ragged Hierarchy consists of values that define the hierarchy in a parent-child relationship.
(a) True
(b) False
Answer: (b) False

Q1. Dimensional model comprises of a —- and numerous dimensional tables and is used for assessing summarized data.
Answer: Fact table

Q2. —- define the axis of enquiry of a fact.
Answer: Dimensions

Q3. A fact table typically corresponds to an associative entity in the —- .
Answer: E-R model

Q4. Measures that can be added across only some dimensions are —- .
Answer: Semi additive

Q5. —- take a picture of the moment, where the moment could be anything.
Answer: Periodic snapshots

Q6. In —- table often has multiple date columns, each representing a complete step in the process.
Answer: Accumulating snapshots

Q7. Dimension tables consist of attributes that describe —- in the fact table.
Answer: Fact records

Q8. —- contain attributes that describe business entities.
Answer: Dimension tables

Q9. The surrogate key is derived from application data.
(a) True
(b) False
Answer: (b) False

Q10. Surrogate keys change while the row exists.
(a) True
(b) False
Answer: (b) False

Q11. In the case of natural keys, all tables that use the natural key will have to change.
(a) True
(b) False
Answer: (a) True

Q12. When every table has a uniform surrogate key, some tasks can be easily automated by composing the code in a table-independent way.
(a) True
(b) False
Answer: (a) True

Q13. The values of surrogate keys have relationship with the real world meaning of the data held in a row.
(a) True
(b) False
Answer: (b) False

Q14. The most common type of table is base table.
(a) True
(b) False
Answer: (a) True

Q15. A table with zero rows is an empty table.
(a) True
(b) False
Answer: (a) True

Q16. A temporal table is a table that records the period of time when a row is valid.
(a) True
(b) False
Answer: (a) True

Q17. XML table is used to hold data temporarily.
(a) True
(b) False
Answer: (b) False

Q18. OLAP stands for —- .
Answer: On-Line Analytical Processing

Q19. OLAP can be broadly divided into —- and —-
Answer: MOLAP, ROLAP

Q20. In MOLAP, data is stored in a —-
Answer: Multidimensional cube

Q21. —- can leverage functionalities inherent in the relational database as they sit on top of the relational database.
Answer: ROLAP

Q22. —- technologies combine the advantages of MOLAP and ROLAP.
Answer: HOLAP

Q1. OLAP databases contain two basic types of data i.e. measures and —-
Answer: Averages

Q2. —- is a data structure that aggregates the measures by the levels and hierarchies of each of the dimensions that you want to analyse.
Answer: Cube

Q3. —- is a set of values in a cube that are founded on a column in the cube’s detail table and that are generally numeric types.
Answer: Measure

Q4. —- is a member of a dimension whose worth is calculated at run time by utilizing an expression.
Answer: Calculated member

Q5. —- is a logical tree structure that organizes the members of a dimension such that each member has one parent member and none or more child members.
Answer: Hierarchy

Q6. —- is a technology that can be distributed to many users using a variety of platforms.
Answer: OLAP

Q7. The —- to use OLAP is negligible.
Answer: Learning curve

Q8. OLAP user’s queries are neither predictable nor repairable and the results of one query often frame the obligations of the next.
(a) True
(b) False
Answer: (a) True

Q9. To be productive, an analysis session should not be interactive and keep pace with the analyst’s speed of consideration.
(a) True
(b) False
Answer: (b) False

Q10. A metadata block is a named group of —- in a specific format.
Answer: Metadata

Q11. A metadata piece is a —- that describes characteristics like author, name, and rating.
Answer: Name/value pair

Q12. The simplest —- is an expression to get a query reader/writer for an exact metadata block.
Answer: Metadata query expression

Q13. In the query language, all indexes start at —-
Answer: Zero

Q14. The query dialect is not case sensitive and treats all individual features as —-
Answer: Lowercase

Q15. —- are like what you would do in linked spreadsheets, or in a multidimensional spreadsheet.
Answer: Cross dimensional calculations

Q16. —- are like spreadsheet functions that have been extended to understand OLAP.
Answer: OLAP Aware Functions

Q17. By describing the contents and context of data documents, the value of the original data/ files is smaller.
(a) True
(b) False
Answer: (b) False

Q18. Metadata (metacontent) are generally found in the business card catalogues of libraries.
(a) True
(b) False
Answer: (a) True

Q19. Metadata can be stored and organised in a database, often called a Metadata registry or Metadata repository.
(a) True
(b) False
Answer: (a) True

Q20. Administrative metadata provides information to help manage a resource.
(a) True
(b) False
Answer: (a) True

Q1. The —- for analysis-heavy devices comprises of more accomplished workers such as financial analysts and administration.
Answer: Client population

Q2. Office XP devices such as —- are high on the usability scale.
Answer: Excel

Q3. Companies using —- devices can make it cheaper for users to access data.
Answer: Microsoft’s BI

Q4. Specific returns resulting from Microsoft BI solutions include the reduced development and —-
Answer: Integration costs

Q5. —- allows users to quickly find exactly what they’re looking for, no issue how high volumes of data are.
Answer: Search engine

Q6. Microsoft Business Intelligence platform supplies —- methods and thereby supports data warehousing.
Answer: ETL (Extract, change, burden)

Q7. A —- platform should support both relational and multidimensional data warehousing databases.
Answer: Business intelligence

Q8. Business intelligence stages should provide open interfaces to data warehouse databases, OLAP, and —-
Answer: Data mining

Q9. Business intelligence stages should supply the capabilities to build and organize data warehouses in their —-
Answer: data warehouse databases

Q10. SQL Server 2000 is the anchor storage and query expertise behind —-
Answer: .NET servers

Q11. The firm actually values —- to create a large groundwork of focused business intelligence tools and applications that supports its platform.
Answer: Partnerships

Q12. Packaging and pricing distance Microsoft’s business intelligence platform from the platforms of Oracle, IBM, and —-
Answer: Hyperion

Q13. —- is a software business with two foremost lines of business: databases and applications.
Answer: Oracle

Q14. The choices on the —- menu support editing of text and code in documents.
Answer: Edit

Q15. The choices on the —- menu help you manage the client interface of Business Intelligence Development Studio.
Answer: View

Q16. The choices on the —- menu customize behaviour of the development environment.
Answer: Tools

Q17. The choices on the —- menu organise the behaviour of windows, explorers, and browsers in Business Intelligence Development Studio.
Answer: Window

Q18. The first stage of an ETL process is transformation stage which involves extracting the data from the source systems.
(a) True
(b) False
Answer: (b) False

Q19. The loading stage applies a series of rules or functions to the extracted data to derive the data for loading into the end target.
(a) True
(b) False
Answer: (b) False

Q20. A common use case for ETL tools include converting CSV files to formats readable by relational databases.
(a) True
(b) False
Answer: (a) True

Q1. Multidimensional model must contain at least one data source object.
(a) True
(b) False
Answer: (a) True

Q2. A data source connection can occasionally use Windows authentication or an authentication service provided by the database administration scheme.
(a) True
(b) False
Answer: (a) True

Q3. When retrieving data, the client library making the connection formulates a connection request that includes the credentials in the connection string.
(a) True
(b) False
Answer: (a) True

Q4. In completing the Wizard, the new data source appears in the Data Sources folder.
(a) True
(b) False
Answer: (a) False

Q5. In Data Source View Designer, using the data source view just created right-click anywhere in the work area and select Add/Remove Tables.
(a) True
(b) False
Answer: (a) True

Q6. To maximize the Microsoft Visual Studio development environment, click the —- button.
Answer: Maximize

Q7. To view the tables in the Diagram pane at 50 per cent, click the —- icon on the Data Source View Designer toolbar.
Answer: Zoom

Q8. To hide Solution Explorer, click the —- button on the title bar.
Answer: Auto Hide

Q9. We can use the —- to add, delete, or modify rows of data in the table.
Answer: DataView

Q10. A database dimension is a collection of associated objects, called —-, which can be used to supply information about fact data in one or more cubes.
Answer: Attributes

Q11. Uses the Dimension Wizard in —- to create a database dimension in a Microsoft SQL Server Analysis Services project.
Answer: SSDT

Q12. In Microsoft SQL Server Analysis Services, you can use the —- in SSDT to create a time dimension when no time table is available in the source database.
Answer: Dimension Wizard

Q13. A parent-child dimension is based on two dimension table columns that together define the lineage relationships among the members of the dimension.
(a) True
(b) False
Answer: (a) True

Q14. When you define a parent-child dimension, you can also select a third column to provide member names, which are displayed to end users as they browse cubes.
(a) True
(b) False
Answer: (a) True

Q15. You can use the Dimension Wizard to create parent-child dimensions
(a) True
(b) False
Answer: (a) True

Q1. A Cube is the main object of a —- where the majority of fine tuning, calculations, aggregation design etc.
Answer: SSAS solution

Q2. Right-click the Cube folder and select “New Cube”, and it will invoke the —-
Answer: Cube Wizard

Q3. A —- is a multidimensional structure that contains information for analytical purposes; the main constituents of a cube are dimensions and measures.
Answer: Cube

Q4. A cube provides a single place where all related data, for analysis, is —-
Answer: Stored

Q5. We use —- to lists the measures that are available in the template.
Answer: Measure Name

Q6. We use —- to lists the measure group for the measure.
Answer: Measure Group

Q7. Only the definitions for calculated members are retained; values are calculated in memory when required to answer a query.
(a) True
(b) False
Answer: (a) True

Q8. Calculated members have a Format String property that controls the format of cell values displayed to end users.
(a) True
(b) False
Answer: (a) True

Q9. After you deploy a cube, —- is viewable on the Browser tab in Cube Designer, and —- is viewable on the Browser tab in Dimension Designer.
Answer: Cube data, Dimension data

Q10. The Browser tab includes two panes to the right of the metadata pane: the upper pane is the —-, and the lower pane is the —-
Answer: Filter pane, data pane

Q1. —- store pre-computed results, which are measures that have been aggregated (typically summed) over a set of dimensional attributes.
Answer: Aggregate tables

Q2. —- Server has a calculation engine to perform a multitude of calculations.
Answer: Oracle BI

Q3. —- = SUM([Profit]/ [Sales])
Answer: Margin

Q4. The division is performed after each measure is —-
Answer: Aggregated

Q5. If a measure’s Aggregate Function property value is Sum, the measure value for a cube cell is calculated by adding the values in the —-
Answer: Measure’s source column

Q6. If a measure’s Aggregate Function property value is —-, the measure value for a cube cell is calculated by taking the lowest value in the measure’s source column.
Answer: Min

Q7. If a measure’s Aggregate Function property value is Max, the measure value for a cube cell is calculated by taking the —- value in the measure’s source column.
Answer: Highest

Q8. A —- command is an MDX script, included as part of the definition of the cube.
Answer: Script

Q9. The default scope is the whole cube, but you can define a more limited scope, known as a —- and then apply an MDX script to only that particular cube space.
Answer: Subcube

Q10. There are two types of MDX scripts: —- and —-
Answer: Default MDX script, User-defined MDX script

Q11. —- are measurements that define and track specific business goals and objectives that often roll up into larger organizational strategies.
Answer: KPIs

Q12. Open a KPI for —- a new KPI.
Answer: Editing or create

Q1. Different dimensions with a single hierarchy are called —-
Answer: Schema

Q2. Dimensions that have multiple hierarchies can be created in the —-
Answer: Dimension Wizard or Dimension Editor

Q3. In Microsoft SQL Server Analysis Services, an account type dimension is a dimension whose attributes represent a journal of accounts for financial reporting reasons.
(a) True
(b) False
Answer: (a) True

Q4. If you did not have such a standard mechanism, settling these nonstandard aggregation issues would need Multidimensional Expression (MDX) scripts.
(a) True
(b) False
Answer: (a) True

Q5. The purpose of an —- application is to supply users with valuable information to propel business conclusions.
Answer: Online Analytical Processing (OLAP)

Q6. A URL action is helpful for navigating to a particular World Wide Web location based on —- and figures.
Answer: Cube facts

Q7. The Cube Designer in Business Intelligence Development Studio (BIDS) includes an —-
Answer: Activity tab

Q8. —- actions supply fast access to lowest grade of details stored in a cube.
Answer: Drillthrough

Q9. Contrary to the action name, a drillthrough action does not get access to data stored in the source —-
Answer: Relational database

Q10. After the report is established, you can create an action that executes the —-
Answer: Report

Q1. To describe and visualize applications, a viewpoint appears just like a —-
Answer: Cube

Q2. A perspective is a —- of a model.
Answer: Sub-set

Q3. An MDX query is different from an MDX expression.
(a) True
(b) False
Answer: (a) True

Q4. Learning MDX will permit you to take advantage of some of the more advanced features of Analysis Services to create precisely the dataset you need.
(a) True
(b) False
Answer: (a) True

Q5. The MDX SELECT statement supports optional syntax.
(a) True
(b) False
Answer: (a) True

Q6. You can use Analysis Services as a data source for the —- PivotTable and PivotChart characteristics.
Answer: Office Excel 2007

Q7. Analysis Services provides dimensional data that is well-suited for data exploration in PivotTables and —-
Answer: Power View reports

Q8. Connecting to Analysis Services 2008 uses —-
Answer: MSOLAP.4

Q1. —- is the practice of automatically searching large stores of data to discover patterns and trends that goes beyond simple analysis.
Answer: Data mining

Q2. —- are any facts, numbers, or text that can be processed by a computer.
Answer: Data

Q3. The patterns, associations, or relationships among all types of data can provide —-
Answer: Information

Q4. Information can be converted into —-
Answer: Knowledge

Q5. —- refers to removal noise and inconsistent data.
Answer: Data cleaning

Q6. —- method uses some variable to predict unknown or future values of other variables.
Answer: Prediction

Q7. Data analysis can only be as good as the data that is being analysed.
(a) True
(b) False
Answer: (a) True

Q8. Data mining makes it possible to investigate routine enterprise transactions.
(a) True
(b) False
Answer: (a) True

Q9. In a relational structure, data is retained in tables, allowing ad hoc queries.
(a) True
(b) False
Answer: (a) True

Q10. —- can be utilised to find patterns and associations that would else be difficult to find.
Answer: Data mining

Q11. With —-, you will be able to find behaviours that are common among your customers.
Answer: Market segmentation

Q12. —- type of model represents data by nodes and links.
Answer: Network models

Q13. —- are used to find and characterize co-occurrences.
Answer: Association models

Q14. A —- is a set of heuristics and calculations that creates a data mining model from data.
Answer: Data mining algorithm

Q15. —- type of algorithm finds correlations between different attributes in a dataset.
Answer: Association algorithms

Q1. Model viewers are supplied in both SQL Server administrations Studio and —-
Answer: SQL Server Data Tools (SSDT)

Q2. The —- is provided in both SQL Server administrations Studio and SQL Server Data Tools (SSDT)
Answer: Prediction Query Builder

Q3. The —- in Microsoft SQL Server Analysis Services starts every time when you add a new mining structure to a data mining project.
Answer: Data Mining Wizard

Q4. —- Services provides many components that support data mining.
Answer: SQL Server Integration

Q5. A single mining structure can support multiple mining models that share the identical domain.
(a) True
(b) False
Answer: (a) True

Q6. When you define a mining structure, you use columns that are available in an existing data source view.
(a) True
(b) False
Answer: (a) True

Q7. The building blocks of the mining structure are the mining structure columns, which recount the data that the data source comprises.
(a) True
(b) False
Answer: (a) True

Q8. A mining structure cannot comprise nested tables.
(a) True
(b) False
Answer: (b) False

Q9. The —- supplied in Microsoft SQL Server Analysis Services change much more than just properties on the model.
Answer: Algorithm parameters

Q10. On the Mining Models tab of Data Mining Designer in SQL Server Data Tools (SSDT), —- the algorithm type and select Set Algorithm Parameters.
Answer: Right-click

Q1. The aim of a usual data mining task is to use the mining model to make —- .
Answer: Predictions

Q2. When you create a prediction, you normally supply some piece of new information and ask the model to develop a prediction based on the —- .
Answer: New data

Q3. Both —- and —- prediction queries use the PREDICTION JOIN syntax to define the new data.
Answer: Singleton, batch

Q4. In addition to predicting a value, you can customize a prediction query to return various types of information that are related to the —- .
Answer: Proposition

Q5. In —- -, right-click the instance of Analysis Services, point to New Query, and then click DMX.
Answer: Object Explorer

Q6. Data manipulation language (DML) is a language that you can use to create and work with data mining models in Microsoft SQL Server Analysis Services.
(a) True
(b) False
Answer: (b) False

Q7. You can use DMX statements to create process, delete, copy and predict against data mining models.
(a) True
(b) False
Answer: (a) True

Q8. Data definition statements are used in DMX to create and define, to import and export, and to drop existing models from a database.
(a) True
(b) False
Answer: (a) True

Q9. Data manipulation statements in DMX are not a part of the Data Manipulation Language (DML).
(a) True
(b) False
Answer: (b) False

Q10. DMX functions can be used to obtain information that is discovered during the training of your models, and to calculate new information.
(a) True
(b) False
Answer: (a) True

Q1. There are two types of data sources: the —- and the OLAP multidimensional data source.
Answer: Relationship database

Q2. —- is used to generate human-readable reports from various data sources.
Answer: Reporting software

Q3. SSRS supplies some extensions towards the data rendering, consignment and security of reports thereby allowing it to have a higher programmable ability.
(a) True
(b) False
Answer: (a) True

Q4. SSRS is a comprehensive reporting platform whereby accounts are retained on a centralized web server (or set of servers).
(a) True
(b) False
Answer: (a) True

Q5. The Report Manager is the central person who acts as a manager to decide when the reports will be scheduled to run along with maintaining the user profiles on the report server.
(a) True
(b) False
Answer: (a) True

Q6. OLAP is supported by —- by letting you design, create, and manage multidimensional structures.
Answer: Analysis Services

Q7. An Analysis Services instance is deployed in a mode that supports a —- architecture that is optimized for all kinds of solutions.
Answer: Memory and storage

Also study other MCQs

DistPub Team

Distance Publisher (DistPub.com) provide project writing help from year 2007 and provide writing and editing help to hundreds student every year.