Question:* Which of the following implements Multidimensional OLAP?
Answer: • All of the Above
Question:* What is a Data Mart?
Answer: • an access layer comprising a subset of a data warehouse
Question:* When is it appropriate to use a Joiner Transformation during ETL?
Answer: • All of the Above
Question:* Which system is appropriate for recording customer transactions in real time?
Answer: • OLTP
Question:* Which of the following is true about Snowflake schema?
Answer: • All of the above
Question:* Which of the following uses the idea of a data cube to represent the dimensions of data ?
Answer: • OLAP or Multidimensional Database
Question:* Which of the following is true about Data Warehousing?
Answer: • All of the given options are true
Question:* Data Warehouse (OLAP) is based on which of the following?
Answer: • All of given options are valid
Question:* What is the process by which raw data is migrated into a data warehouse?
Answer: • Extract, Transform, Load
Question:* Which of the following are valid Logical Extraction methods?
Answer: • Both Full Extraction and Incremental Extraction
Question:* Which of the following is TRUE about MOLAP?
Answer: • All of the given options are valid
Question:* Which of the following is VALID about time-variant characteristic of a data warehouse?
Answer: • All of the given options are valid
Question:* Which of the following is true about Data mining?
Answer: • All of the given options are valid
Question:* Which of the following systems is optimized for multidimensional analysis?
Answer: • OLAP
Question:* Operational Database(OLTP) is based on which of the following?
Answer: • Entity Relationship Model
Question:* Which of the following is TRUE about ROLAP?
Answer: • All of the given options are valid
Question:* What table is at the center of a star schema?
Answer: • fact table
Question:* What is an example of an OLAP dice operation?
Answer: • specifying a particular year and region
Question:* What is the "grain" of a fact table?
Answer: • the most atomic level at which the facts may be defined
Question:* A data warehouse is built as a separate repository of data, different from the operational data of an enterprise because?
Answer: • A data warehouse contains summarized data whereas the operational database contains transactional data
Question:* Which MDX operation returns all possible combinations of one or more sets?
Answer: • Crossjoin
Question:* Which of the following is true about Specialized SQL servers?
Answer: • It provides advanced query language and query processing support for SQL queries over star and snowflake schemas
Question:* Which of the following operations navigate data from less detailed data to highly detailed data?
Answer: • Drill-down
Question:* Which of the following is true about 'Pivot' operation?
Answer: • All of the given options are valid
Question:* Where does cleansing take place during the ETL phase of data bound for a MOLAP based data warehouse?
Answer: • Staging Area
Question:* The ‘Slice’ operation deals with?
Answer: • Selecting the cells of any one dimension of data cube
Question:* Which language is appropriate for querying a non-relational OLAP database?
Answer: • MDX
Question:* Which of the following is a method for delta detection during the ETL process?
Answer: • (both of these choices)
Question:* Choose the most correct statement:
Answer: • Fact Constellation schema contains two Fact tables
Question:* Which of the following is true about Data Scrubbing?
Answer: • It involves data cleansing
Question:* Modifying an OLAP Cube to view information from only a single year is an example of which operation?
Answer: • slice
Question:* What is an OLAP Cube?
Answer: • an array in which data is stored and characterized by multiple dimensions
Question:* Which of the following environments has a higher amount of Joins
Answer: • OLTP
Question:* Which of the following would not be a part of the fact table of a star schema representing sales data?
Answer: • Product name when a Product dimension table exists
Question:* Which of the following is NOT a benefit of data warehousing?
Answer: • To collate data from multiple sources into a multiple databases
Question:* Which of the following is not a VALID characteristic of data warehouse?
Answer: • Volatile
Question:* Which of the following contains historical data?
Answer: • OLAP
Question:* Which of the following is an example of a non-aggregatable measure?
Answer: • probability of default
Question:* Which line is not a valid MDX comment?
Answer: • ## this line
Question:* Which of the following can present summary data from an OLAP server?
Answer: • pivot tables
Question:* Which of the following is a valid disadvantage of a dimensional approach?
Answer: • Loading the data warehouse with data from different operational systems is complicated
Question:* Which of the following enviroments are in third normal form 3NF?
Answer: • OLTP
Question:* Which of the following operation is performed by introducing new dimensions?
Answer: • Drill-down
Question:* Which of the following is true about 'Dice' operation?
Answer: • The Dice operation performs selection of two or more dimension on a given cube
Question:* Which operation on a multidimensional database is most equivalent to a relational join?
Answer: • drill-across
Question:* What Amazon Reshift compression encodings would be most appropriate for the columns (Date, City, Description), respectively?
Answer: • Delta, Byte-dictionary, LZO
Question:* Choose the most correct statement:
Answer: • Snowflake schema contains normalized Dimension table
Question:* Which of the following is true about multidimensional models?
Answer: • It uses two level of data storage representation to handle dense and sparse data sets
Question:* Which of the following is not a type of OLAP?
Answer: • Analytical
Question:* Which of the following schema is generally the most denormalized?
Answer: • Star
Question:* In which of the data storing approaches does transaction data get partitioned into facts?
Answer: • dimensional approach
Question:* In a 3-tier architecture of the data warehouse, the OLAP engine is related to:
Answer: • The Second layer of the architecture
Question:* In order to populate the data warehouse, which of the following set of operations are appropriate?
Answer: • Query and update
Question:* Which of the following applies to Fact Tables?
Answer: • Completely normalized
Question:* What is the principal disadvantage of Type 3 Slowly Changing Data management?
Answer: • Stores only a finite number of historical changes
Question:* Which of the following is the most appropriate data structure for indexing a MOLAP Cube?
Answer: • Bitmap index
Question:* Which of the following is a property of Data Warehouse data?
Answer: • Read Only
Question:* Which of the following is not a property of a perspective?
Answer: • Can securely restrict access to objects in a cube
Question:* Which of the following operations performs aggregation on a data cube by dimension reduction?
Answer: • Roll-up
Question:* Which of the following is not TRUE about subject oriented characteristics of a data warehouse?
Answer: • Data should not change once it is entered into the warehouse
Question:* ‘ROLAP’ is preferred over ‘MOLAP’ in which of the following cases?
Answer: • A data warehouse and relational database are separable
Question:* Which of the following is not an advisable implementation of division in MDX?
Answer: • measures.[Value A]/measures.[Value B]
Question:* Among the following, which is NOT the objective of clustering?
Answer: • It facilitates OLAP operations
Question:* An ETL Joiner Transformation is performed on Source A with 10,000 rows and Source B with 25,000 rows. Which source should be the master?
Answer: • Source A to speed up the join process
Question:* Which of following stages involve data update in the warehouse for every transaction performed on the source data?
Answer: • On time data warehouse
Question:* When is a column-based engine a more appropriate architecture for a Data Warehouse than a row-based engine?
Answer: • dynamic, unpredictable query patterns
Question:* Which of the following is not a valid context for the MDX From clause?
Answer: • a perspective (subset of measures and dimensions
Question:* What is true of querying normalized data in a relational database for the purposes of business analysis?
Answer: • Aggregating relevant data requires multiple table joins
Question:* What are the following is not a requirement of First Normal Form?
Answer: • No columns that are not dependent on a primary key
Question:* Choose the most correct statement:
Answer: • OLAP is more flexible then OLTP
Question:* What is a slice in the context of Amazon Redshift?
Answer: • A partition allowing each of core of a multi-processor node to process the node's workload in parallel
Question:* Which of the following environments has more indexes?
Answer: • Data Warehousing env
Question:* Without deliberate security measures, which of the following MDX clauses is susceptible to injection attack?
Answer: • WHERE
Question:* Which of the following is an appropriate method for mitigating the database explosion associated with sparse dimensions?
Answer: • create a composite to stand-in for the sparse dimension
Question:* Which of the following is a required property of information passed to the Microsoft Sequence Clustering Algorithm?
Answer: • sequence information stored as a nested table
Question:* Online extraction process falls under which type of data extraction method?
Answer: • Physical Extraction
Question:* A data warehouse is an ‘integrated’ collection of data because?
Answer: • It is a collection of data of different types
Question:* What property do Router Transformations and Filter Transformations have in common?
Answer: • single input group transformation
Question:* All else being equal, which of the following elements of a single MDX WHERE clause will evaluate first?
Answer: • MEMBER [Measures].[B Twice] AS [Measures].[Measure B] + [Measures].[Measure B], SOLVE_ORDER = 4
Question:* Where is the OLAP page pool stored in memory in an Oracle Database 10g and later?
Answer: • User Global Area
Question:* Choose the most correct statement:
Answer: • Fact Constellation schema contains two Fact tables
Question:* Choose the most correct statement:
Answer: • Snowflake schema contains normalized Dimension table
Question:* Choose the most correct statement:
Answer: • OLAP is more flexible then OLTP
No comments:
Post a Comment