Exam 4: Business Intelligence Bifor Data Analysis

Microsoft Access is an example of a relational database management system.

Power Pivot is needed to create a Data Model.

Which of the following is true of a measure in Power Pivot?

It is best to store the data just once and the _____ is often the better choice.

A popular software package for creating imaginative types of visualization techniques is

There are four basic steps for all data imports.Which of the following gives these steps in the correct order?

Suppose a Products table has a ProductID primary key,and a related Sales table has a ProductID foreign key.Which of the following would cause a concern?

Which of the following is not true of the Power Pivot user interface?

It is reasonable to assume that the data you obtain are clean.

One way to create a unique identifier for every element in a data table is to use an existing unique identifier,such as a social security number.

Business intelligence refers to the insights gained from data analysis.

Primary and foreign keys relate information between tables making it possible to look up information about all orders made by a specific customer for a specific product.

Suppose you try to create a pivot table from multiple tables stored in a Data Model and,when you check a particular field to be placed in the pivot table,you get a warning about a missing relationship.Which of the following does this not imply?

The flexibility of the measures created by _____ is the real "power" in Power Pivot.

The pivot table functionality that has been part of Excel for decades is great,but has its limits.With _____ and _____,these limits are expanded significantly.

In terms of importing data from a website,which of the following is not true?

When there is a many-to-many relationship,it is common to have a linking table.A good example is between musicians and record albums,where any musician can record multiple albums,and any record album can be created by multiple musicians.In this case,what would be true of the linking table?

Which of the following most accurately explains Excel's Data Model and Power Pivot (in Excel 2016 or later versions)?

Excel Data Model is a recent Microsoft technology used for data visualization,all within Excel.

A hospital has a database for which all patient visits are logged.For each visit,the hospital records information such as the patient's name,age,address,reason for the visit,the date,the doctor's diagnosis,etc.The relationship between the patient table and the visits table is called a _____ relationship.