Sail E0 Webinar

MCQs

Total Questions : 64 | Page 2 of 7 pages
Question 11. Business Intelligence (BI) reporting analyses can be performed using ________ .
  1.    standard SQL only
  2.    extensions to SQL only
  3.    OLAP only
  4.    both standard SQL and extensions to SQL
 Discuss Question
Answer: Option A. -> standard SQL only
Question 12. We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .
  1.    dirty data
  2.    inconsistent data
  3.    non-integrated data
  4.    a "wrong format" problem
 Discuss Question
Answer: Option C. -> non-integrated data
Question 13. The reports generated by a reporting system are usually not delivered in which of the following media?
  1.    Web portal
  2.    Commercial courier service
  3.    Digital dashboard
  4.    E-Mail
 Discuss Question
Answer: Option B. -> Commercial courier service
Question 14. Data mining applications are used accomplish which of the following tasks?
  1.    Process transactions only
  2.    Do RFM analysis only
  3.    Do what-if analysis only
  4.    Do both RFM and what-if analysis
 Discuss Question
Answer: Option C. -> Do what-if analysis only
Question 15. Which of the following is an unsupervised data mining technique?
  1.    Cluster analysis only
  2.    Regression Analysis only
  3.    RFM Analysis only
  4.    Both Regression Analysis and RFM Analysis
 Discuss Question
Answer: Option A. -> Cluster analysis only
Question 16. In OLAP, we are interested in ________ .
  1.    levels only
  2.    dimensions only
  3.    measures only
  4.    measures and dimensions
 Discuss Question
Answer: Option D. -> measures and dimensions
Question 17. Which of the following is not a reason that operational data are difficult to read?
  1.    Non-duplicated data
  2.    Dirty data
  3.    Missing values
  4.    Non-integrated data
 Discuss Question
Answer: Option A. -> Non-duplicated data
Question 18. We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .
  1.    the basic probability
  2.    support
  3.    lift
  4.    confidence
 Discuss Question
Answer: Option D. -> confidence
Question 19. We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
  1.    Has ordered recently, orders frequently, and places a large order when she orders.
  2.    Hasn't ordered recently, orders infrequently, but places a large order when she orders.
  3.    Has ordered recently, orders frequently, but doesn't place a large order when she orders
  4.    Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.
 Discuss Question
Answer: Option C. -> Has ordered recently, orders frequently, but doesn't place a large order when she orders
Question 20. One popular classification technique in Business Intelligence (BI) reporting is ________ .
  1.    cluster analysis only
  2.    regression analysis only
  3.    RFM analysis only
  4.    both cluster analysis and regression analysis
 Discuss Question
Answer: Option C. -> RFM analysis only

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