MIS 2201 Exam Questions| Already
Answered| GRADED A+
What is a data warehouse? - ANSWER-a set of databases to support decision-making in an organization.
What is a data mart? - ANSWER-database or databases focused on addressing the concerns of a specific
problem or business unit.
What are the query and reporting tools? - ANSWER-Canned reports, ad hoc reporting tools, dashboards,
OLAP, data cube
What is canned reports? - ANSWER-provide regular summaries of information in a predetermined
format
What is ad hoc reporting tools? - ANSWER-puts users in control so that they can create custom reports
on an as-needed basis by selecting fields, ranges, summary conditions, and other parameters.
What is dashboards? - ANSWER-heads-up display of critical indicators that allows managers to get a
graphical glance at key performance metrics.
What is Online Analytical Processing (OLAP)? - ANSWER-takes data from standard relational databases,
calculates and summarizes the data, and then stres the data in a special database called a data cube.
What is a data cube? - ANSWER-special database used to store data in OLAP reporting.
What are data fields in Tableau? - ANSWER-made from the columns in your data source.
What is data type in Tableau? - ANSWER-integer, string, date.
, What is dimension in Tableau? - ANSWER-contain qualitative values (names, dates or geographical data)
use them to categorize, segment and reveal details in your data. Aggregated - minimum, maximum,
count, or count (distinct)
What is measure in Tableau? - ANSWER-contain numeric, quantitative values. Aggregated - sum,
average, and median.
What is discrete in Tableau? - ANSWER-"individually separate and distinct" mathematical terms.
What is continuous in Tableau? - ANSWER-"forming an unbroken whole, without interruption"
mathematical terms.
What is big data? - ANSWER-refers to the huge collections of data that are difficult to process, analyze,
and manage using conventional database tools.
What are the 5 V's of big data? - ANSWER-high volume, high velocity, diversified variety. unknown
veracity, and low-density value.
What is high volume? - ANSWER-the size and amounts of big data that companies manage and analyze.
What is high velocity? - ANSWER-the speed at which companies receive, store and manage data - e.g.,
the specific number of social media posts or search queries received within a day, hour or other unit of
time.
What is diversified variety? - ANSWER-the diversity and range of different data types, including
unstructured data semi-structured data and raw data
What is unknown veracity? - ANSWER-the "truth" or accuracy of data and information assets, which
often determines executive-level confidence
What is low-denisty value? - ANSWER-large volumes of data containing unimportant details. comes from
insight discovery and pattern recognition that lead to more effective operations, stronger customer
relationships and other clear and quantifiable business benefits
Answered| GRADED A+
What is a data warehouse? - ANSWER-a set of databases to support decision-making in an organization.
What is a data mart? - ANSWER-database or databases focused on addressing the concerns of a specific
problem or business unit.
What are the query and reporting tools? - ANSWER-Canned reports, ad hoc reporting tools, dashboards,
OLAP, data cube
What is canned reports? - ANSWER-provide regular summaries of information in a predetermined
format
What is ad hoc reporting tools? - ANSWER-puts users in control so that they can create custom reports
on an as-needed basis by selecting fields, ranges, summary conditions, and other parameters.
What is dashboards? - ANSWER-heads-up display of critical indicators that allows managers to get a
graphical glance at key performance metrics.
What is Online Analytical Processing (OLAP)? - ANSWER-takes data from standard relational databases,
calculates and summarizes the data, and then stres the data in a special database called a data cube.
What is a data cube? - ANSWER-special database used to store data in OLAP reporting.
What are data fields in Tableau? - ANSWER-made from the columns in your data source.
What is data type in Tableau? - ANSWER-integer, string, date.
, What is dimension in Tableau? - ANSWER-contain qualitative values (names, dates or geographical data)
use them to categorize, segment and reveal details in your data. Aggregated - minimum, maximum,
count, or count (distinct)
What is measure in Tableau? - ANSWER-contain numeric, quantitative values. Aggregated - sum,
average, and median.
What is discrete in Tableau? - ANSWER-"individually separate and distinct" mathematical terms.
What is continuous in Tableau? - ANSWER-"forming an unbroken whole, without interruption"
mathematical terms.
What is big data? - ANSWER-refers to the huge collections of data that are difficult to process, analyze,
and manage using conventional database tools.
What are the 5 V's of big data? - ANSWER-high volume, high velocity, diversified variety. unknown
veracity, and low-density value.
What is high volume? - ANSWER-the size and amounts of big data that companies manage and analyze.
What is high velocity? - ANSWER-the speed at which companies receive, store and manage data - e.g.,
the specific number of social media posts or search queries received within a day, hour or other unit of
time.
What is diversified variety? - ANSWER-the diversity and range of different data types, including
unstructured data semi-structured data and raw data
What is unknown veracity? - ANSWER-the "truth" or accuracy of data and information assets, which
often determines executive-level confidence
What is low-denisty value? - ANSWER-large volumes of data containing unimportant details. comes from
insight discovery and pattern recognition that lead to more effective operations, stronger customer
relationships and other clear and quantifiable business benefits
