1. OLAP is an acronym for a. Online Analytical Processing b. Online

Document technical information

Format pdf
Size 265.2 kB
First found May 22, 2018

Document content analysis

Category Also themed
Language
English
Type
not defined
Concepts
no text concepts found

Persons

Organizations

Places

Transcript

1. OLAP is an acronym for
a. Online Analytical Processing
b. Online Analysis Process
c. Online Arithmetic Processing
d. Object Linking and Processing
2. What is a Data warehouse
a. A database application that searches for hidden patterns in a database.
b. A database designed to support decision making in organizations. It is batch updated
and structured for rapid on-line queries and managerial summaries
c. An interactive computer based system which helps decision makers utilize data and
models to identify and solve problems and make decisions.
3. The following is the characteristic(s) of data in a data warehouse
a.
b.
c.
d.
e.
Subject Oriented
Non-Volatile
Time-Variant
Integrated
All the above
4. Which of the following is false
a. Data Warehouse is designed for query and analysis
b. Data Warehouse is designed for transaction processing
c. Data Warehouse consolidates data from several sources
d. Data Warehouse maintains the records of both historical and the current data
5. The data in Data Warehouse is generally
a.
b.
c.
d.
Clean Data
Dirty Data
Clean and Dirty Data
None of above
6. What is Metadata
a. Metadata contains the relationship between Dimension and Fact Tables
b. Metadata describes data and other structures, such as objects, business rules, and
processes
c. Metadata stores the aggregation information
d. Metadata contains only business rules
7. Multidimensional data can be queried and manipulated using
a.
b.
c.
d.
T-SQL
MDX
MDAC
OWC
8. The following is not the characteristic of Dimension table
a. Describes business entities
b. Presents data organized into Hierarchies
c. Describes data in the fact table
d. Referential integrity need not be maintained between dimension tables and the fact
table
9. Different Storage Modes used for storage of cubes are
a.
b.
c.
d.
MOLAP
ROLAP
HOLAP
All the above
10. Which of the following best describes the Fact table
a.
b.
c.
d.
Contains only measures
Contains only keys that join to Dimension Tables
Contains measures and keys that join to Dimension tables
None of the above
11. Which of the following is false
a. A private dimension is a dimension created for an individual cube
b. A shared dimension is a dimension that can be used by multiple cubes
c. A virtual dimension is a logical dimension based on the columns from a physical
dimension
d. The storage mode of a virtual dimension can be MOLAP, ROLAP or HOLAP
12. Which of the following is TRUE for Cube Storage Mode
a. MOLAP copies all of the data and all the aggregates to the analysis server in an
optimized multidimensional format
b. ROLAP leaves the original data in the relational tables and uses separate set of relational
tables to store the aggregates
c. In HOLAP, data remains in the relational tables, but aggregations are stored on the
server in optimized multidimensional fomat
d. All the above
13. The following Storage Mode gives the best Query Performance
a. MOLAP
b. ROLAP
c. HOLAP
14. What is a Datamart
a. It is a subset of data warehouse and it supports a particular region, business unit or
business function
b. It is a superset of data warehouse
c. It is a copy of data warehouse
d. None Of the above
15. Which of the following is false
a. In a star schema every dimension will have a primary key
b. In a star schema, a dimension table will have one or more parent tables
c. In a snow flake schema, dimension table will have one or more parent tables
d. In a star schema, hierarchies for the dimensions are stored in the dimensional table
itself
e. In Snow Flake schema, hierarchies are broken into separate tables
16. Snowflaking means
a. Normalizing the data
b. Denormalizing the data
c. None of Above
17. Which of the following is false for Cubes
a.
b.
c.
d.
Cubes are multi-dimensional data representation
Cubes replicate data in the dimension and fact tables
Cubes do not require updating when the data warehouse data is updated
Cubes provide an easy-to-use mechanism for querying data with quick and uniform
response times
18. The methods of processing the cubes
a.
b.
c.
d.
Incremental Update
Refresh Data
Process (Rebuild) Data
All the Above
19. Which of the following is false
a.
b.
c.
d.
Cube contains one or more Partitions
Virtual Cubes retrieve information across multiple cubes
Every Partition in a Cube should have the same storage mode
All the above
20. The Process by which data from transaction system or flat files is loaded in the datawarehouse
schema is
a. Extraction
b. Transformation
c. Loading
d. All the above
21. During ETL load we generally have
a. Unsorted data for Aggregation
b. Sorted data for Aggregation
c. Does not matter if we use Sorted or Unsorted data for Aggregation
22. Sequence of jobs to load data in to warehouse
a. First load data into fact tables then dimension tables, then Aggregates if any
b. First load data into dimension tables, then fact tables, then Aggregates if any
c. First Aggregates then load data into dimension tables, then fact tables
d. Does not matter if we load either of fact, dimensions, or aggregates
23. Which of the following is false for Surrogate Keys
a.
b.
c.
d.
These keys are maintained within the data warehouse
These keys are taken from the source data
This uniquely identifies each entity in the dimension table regardless of its source key
All the above
24. The following is the characteristic(s) of Aggregations
a. Aggregations are precalculated summaries of data
b. Aggregations are stored in the multidimensional structure in cells at coordinates
specified by the dimensions
c. Results in the fastest possible response time
d. All the above
25. The Data Analysis Tools that can be used to analyze data that is stored in data warehouse
a.
b.
c.
d.
OLAP Manager
Microsoft Excel 2000
Microsoft English Query
All the above
26. Solution for managing Slowly Changing Dimension in which history of data is tracked
accurately
a.
b.
c.
d.
Type 1: Overwrite the dimension record
Type 2: Write another dimension record
Type 3: Updating the dimension record and moving old value to a separate attribute
None of the above
27. Which of the following method is used to view the data at different levels of granularity
a.
b.
c.
d.
e.
Drill Down
Drill Up
Drill Across
Drill Through
All the above
28. Drill Across generally uses the following join to generate report
a. Self Join
b. Inner Join
c. Outer Join
29. What is Data Mining
a. It is a process which removes the history data in the data warehouse
b. It is a process which removes the current data in the data warehouse
c. It is a process that looks at the data in the cube and searches for patterns
d. None of the above
30. In general data in Data Warehouse is
a. Normalized
b. Denormalized
c. None of the Above
×

Report this document