{"id":8644,"date":"2020-04-28T12:32:58","date_gmt":"2020-04-28T12:32:58","guid":{"rendered":"https:\/\/www.monsterindia.com\/career-advice\/common-warehouse-interview-questions-to-read-before-your-next-interview-8644\/"},"modified":"2021-11-23T11:41:37","modified_gmt":"2021-11-23T11:41:37","slug":"common-warehouse-interview-questions-to-read-before-your-next-interview","status":"publish","type":"post","link":"https:\/\/www.foundit.in\/career-advice\/common-warehouse-interview-questions-to-read-before-your-next-interview\/","title":{"rendered":"Common Warehouse Interview Questions to read before your next interview"},"content":{"rendered":"\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">Data Warehousing and Business Intelligence (DWBI) is a rewarding career choice if you love managing data. And If you are looking for your next job in Data Warehouse, here are some of the most common Data Warehouse interview questions. <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>1. What is Data Warehouse? <\/strong><\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">A Data Warehouse is the automated storage of an organization\u2019s historical data to help with data analytics. The data reinforces the decision-making process in a company. <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>2. List the Data Warehouse Architectures. <\/strong><\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">There are 3 types of data warehouse architectures.<\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>a) Single Tier Architecture &#8211;<\/strong> The aim of a single layer is to reduce the amount of stored data by clearing redundant data.<\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">It is not normally used.<\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>b) Two Tier Architecture &#8211;<\/strong> This architecture separates physically accessible sources from the warehouse.<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">This architecture cannot be expanded, and it does not support a large number of end-users.<\/span><\/li><li><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">This architecture faces connectivity issues due to network restrictions.<\/span><\/li><\/ul>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>c) Three Tier Architecture &#8211;<\/strong> This is the most popular architecture. It is made up of the Bottom, Middle and Top Tier.<\/span><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">Bottom Tier \u2013 This is an interactive database of the Data Warehouse. The data is transformed, cleansed and loaded.<\/span><\/li><li><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">Middle Tier \u2013 This is an OLAP server. It gives a hypothesized view of the database which serves as a mediator between the database and end-user.<\/span><\/li><li><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">Top Tier \u2013 This is a front-end client layer and directs data out of the Data Warehouse.<\/span>\n<\/li><\/ul>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>3. Explain Data Analytics in the context of Data Warehousing.<br> <\/strong><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 Data analytics is the discipline of studying new data for the intention of drawing business-driven deductions from the data. <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 The purpose of a Data Warehouse is to allow data analysis. <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>4. Explain Subject-Oriented Data Warehouse.<br><\/strong> <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">Subject-oriented data warehouses are those that keep data around a certain subject such as sales, product and customers among others. <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">What is OLAP? <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">OLAP is On Line Analytical Processing. It is a system which collects, processes and manages multi-dimensional data for management and analysis. <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>5. What is OLTP? <br><\/strong><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">OLTP is On Line Transaction Processing. It is a system which adapts the data when it is received by a large number of current users. <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong><br>6. What are the Types of OLAP Servers?<br> <\/strong><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 Multidimensional OLAP. <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 Relational OLAP. <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 Specialized SQL Servers. <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 Hybrid OLAP. <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>7. What are Some of the Functions Carried Out by OLAP? <\/strong><\/span><\/p>\n\n\n\n<p><span style=\"font-size: 12pt\"><span style=\"font-family: verdana,geneva,sans-serif\">Some of the major functions carried out by OLAP include pivot, dice, slice, drill-down and roll-up. <br><\/span><span style=\"font-family: verdana, geneva, sans-serif\"><br><\/span><span style=\"font-family: verdana,geneva,sans-serif\"><strong>You may also like:<\/strong> <a href=\"https:\/\/www.monsterindia.com\/career-advice\/10-tips-to-stay-focused-in-an-interview\/\" target=\"_blank\" rel=\"noopener\">10 Tips to stay focused in an Interview<\/a><\/span><\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><a href=\"https:\/\/www.monsterindia.com\/career-advice\/6-questions-to-ask-at-the-end-of-your-job-interview\/\" target=\"_blank\" rel=\"noopener\">6 Questions to ask at the end of your Job Interview<\/a><\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>8. What is a Star Schema?<\/strong> <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">The star schema is a representation used in data warehousing when a single fact table notes a range of dimension tables. For a star schema \u2018keys\u2019 from all the dimension tables move into the fact table. This entity-relationship diagram looks like a star giving it its name. <\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong><br>9. What is a Snow Flake Schema?<br> <\/strong><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">Like the star schema a single fact table refers to a number of other dimension tables in the snow flake schema. These dimension tables are additionally standardised into numerous related tables. This schema is called a snowflake schema as the tables are snow flaked into smaller tables further. <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>10. What do you understand by a Mini Dimension?<br> <\/strong><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">Mini dimensions are measurements that are used when a large number of promptly changing attributes are separated. <\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><strong>11. What is ER Model?<br> <\/strong><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">The ER Model or Entity Relations Model is a method for data modelling where the goal is to regularise the data by reducing redundancy.<\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\"><br><strong>Looking for Data Warehouse Jobs in top cities? Click at the links below:<\/strong><\/span><\/p>\n\n\n\n<p><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 <a title=\"Data Warehouse Jobs in Gurgaon\" href=\"https:\/\/www.monsterindia.com\/search\/data-warehouse-jobs-in-gurgaon\" target=\"_blank\" rel=\"noopener\">Data Warehouse Jobs in Gurgaon<\/a><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 <a title=\"Data Warehouse Jobs in Mumbai\" href=\"https:\/\/www.monsterindia.com\/search\/data-warehouse-jobs-in-mumbai\" target=\"_blank\" rel=\"noopener\">Data Warehouse Jobs in Mumbai<\/a><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 <a title=\"Data Warehouse Jobs in Chennai\" href=\"https:\/\/www.monsterindia.com\/search\/data-warehouse-jobs-in-chennai\" target=\"_blank\" rel=\"noopener\">Data Warehouse Jobs in Chennai<\/a><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 <a title=\"Data Warehouse Jobs in&nbsp;Delhi\" href=\"https:\/\/www.monsterindia.com\/search\/data-warehouse-jobs-in-delhi\" target=\"_blank\" rel=\"noopener\">Data Warehouse Jobs in&nbsp;Delhi<\/a><\/span><br><span style=\"font-family: verdana,geneva,sans-serif;font-size: 12pt\">\u2022 <a title=\"Data Warehouse Jobs in Pune\" href=\"https:\/\/www.monsterindia.com\/search\/data-warehouse-jobs-in-pune\" target=\"_blank\" rel=\"noopener\">Data Warehouse Jobs in Pune<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Warehousing and Business Intelligence (DWBI) is a rewarding career choice if you love managing data. And If you are looking for your next job in Data Warehouse, here are some of the most common Data Warehouse interview questions. 1. What is Data Warehouse? A Data Warehouse is the automated storage of an organization\u2019s historical [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":8645,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[147],"tags":[],"class_list":{"0":"post-8644","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-interview-questions"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/posts\/8644","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/comments?post=8644"}],"version-history":[{"count":1,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/posts\/8644\/revisions"}],"predecessor-version":[{"id":10235,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/posts\/8644\/revisions\/10235"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/media\/8645"}],"wp:attachment":[{"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/media?parent=8644"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/categories?post=8644"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foundit.in\/career-advice\/wp-json\/wp\/v2\/tags?post=8644"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}