Question

Download Solution PDF

Which of the following table contains the primary information in the data warehouse?

  1. Dimension table
  2. Fact table
  3. Lookup table
  4. Primary table

Answer (Detailed Solution Below)

Option 2 : Fact table

Detailed Solution

Download Solution PDF
Download Solution PDF
‹‹ Previous Ques
Next Ques ››
Exams Tests Super Practice

More Data Warehousing and Data Mining Questions

Q1.Which of the following table contains the primary information in the data warehouse?
Q2.A central repository of information that can be analyzed to make more informed decisions is known as:
Q3.Identify the correct statement(s) about Data Warehousing (DW): A. DW system must be acceptable to regulators and business community. B. DW system must not be based on open source platforms C. DW system must present information attractive to users. D. DW system must be secure bastion that protects the information. E. DW system must be adaptive to change. Choose the correct answer from the options given below:
Q4.Data warehousing has various characteristics including: (A) Focuses on modelling and analysis of data relating to a specific area (B) Data warehouse is an integration of data from various systems like CRM system, SCM system, etc (C) The time variant for a data warehouse has a historical perspective for example, past 10-20 years (D) It is stored permanently i.e data once stored can not be updated (E) It is stored temporarily i.e data once stored can be updated Choose the most appropriate answer from the options given below:
Q5.________ is referred to as discovering patterns based on a large set of previous year's data.
Q6.Which of the following statements is true?
Q7.Which of the following statements is/are correct regarding application of data mining techniques? (A) Predicting future trends based on information available (B) Electronic data interchange (C) Analysing demographic information about customers (D) Credit risk analysis Choose the correct answer from the options given below:
Q8.A company stores products in a warehouse. Storage bins in this warehouse are specified by their aisle, location in the aisle, and self. There are 50 aisles, 85 horizontal locations in each aisle, and 5 shelves throughout the warehouse. What is the least number of products the company can have so that at least two products must be stored in the same bin?
Q9.What does the following statement represent in data migration? "Locate the useful information required to populate the customer relationship management and identify who maintains it, what it contains and how accurate it is."

More DBMS Questions

Q1.If a hash table is implemented as a search tree, the expected time required to enter n names and make m searches is proportional to : 
Q2.In an ER Diagram, a double ellipse is used to represent : 
Q3.An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true ?
Q4.Consider the following statements : I - The primary key of a relation cannot contain null values. II - Unique Key can have null values. Which among the following is true ? 
Q5.Consider a relation R with attributes {A, B, C} and functional dependency set S = {A → B, A → C }. Then relation R can be decomposed into two relations : 
Q6.Consider the relations : R1{Roll_no, Name, Grades} and R2 {Roll_no, Subject_ID, Grades} Which of the following operations cannot be performed using the above relations ? 
Q7.The degree of a relation in database is
Q8.Which of the following table contains the primary information in the data warehouse?
Q9.An alternate key in database table is also called
Q10.Which of the following/s is/are FALSE statement? A. An all key relation is always in BCNF since it has no FDs. B. A relation that is not in 4NF due to nontrivial MVD must be decomposed to convert it into a set of relations in 4NF. C. The decomposition removes the redundancy by the MVD. D. 3NF is stronger than BCNF. Choose the correct answer from the options given below:
Testbook Edu Solutions Pvt. Ltd.
1st & 2nd Floor, Zion Building,
Plot No. 273, Sector 10, Kharghar,
Navi Mumbai - 410210
support@testbook.com
Toll Free:1800 833 0800
Office Hours: 10 AM to 7 PM (all 7 days)
Company
About usCareers We are hiringTeach Online on TestbookPartnersMediaSitemap
Products
Test SeriesTestbook PassOnline CoursesOnline VideosPracticeBlogRefer & EarnBooks
Copyright © 2014-2022 Testbook Edu Solutions Pvt. Ltd.: All rights reserved
User PolicyTermsPrivacy
Hot Links： teen patti 3a all teen patti master real teen patti teen patti cash game