Sail E0 Webinar

MCQs

Total Questions : 46 | Page 4 of 5 pages
Question 31.  Data scrubbing is which of the following?
  1.    A process to reject data from the data warehouse and to create the necessary indexes
  2.    A process to load the data in the data warehouse and to create the necessary indexes
  3.    A process to upgrade the quality of data after it is moved into a data warehouse
  4.    A process to upgrade the quality of data before it is moved into a data warehouse
 Discuss Question
Answer: Option D. -> A process to upgrade the quality of data before it is moved into a data warehouse
Question 32.  A goal of data mining includes which of the following?
  1.    To explain some observed event or condition
  2.    To confirm that data exists
  3.    To analyze data for expected relationships
  4.    To create a new data warehouse
 Discuss Question
Answer: Option A. -> To explain some observed event or condition
Question 33.  The generic two-level data warehouse architecture includes which of the following?
  1.    At least one data mart
  2.    Data that can extracted from numerous internal and external sources
  3.    Near real-time updates
  4.    All of the above.
 Discuss Question
Answer: Option B. -> Data that can extracted from numerous internal and external sources
Question 34.  A snowflake schema is which of the following types of tables?
  1.    Fact
  2.    Dimension
  3.    Helper
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 35.  A data warehouse is which of the following?
  1.    Can be updated by end users.
  2.    Contains numerous naming conventions and formats.
  3.    Organized around important subject areas.
  4.    Contains only current data.
 Discuss Question
Answer: Option C. -> Organized around important subject areas.
Question 36.  An operational system is which of the following?
  1.    A system that is used to run the business in real time and is based on historical data.
  2.    A system that is used to run the business in real time and is based on current data.
  3.    A system that is used to support decision making and is based on current data.
  4.    A system that is used to support decision making and is based on historical data.
 Discuss Question
Answer: Option B. -> A system that is used to run the business in real time and is based on current data.
Question 37.  The @active data warehouse architecture includes which of the following?
  1.    At least one data mart
  2.    Data that can extracted from numerous internal and external sources
  3.    Near real-time updates
  4.    All of the above.
 Discuss Question
Answer: Option D. -> All of the above.
Question 38.  Fact tables are which of the following?
  1.    Completely denoralized
  2.    Partially denoralized
  3.    Completely normalized
  4.    Partially normalized
 Discuss Question
Answer: Option C. -> Completely normalized
Question 39.  Data transformation includes which of the following?
  1.    A process to change data from a detailed level to a summary level
  2.    A process to change data from a summary level to a detailed level
  3.    Joining data from one source into various sources of data
  4.    Separating data from one source into various sources of data
 Discuss Question
Answer: Option A. -> A process to change data from a detailed level to a summary level
Question 40. . The load and index is which of the following?
  1.    A process to reject data from the data warehouse and to create the necessary indexes
  2.    A process to load the data in the data warehouse and to create the necessary indexes
  3.    A process to upgrade the quality of data after it is moved into a data warehouse
  4.    A process to upgrade the quality of data before it is moved into a data warehouse
 Discuss Question
Answer: Option B. -> A process to load the data in the data warehouse and to create the necessary indexes

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0