Power Pivot Questions With Answers

Answer = True

QUESTION 6

In the brewery.xlsx file, which of the following is the primary index key for table2?

Product Name

Debut

Style

ProductID

ABV%

Answer = ProductID

QUESTION 7

Use the Brewery.xlsx file to answer the following question: What's the name of the product with the highest total revenue?

Black Manatee

Evil Squid

Bruin

Extended Puppy Rearview

Answer =

QUESTION 8

Use the Brewery.xlsx file to answer the following question: What's the name of the product with the lowest total cost (not unit cost, but cost of all units consumed)?

Flyin Squirrel

Mud Guard

Lotus

Former Weasel Subatomic Glove

Answer =

QUESTION 9

Use the Brewery.xlsx file to answer the following question: By revenue, what percent of Red Ales were sold in New Haven? (rounded to 2 decimals)

18.59% 57.28% 23.04% 30.00%

20.95%

Answer =

QUESTION 10

Which button in the Power Pivot Home Ribbon allows you to load data from an external excel file?

From Database

From Data Service

From Other Sources

Existing Connections None of the Above

Answer = From Other Sources

QUESTION 11

Which button in the Power Pivot Home Ribbon allows you to load data from a text file?

From Database

From Data Service

From Other Sources

Existing Connections None of the Above

Answer = From Other Sources

QUESTION 12

Using the file ImportText.txt, what is the sum of the TransPrice column?

Answer = (

CALCULATE(SUM(Trans[Price.PRICE]),ALLEXCEPT(Trans,Trans[CUSTNUM1]))

QUESTION 1

Using the following URL, determine the average yield of a Long Term Treasure Bill (LT Composite>10yrs) in 2010:

https://www.treasury.gov/resource-center/data-chart-center/interest-rates/Pages/default.aspx

Under the Resource Center, select "Daily Treasury Real Long-Term Rate Averages"

Select type of Interest Rate Data: Daily Treasury Long-Term Rates

Select Time Period: 2010

1.72

1.73

1.74

1.75

1.76

Answer = 172

QUESTION 2

Using the following URL, determine the total number of rushing yards (RUSH) across all NFL teams in 2013 https://www.espn.com/nfl/stats/team/_/season/2013/seasontype/2

56360

56581

56711

57064

57795

Answer = 57795

QUESTION 3

Using the following URL of https://finance.yahoo.com/quote/GOOG/history?p=GOOG , determine the difference between the average weekly high and low for shares of Google in 2019 . Use the following parameters:

Time Period: Dec 31, 2018 - Dec 30, 2019

Show: Historical Prices

Frequency: Weekly

(Round the answer to 2 decimal places.)

Answer = 59201.86

QUESTION 4

Use the Brewery.xlsx file to answer the following question: What percentage of profit does Lager account for among the three types of beer? (rounded to 2 decimals)

26.13% 52.00% 25.68% 14.25%

13.76%

Answer =

QUESTION 5

Use the Brewery.xlsx file to answer the following question: Which type of beer accounts for the most total profit?

Cider

Lager

Ale

IPA

Pilsner

Answer =

QUESTION 6

Use the Brewery.xlsx file to answer the following question: What's the difference between profit in MA and Profit in CT?

520000

368592.12

145236.26

"397,853.60" 589463.22

Answer =

QUESTION 7

Which section of the Power View interface allows you to add and configure the data for your dashboard?

Canvas

Filter Pane

Field List

Design Data

Answer = Canvas

QUESTION 8

Which tab of the Power View interface is used to create column charts?

Insert

Formulas

View

Design Canvas

Answer = View

QUESTION 9

The Insert tab is the only tab in which we can install the Power View add-in.

True

False

Answer = True

QUESTION 1

When importing an Excel workbook into Power BI, the Power BI file created from the workbook has no dependence on the original workbook line

True

False

Answer = True

QUESTION 2

Power BI mobile is a cloud-based business analytics service that allows the user to host and share their own data, reports, and dashboards online

True

False

Answer = True

QUESTION 3

Which of the following actions cannot be performed in the Data Source Settings window?

Managing Security Credentials

Deleting Data Sources

Changing Server/Database names

Change Data Source

Answer = Changing Server/Database names

QUESTION 4

If Power BI doesn't recognize a data type, the columns containing the data type will be imported as text. .

True

False

Answer = False

QUESTION 5

When working with data in the Query Editor, the underlying data is edited to reflect the steps recorded in the Applied Steps section.

True

False

Answer = True

QUESTION 6

Given the Query Data Type, which of the following is incorrectly matched with the corresponding Storage Data Type?

Text : String

TRUE/FALSE : Boolean

Date : Date Duration : Time

Answer = Duration : Time

QUESTION 7

If the user wishes to change more than one column data type at once, the SHIFT key can be used to select non-adjacent columns.

True

False

Answer = False

QUESTION 8

Appending is used when there are additional rows of data that need to be added to an existing query.

True

False

Answer = True

QUESTION 9

Which of the following is NOT a process for shaping data?

Changing Data Types

Removing Rows

Merging Queries Renaming Tables

Answer = Renaming Tables

QUESTION 10

An implicit measure is used when an aggregation behavior is needed that goes beyond a standard aggregation function created by Microsoft.

True

False

Answer = True

QUESTION 11

Measures are calculated at run time.

True

False

Answer = True

QUESTION 12

Explicit measures become a part of the report.

True

False

Answer = True

QUESTION 13

DAX does not allow the usage of aggregate functions on entire tables.

True

False

Answer = True

QUESTION 14

DAX can take the place of using a VLOOKUP by referencing a named table/column.

True

False

Answer = True

QUESTION 15

What operator would you use if you wanted to create an [OR] statement using DAX?

&&

||

<=

>=

Answer = ||

QUESTION 1

In order for Power BI to detect relationships between two columns, the columns must have matching data type

True

False

Answer = True

QUESTION 2

Within the Relationship View, the number (1) denotes the table on the One side of the relationship.

True

False

Answer = True

QUESTION 3

Which of the following is a supported operation for the Relationship object?

Hide

Rename

Maximize Delete

Answer = Maximize

QUESTION 4

Which is an example of a Parent-Child relationship?

"A list of transactions, each of which takes place at a specific time and place"

"A company with multiple offices, which in turn have multiple branches"

"A list of raw materials, each of which are used to assemble various goods" "A list of services, each of which are available from various companies"

Answer = "A company with multiple offices, which in turn have multiple branches"

QUESTION 5

.

Which of the following is NOT an advanced relationship?

.

Role-playing

Parent-Child

Many-to-

Many One-to-One

.

Answer = Role-playing

QUESTION 6

What types of cross-filter direction are supported by Power BI?

Single

Single and Both

Both Neither

Answer = Both

QUESTION 7

Which of the options can NOT be changed in the Visualizations toolbar?

Axis Title

Calculated Column

Graph Color Data Labels

Answer = Graph Color

QUESTION 8

When using tiles, which view will allow you to change tile settings?

In Focus Mode

Tile Details

Delete Tile Pin Visual

Answer = Tile Details

QUESTION 9

To show a line graph and a bar chart what kind of visualization should you create?

Scatter Chart

Matrix Visualization

Combination Chart Slicer

Answer = Scatter Chart

QUESTION 1

A table contains five columns (CustomerID, CustomerName, Address, City, Country). Which one is most likely to be the primary key of this table?

CustomerName

Address

CustomerId City

Answer = CustomerId

QUESTION 2

SQL Tables invariably have a column that stores unique column data, it is called:

Key

Value

Order Relationship

Answer = Key

QUESTION 3

Which of the following statement is incorrect?

SQL lets you access and manipulate databases

SQL commands allow us to update the data but cannot change the structure of the stored data.

SQL can answer questions like Who is the top performing salesperson this year? SQL can create insightful information for businesses.

Answer =

QUESTION 4

Which of the following is an example of IDE

Visual Studios

NetBeans

Eclipse

All the above

Answer = All the above

QUESTION 5

What can you do in the users' interface of Visual Studio 2017?

Answer = B

QUESTION 6

To view data in a table, you should right click table name and click "open table definition" in visual studio 2017.

True

False

Answer = True

QUESTION 7

What will happen if you do not use the Where clause in an update expression?

It has an error and the table cannot update

All records in the table will be updated

The table updated by Set of columns and values None of the above

Answer = None of the above

QUESTION 8

.

With SQL, how do you select all the columns from a table named "Customers"?

.

SELECT * FROM Customers;

SELECT Customers;

SELECT * AT Customers; SELECT [all] FROM Customers;

.

Answer = SELECT * FROM Customers

QUESTION 9

Which of the following statements might delete all records of customers whose first name is Jack from a table named Customer?

DELETE FROM Customer WHERE firstname = 'Jack' ;

DELETE Jack FROM Customer;

DELETE FROM Jack of Customer;

DELETE Customer WHERE first name = 'Jack' ;

Answer = DELETE Customer WHERE first name = 'Jack' ;

QUESTION 10

True or False: The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true.

True

False

Answer = True

QUESTION 11

In SQL, how might you select all the records from a table named "Customers" where the "LastName" is alphabetically between (and including) "Jones" and "Thomas"?

SELECT LastName>'Jones' AND LastName<'Thomas' FROM Customers;

SELECT * FROM Customers WHICH LastName>'Jones' OR LastName<'Thomas';

SELECT * FROM Customers WHERE LastName BETWEEN 'Jones' AND 'Thomas';

None of the above

Answer = SELECT * FROM Customers WHERE LastName BETWEEN 'Jones' AND 'Thomas';

QUESTION 12

With SQL, how do you select all the records from a table named "Customers" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Customers WHERE FirstName='%a%';

SELECT * FROM Customers WHERE FirstName='a';

SELECT * FROM Customers WHERE FirstName LIKE 'a%';

SELECT * FROM Customers WHERE FirstName LIKE '%a';

Answer = SELECT * FROM Customers WHERE FirstName LIKE 'a%';

QUESTION 13

A FULL JOIN is the same as an INNER JOIN.

True

False

Answer = False

QUESTION 14

What does a Join do?

Removes joined tables

Removes one of the tables and splits it to the other

Creates new database

Creates a temporary table with data from both joined table

Answer = Creates a temporary table with data from both joined table

QUESTION 15

There are two tables below:

How many rows should be in the outcome by using the SQL statement below:

SELECT a.Customer_ID, a.Name, b.Age

FROM Customer_name a LEFT JOIN Customer_age b

ON a.Customer_ID= b.Customer_ID;

1

2

3

0

Answer = 3

QUESTION 16

TRUNCATE TABLE is the same as DROP TABLE.

True

False

Answer = False

QUESTION 17

. Which is the correct format to create table?

"CREATE Customer TABLE (Customer_id Number, Customer_name Varchar(25), Birthday);" "CREATE TABLE Customer (Customer_id Number, Customer_name Varchar(25), Birthday);"

"CREATE TABLE (Customer_id Number, Customer_name Varchar(25), Birthday) INTO Customer;"

"CREATE Customer TABLES (Customer_id Number, Customer_name Varchar(25), Birthday);"

Answer = "CREATE TABLE Customer (Customer_id Number, Customer_name Varchar(25), Birthday);"

QUESTION 18

What is the SQL statement for removing a column named 'age' from a table named 'Customer'?

UPDATE TABLE Customer DROP COLUMN age;

ALTER TABLE Customer DELETE COLUMN age;

ALTER TABLE Customer DROP COLUMN age;

ALTER TABLE age DELETE COLUMN Customer;

Answer = ALTER TABLE Customer DROP COLUMN age;