Question 1

Which is true of an Excel Data Model?

Accepted Answer

A) It must consist of at least two related tables. 
B) The data do not need to be stored in one or more Excel worksheets. 
C) The data must first be imported into Excel from an RDBMS,either Access or SQL Server. 
D) The data will always appear in two places: in one or more Excel worksheets and in the Power Pivot window. 
A) It must consist of at least two related tables. 
B) The data do not need to be stored in one or more Excel worksheets. 
C) The data must first be imported into Excel from an RDBMS,either Access or SQL Server. 
D) The data will always appear in two places: in one or more Excel worksheets and in the Power Pivot window.

Question 2

Which of the following is the feature that sets Power Pivot apart from regular Excel pivot tables?

Accepted Answer

A) Power Pivot Alchemy 
B) Data Model language 
C) DAX language 
D) SQL 
A) Power Pivot Alchemy 
B) Data Model language 
C) DAX language 
D) SQL

Question 3

Which of the following is not a primary advantage of Microsoft's self-service BI tools?

Accepted Answer

A) They allow ordinary Excel users to perform powerful data analysis without needing help from a corporate IT department. 
B) The tools let you analyze the data in Excel.However,you must first create a relational database in a database package such as Access. 
C) To analyze large relatable tables in Excel,the usual practice of employing multiple VLOOKUP functions is no longer required. 
D) These tools allow you to analyze data sets in Excel that go well beyond Excel's approximately one million row limit. 
A) They allow ordinary Excel users to perform powerful data analysis without needing help from a corporate IT department. 
B) The tools let you analyze the data in Excel.However,you must first create a relational database in a database package such as Access. 
C) To analyze large relatable tables in Excel,the usual practice of employing multiple VLOOKUP functions is no longer required. 
D) These tools allow you to analyze data sets in Excel that go well beyond Excel's approximately one million row limit.

Question 4

Which of the following is true of Power Query?

Accepted Answer

A) Power Query is just another name for the querying tools Excel has had for over two decades. 
B) Power Query is an add-in,so it must first be checked in the Excel add-ins list. 
C) Even with Power Query,a user must be good at the SQL querying language to import data from relational databases. 
D) Power Query remembers the steps of your queries so that you can use or easily modify these queries for later uses. 
A) Power Query is just another name for the querying tools Excel has had for over two decades. 
B) Power Query is an add-in,so it must first be checked in the Excel add-ins list. 
C) Even with Power Query,a user must be good at the SQL querying language to import data from relational databases. 
D) Power Query remembers the steps of your queries so that you can use or easily modify these queries for later uses.

Question 5

Tableau Public refers to worksheets (or simply sheets).Which of the following is true?

Accepted Answer

A) Each sheet contains data from a particular data table. 
B) Each sheet contains a geographic map. 
C) Each sheet contains a single chart. 
D) Each sheet contains a single dashboard. 
A) Each sheet contains data from a particular data table. 
B) Each sheet contains a geographic map. 
C) Each sheet contains a single chart. 
D) Each sheet contains a single dashboard.

Question 6

Which of the following is true of Power Pivot?

Accepted Answer

A) If you don't have a Data Model in your Excel file,you won't see any data in the Power Pivot window. 
B) The data you see in the Power Pivot window can be a mix of data in the Data Model and data not in the Data Model. 
C) The tables you see in the Power Pivot window have necessarily been related through their primary and foreign keys; otherwise,the tables wouldn't appear in the Power Pivot window. 
D) The only way to relate tables that have not yet been related is through the Power Pivot window; Excel has no buttons on it ribbons to create relationships. 
A) If you don't have a Data Model in your Excel file,you won't see any data in the Power Pivot window. 
B) The data you see in the Power Pivot window can be a mix of data in the Data Model and data not in the Data Model. 
C) The tables you see in the Power Pivot window have necessarily been related through their primary and foreign keys; otherwise,the tables wouldn't appear in the Power Pivot window. 
D) The only way to relate tables that have not yet been related is through the Power Pivot window; Excel has no buttons on it ribbons to create relationships.

Question 7

Data visualization

Accepted Answer

A) is the study of making graphical displays more simplistic by removing labels and scales. 
B) shows data graphically only using traditional graphs like histograms,scatterplots,and bar graphs. 
C) shows data graphically in new and imaginative ways. 
D) is the study of organizing data into linked tables using spreadsheets. 
A) is the study of making graphical displays more simplistic by removing labels and scales. 
B) shows data graphically only using traditional graphs like histograms,scatterplots,and bar graphs. 
C) shows data graphically in new and imaginative ways. 
D) is the study of organizing data into linked tables using spreadsheets.

Question 8

The whole purpose of separating data into separate tables in a relational database is to

Accepted Answer

A) provide the data in a format that can be analyzed using Excel. 
B) enable the data to be cleansed. 
C) simplify the process of importing data. 
D) avoid redundancy. 
A) provide the data in a format that can be analyzed using Excel. 
B) enable the data to be cleansed. 
C) simplify the process of importing data. 
D) avoid redundancy.

Question 9

Which of the following is true of the DAX language?

Accepted Answer

A) If Revenue and Cost are fields in the Sales table of a Data Model,the DAX expression Profit:=Sales[Revenue]-Sales[Cost] can be used to create a new calculated column called Profit. 
B) If Revenue and Cost are fields in the Sales table of a Data Model,the DAX expression Profit:=Sales[Revenue]-Sales[Cost] can be used to create a new measure called Profit. 
C) It is easy to learn and master the DAX language because its functions are practically the same as Excel's built-in functions. 
D) A measure created by DAX does not need to be a summarization. 
A) If Revenue and Cost are fields in the Sales table of a Data Model,the DAX expression Profit:=Sales[Revenue]-Sales[Cost] can be used to create a new calculated column called Profit. 
B) If Revenue and Cost are fields in the Sales table of a Data Model,the DAX expression Profit:=Sales[Revenue]-Sales[Cost] can be used to create a new measure called Profit. 
C) It is easy to learn and master the DAX language because its functions are practically the same as Excel's built-in functions. 
D) A measure created by DAX does not need to be a summarization.

Question 10

Using Tableau Public you can combine charts into a dashboard or a story.

Accepted Answer

A) True 
 B)False

Question 11

Within the Power Pivot window,you can choose to hide individual columns or even entire tables.Why might you want to do this?

Accepted Answer

A) It prevents users from adding fields to pivot tables that would certainly lead to errors. 
B) It creates less confusion for users,so that they won't be tempted to use fields in pivot tables that wouldn't lead to interesting results. 
C) It ensures that fields unrelated to other fields won't be used in pivot tables. 
D) Its only use is to hide primary and foreign key fields so that they won't be used in pivot tables. 
A) It prevents users from adding fields to pivot tables that would certainly lead to errors. 
B) It creates less confusion for users,so that they won't be tempted to use fields in pivot tables that wouldn't lead to interesting results. 
C) It ensures that fields unrelated to other fields won't be used in pivot tables. 
D) Its only use is to hide primary and foreign key fields so that they won't be used in pivot tables.

Question 12

Which of the following is not a many-to-many relationship?

Accepted Answer

A) Between authors and single-authored books. 
B) Between the products a company stocks and the orders from the company's customers. 
C) Between college students and sections of college courses. 
D) Between the products a company stocks and the vendors who supply the products to the company. 
A) Between authors and single-authored books. 
B) Between the products a company stocks and the orders from the company's customers. 
C) Between college students and sections of college courses. 
D) Between the products a company stocks and the vendors who supply the products to the company.

Question 13

A foreign key is not a unique identifier.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following languages are used to create queries?

Accepted Answer

A) SQL and DAX 
B) SQL,M,and DAX 
C) M and DAX 
D) SQL and M 
A) SQL and DAX 
B) SQL,M,and DAX 
C) M and DAX 
D) SQL and M

Question 15

A field in a database table that serves as a unique identifier is called an autonumber key.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following is true of a relational database with several related tables?

Accepted Answer

A) A primary key value such as 16 in one table can be associated with several records in a related table,each with the foreign key value of 16. 
B) A foreign key value such as 16 in one table can be associated with several records in a related table,each with the primary key value of 16. 
C) If one table has a primary key value of 16,then another table must have multiple records with foreign key value 16. 
D) If one table has a primary key value of 16,then only one other table can have records with foreign key value 16. 
A) A primary key value such as 16 in one table can be associated with several records in a related table,each with the foreign key value of 16. 
B) A foreign key value such as 16 in one table can be associated with several records in a related table,each with the primary key value of 16. 
C) If one table has a primary key value of 16,then another table must have multiple records with foreign key value 16. 
D) If one table has a primary key value of 16,then only one other table can have records with foreign key value 16.

Question 17

Which of the following is not true of a hierarchy in an Excel Data Model?

Accepted Answer

A) Only one hierarchy per table is allowed.For example,it wouldn't be possible to create the hierarchy Continent,Country,Region,City and the hierarchy Continent,Country,State/Province,City,Zip based on a Geography table. 
B) A hierarchy must be created in the Power Pivot window. 
C) A hierarchy is often aided by DAX's RELATED function,so that fields from related tables can be brought into a single table and used in building the hierarchy. 
D) A hierarchy's main use is to allow users to drill down through the hierarchy in a pivot table. 
A) Only one hierarchy per table is allowed.For example,it wouldn't be possible to create the hierarchy Continent,Country,Region,City and the hierarchy Continent,Country,State/Province,City,Zip based on a Geography table. 
B) A hierarchy must be created in the Power Pivot window. 
C) A hierarchy is often aided by DAX's RELATED function,so that fields from related tables can be brought into a single table and used in building the hierarchy. 
D) A hierarchy's main use is to allow users to drill down through the hierarchy in a pivot table.

Question 18

You can try to import data from a Web page into Excel using the From Web button.Using Power Query,_____ Web queries will succeed.

Accepted Answer

A) no 
B) some 
C) all 
D) half of all 
A) no 
B) some 
C) all 
D) half of all

Question 19

Tableau Public is a power Excel add-in that provides many data visualization options.

Accepted Answer

A) True 
 B)False

Question 20

Most Data Models will include a separate Dates table with the purpose of

Accepted Answer

A) enhancing the readability of the Data Model. 
B) streamlining the query process. 
C) listing all possible dates in many possible ways. 
D) storing the data in separate worksheets for easy access. 
A) enhancing the readability of the Data Model. 
B) streamlining the query process. 
C) listing all possible dates in many possible ways. 
D) storing the data in separate worksheets for easy access.

Which is true of an Excel Data Model?

Which of the following is the feature that sets Power Pivot apart from regular Excel pivot tables?

Which of the following is not a primary advantage of Microsoft's self-service BI tools?

Which of the following is true of Power Query?

Tableau Public refers to worksheets (or simply sheets).Which of the following is true?

Which of the following is true of Power Pivot?

Data visualization

The whole purpose of separating data into separate tables in a relational database is to

Which of the following is true of the DAX language?

Using Tableau Public you can combine charts into a dashboard or a story.

Within the Power Pivot window,you can choose to hide individual columns or even entire tables.Why might you want to do this?

Which of the following is not a many-to-many relationship?

A foreign key is not a unique identifier.

Which of the following languages are used to create queries?

A field in a database table that serves as a unique identifier is called an autonumber key.

Which of the following is true of a relational database with several related tables?

Which of the following is not true of a hierarchy in an Excel Data Model?

You can try to import data from a Web page into Excel using the From Web button.Using Power Query,_____ Web queries will succeed.

Tableau Public is a power Excel add-in that provides many data visualization options.

Most Data Models will include a separate Dates table with the purpose of

Introduction to Business Analytics

Describing the Distribution of a Variable

Finding Relationships Among Variables

Probability and Probability Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Analysis of Variance and Experimental Design

Statistical Process Control

Filters

Exam 4: Business Intelligence Bifor Data Analysis

Which is true of an Excel Data Model?

Which of the following is the feature that sets Power Pivot apart from regular Excel pivot tables?

Which of the following is not a primary advantage of Microsoft's self-service BI tools?

Which of the following is true of Power Query?

Tableau Public refers to worksheets (or simply sheets).Which of the following is true?

Which of the following is true of Power Pivot?

Data visualization

The whole purpose of separating data into separate tables in a relational database is to

Which of the following is true of the DAX language?

Using Tableau Public you can combine charts into a dashboard or a story.

Within the Power Pivot window,you can choose to hide individual columns or even entire tables.Why might you want to do this?

Which of the following is not a many-to-many relationship?

A foreign key is not a unique identifier.

Which of the following languages are used to create queries?

A field in a database table that serves as a unique identifier is called an autonumber key.

Which of the following is true of a relational database with several related tables?

Which of the following is not true of a hierarchy in an Excel Data Model?

You can try to import data from a Web page into Excel using the From Web button.Using Power Query,_____ Web queries will succeed.

Tableau Public is a power Excel add-in that provides many data visualization options.

Most Data Models will include a separate Dates table with the purpose of

Introduction to Business Analytics

Describing the Distribution of a Variable

Finding Relationships Among Variables

Probability and Probability Distributions

Decision Making Under Uncertainty

Sampling and Sampling Distributions

Confidence Interval Estimation

Hypothesis Testing

Regression Analysis: Estimating Relationships

Regression Analysis: Statistical Inference

Time Series Analysis and Forecasting

Introduction to Optimization Modeling

Optimization Models

Introduction to Simulation Modeling

Simulation Models

Data Mining

Analysis of Variance and Experimental Design

Statistical Process Control

Filters