Hello friends if you are looking for Data Warehouse Essentials: Concepts MCQ | Data Warehouse Essentials: Concepts Question Answers | Data Warehouse Essentials: Concepts Objective type questions | Data Warehouse Essentials: Concepts Accenture TQ Dumps
1]IDENTIFY ESSENTIAL FEATURES OF STRATEGIC INFORMATION?
ANS: PRESERVES DATA INTEGRITY, TIME-VARIANT
2]WHICH OF THE FOLLOWING OLAP STATEMENTS ARE TRUE?
ANS: OLAP PROVIDES REAL-TIME ANALYTICAL CAPABILITY, OLAP IS A PART OF THE OVERALL DATA WAREHOUSE IMPLEMENTATION
3]WHICH STATEMENTS ABOUT CLOUD-BASED DATA WAREHOUSE ARE TRUE?
ANS: CLOUD-BASED DATA WAREHOUSE ARE SCALABLE, CLOUD-BASED DATA WAREHOUSES ARE ELASTIC
4]MATCH THE DATA WAREHOUSING SOLUTIONS WITH THEIR ASSOCIATED BENEFITS?
ANS: ON-CLOUD DATA WAREHOUSE-PROVIDES SCALABILITY, COST EFFECTIVE, OFFERS BETTER SPEED AND CONNECTIVITY. ON- PREMISE DATA WAREHOUSE- PREFERRED IN BANKINF OR GOVERNMENT DOMAIN, OFFERS ABSOLUTE CONTROL OVER SECURITY
5]WHICH PROCESSES INVOLVED IN A DATA WAREHOUSE PROJECT ARE IMPORTANT?
ANS: DATA CLEANING, ETL
6]MATCH THE DATA MODELLING STRATEGIES WITH THEIR FEATURES?
ANS: DENORMALIZATION-USED ON PREVIOUSLY NORMALIZED DATABASES TO
INCREASE, ADDS REDUNDANT DATA, COMBINES TABLES. NORMALIZATION-
APPLIES FORMAL RULES TO ENFORCE DEPENDENCIES, ENSURES THE
DEPENDENCIES ARE PROPERLY ENFORCED, SPLITS TABLES
7]IDENTIFY SOME OF THE ESSENTIAL FEATURES WHICH DIFFERENTIATES A DATA WAREHOUSE FROM OLTP?
ANS: DATA WAREHOUSE PROVIDES PREDICTIVE ANALYTICAL CAPABILITIES, DATA
WAREHOUSE STORES HISTORICAL DATA
8]WHICH OF THE FOLLOWING LOCAL AND GLOBAL WAREHOUSE STATEMENTS ARE TRUE?
ANS: WE CAN PROVISION A SINGLE GLOBAL REPOSITORY FOR A PARTICULAR
DOMAIN, LOCAL DATA WAREHOUSE CANNOT BE ACCESSED GLOBALLY
9]IDENTIFY THE TERMINOLOGIES THAT WE GENERALLY USE IN DATA WAREHOUSING?
ANS: ETL, DIMENSIONAL MODEL
10]WHICH ARE ESSENTIAL TASKS THAT WE CAN EXECUTE TO FACILITATE BUSINESS INTELLIGENCE?
ANS: EXTRACT, LOAD
11]SELECT DATA MODELLING STRATEGIES THAT WE CAN ADOPT TO CREATE AN ER MODEL?
ANS: NORMALIZATION, DENORMALIZATION
12]IDENTIFY ESSENTIAL TABLE TYPES THAT WE CAN USE TO IMPLEMENT A STAR SCHEMA?
ANS: DIMENSION TABLE, FACT TABLE
13]WHICH STATEMENTS ABOUT SNOWFLAKE ARE TRUE?
ANS: A SNOWFLAKE SCHEMA IS AN EXTENSION OF THE STAR SCHEMA, APPLICATION BINARY INTERFACE ALLOWS US TO CONTEXTUALIZES CONTRACTS
14]CHOOSE THE CHARACTERISTICS OF WEIGHTED REPORTS?
ANS: WITH WEIGHTED REPORTS WE GET A MEANINGFUL SUBTOTAL AND TOTAL, WEIGHTED REPORTS MULTIPLY ALL THE FACTS BY WEIGHT BEFORE AGGREGATING
15]IDENTIFY THE ESSENTIAL LEVELS OF MANAGEMENT THAT REQUIRE STRATEGIC REPORTS?
ANS: STRATEGIC, MIDDLE MANAGEMENT LEVEL
16]IDENTIFY THE ESSENTIAL DIFFERENCES BETWEEN RDBMS AND DATA LAKES?
ANS: RDBMS DATABASES ARE TRANSACTION WHILE DATA LAKES ARE NOT TRANSACTIONAL, RDBMS DATABASES DEFINES FIXED SCHEMA WHILE DATA LAKE FOLLOWS NO SCHEMA DESIGN
17]IDENTIFY THE ESSENTIAL COMPONENTS OF AZURE DATA LAKE?
ANS: SQL SERVER, DATA FACTORY