BITS WILP Data Warehousing Quiz-2 2017-H2
Q1.
A1.
Q2.
In this technique of Data Loading, if primary key of incoming record matches with that of some already existing record, matching target is updated:
A2.
Q3.
A3.
Q4.
A4.
(D), adding percentages does not result in anything meaningful.
Q5.
A5.
A primary key 'Product_id' in dimension table 'Product' may appear multiple number of time in the central fact table as a foreign key.
Q6.
A6.
Q7.
A7.
Q8.
A8.
Q9.
A9.
Q10.
A10.
“Triggers are stored programs, which are automatically executed or fired when some events occur on the table like insertion, deletion or updation of data. It is a database object which could be defined on the table, view, schema, or database with which the event is associated”.
Q1.
A1.
B, C are
true, in Type-2 change of dimension tables for incorporating changes in the
dimension, we add a new row.
With Type-2
change, previous records remain as they were and the changed / new incoming row
is simply inserted as new.
This type
of change does partition the history.
Answer: DQ2.
In this technique of Data Loading, if primary key of incoming record matches with that of some already existing record, matching target is updated:
A2.
Q3.
A3.
Q4.
A4.
(D), adding percentages does not result in anything meaningful.
Q5.
A5.
A primary key 'Product_id' in dimension table 'Product' may appear multiple number of time in the central fact table as a foreign key.
Q6.
A6.
Q7.
A7.
Q8.
A8.
URL: https://www3.nd.edu/~rjohns15/cse40647.sp14/www/content/lectures/07%20-%20Data%20Transformation.pdf
From this
page, it appears that ‘data reduction’ is a ‘data extraction’ task.
Data
Reduction
• Do we
need all the data?
• Data
mining/analysis can take a very long time
•
Computational complexity of algorithms
Data
Reduction
• Sampling: selecting a subset of the data objects to be analyzed.
• Feature
selection: selecting a subset of the
features to be analyzed.
• Dimensionality
reduction: creating new features that are
a combination of the old features.
…
Data
Transformation Tasks:
Q9.
A9.
Answer:
True
“The most obvious characteristic of the star schema is that
dimension tables are not normalized.”
“Snowflake
schema stores exactly the same data as the star schema. The fact table has the
same dimensions as it does in the star schema example. The most important
difference is that the dimension tables in the snowflake schema are normalized.
Interestingly, the process of normalizing dimension tables is called
snowflaking.”Q10.
A10.
“Triggers are stored programs, which are automatically executed or fired when some events occur on the table like insertion, deletion or updation of data. It is a database object which could be defined on the table, view, schema, or database with which the event is associated”.
Awesome...
ReplyDeleteSurvival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Now
Delete>>>>> Download Full
Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download LINK
>>>>> Download Now
Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Full
>>>>> Download LINK Ye
i tried mailing you , but it is not going through. Can you please share the answers to this question paper if you have.
ReplyDeleteThanks
Mail me at ashishjainblogger@gmail.com
DeleteMention the subject(s) for which you want help.
Thanks for putting up the content in such organized manner.Great Help. Thumbs UP !!
ReplyDeleteRecorded lecture links are not working please help
ReplyDeleteIs there a group/whatsapp group for Mtech in computing systems and Infrastructure?
ReplyDeleteVery useful .. Thank you very much
ReplyDeleteAre you Looking for Smart Device Development? QuantaEd Solutions is the Best Smart Device Development Company, We design and develop smart devices that suit the healthcare requirements. For any inquiry call us we will provide all kind of assistance. For more details visit- https://quantaedsolutions.com
ReplyDeleteThis post is so interactive and informative.keep updating more information...
ReplyDeleteSoftware Testing Courses in Mumbai
Software Testing Training in Ahmedabad
Software Testing Courses in Kochi
Software Testing Courses in Trivandrum
Software Testing Courses in Kolkata
Thanks for the blog article.Thanks Again. Keep writing.
ReplyDeletejava online training hyderabad
java online training in india
Thanks for the blog article.Much thanks again. Fantastic.
ReplyDeleteonline training in java
online training on java
AI & ML in Dubai
ReplyDeletehttps://www.nsreem.com/ourservices/ai-ml/
Artificial intelligence is very widespread today. In at least certainly considered one among its various forms has had an impact on all major industries in the world today, NSREEM is #1 AI & ML Service Provider in Dubai
1634348519669-9
Thank you for giving valuable information about software for portable device, we can also develop custom software from pixabulous design.
ReplyDeleteNice Blog!!!
ReplyDeleteServiceNow Training
ServiceNow Online Training in Hyderabad
This article explains in a clear manner. Nice way of explaining. Thanks for sharing. cloud engineering services
ReplyDeleteI really liked your blog post.Much thanks again. Awesome.
ReplyDeletejava online training
java training
Data Science Training In Noida
ReplyDeleteData Science course In Noida
WILP is a set of educational programs designed in such a way that they can be easily integrated into your work life. Earlier, only highly developed nations like the US and Europe were indoctrinating WILPs but now the WILP in India have also gained a lot of popularity.
ReplyDeleteCandidates who wish to take the BITSAT should begin studying as soon as possible. Due to the high level of competition, it is critical to follow the best BITSAT 2022 preparation tips recommended by professionals. This blog post contains BITSAT 2022 study suggestions as well as exam pattern and syllabus information. Continue reading to get answers to all of your questions. To know more information visit @ SSSi Online Tutoring Services.
ReplyDeleteSurvival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Now
ReplyDelete>>>>> Download Full
Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download LINK
>>>>> Download Now
Survival8: Bits Wilp Software Development For Portable Devices 2017-H2 Handout >>>>> Download Full
>>>>> Download LINK bO
"Thanks for sharing this informative blog on Best Software Development company in chennai,Software Development Company in chennai,
ReplyDeleteBest Software Development company in india,
Top software development company in chennai,
Software Development Company in india"
The BITS Pilani Admission Process is designed to select the brightest minds for its world-class programs. With its independent entrance exam, BITSAT, and direct admission opportunities for board toppers, the institute ensures that only the most deserving candidates secure a place.
ReplyDelete