You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

Set Data Connectivity mode to DirectQuery.

Set the Command timeout in minutes setting.

Set Data Connectivity mode to Import.

What is the Query Editor used for?

To shape & transform data, then load it into Power BI

As a cloud-based storage option for your organization's data

To create relationships between data and lookup tables

To create measures & calculated columns using DAX

When should you use DirectQuery?

Dataset is too large to be stored in-memory

Company policy states no data source restrictions

When would you need to access the Data Source Settings?

If the file name or location changes

If you need to connect to a new data source

If you need to edit an existing query

How can you use parameters when connecting to data?

To change data source values dynamically

To shape and transform data in the Query Editor

You have a Microsoft Excel spreadsheet that contains a table named Sales. You need to add the Sales table to a Power BI dashboard as a tile. How should you configure the tile?

From the Power BI tab in Excel, pin the table.

From the Power BI service, import the data from the Excel workbook.

From Excel, publish the workbook to the Power BI service.

From the Power BI service, upload the Excel workbook.

You have two Microsoft SQL Server database servers named SQLProd and SQLDev. SQLDev contains the same tables as SQLProd, but only a subset of the data in SQLProd. You create a new Power BI Desktop model that uses 120 tables from SQLDev. You plan to publish the Power BI file to the Power BI service. You need to connect the model to the tables in SQLProd. The solution must minimize administrative effort. What should you do from Query Editor before you publish the model?

Configure the Data source settings.

Create a new connection to SQLProd, and then import the tables from SQLProd.

Delete the existing queries, and then add new data sources.

Edit the source of each table query.

Your company has several developers who plan to create custom solutions that will interact with the API for the Power BI service. Which three operations can the developers achieve by using the API?

Add a member to a row-level security role

In Power BI Desktop, you are updating an existing report that connects to a Microsoft SQL Server database. You use database (SQL authentication) credentials to connect to the source. The last credentials that were entered are expired. You need to update the credentials. Which two actions should you perform?

Open the Data Source Settings dialog box and locate the data source.

Select Edit Permissions and enter new credentials.

Open the Get Data dialog box and make a new connection to the database.

Open the Options dialog box and allow data previews to download in the background.

What are the building blocks of Power BI?

Datasets, Visualizations, Reports, Dashboards, and Tiles

Tiles, dashboards, databases, mobile devices

Visual Studio, C#, and JSON files

What is the common flow of activity in Power BI?

Bring data into Power BI Desktop and create a report, share it to the Power BI service, view and interact with reports and dashboards

Bring data into Power BI mobile, create a report, then share it to Power BI Desktop.

Create a report in the Power BI service, share it to Power BI mobile, interact with it in Power BI Desktop.

Create a report in Power BI mobile, share it to the Power BI Desktop, view and interact in the Power BI service.

What can be achieved by removing unnecessary rows and columns?

Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.

It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.

Deleting unnecessary rows and columns can damage the structure of the data model.

Data profiling is defined as what?

Studying the nuances of the data

Aggregating columns containing numeric data

What is the risk of having null values in a numeric column?

DAX expressions that AVERAGE data will be incorrect

DAX expressions that MAX data will be incorrect

DAX expressions that SUM data will be incorrect

What is not a best practice for naming conventions in Power BI?

Rename columns to have spaces in them

Replace values that have integers with human readable results

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields: First name, Last name, Email address, State/Region, Phone number. You import the list into Power Query Editor. You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign. Which two actions should you perform?

Enable Column profiling based on entire dataset.

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59. You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy. What should you do?

Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date.

Change the data type of the Logged column to Date.

Apply the Parse function from the Date transformations options to the Logged column.

Apply a transform to extract the first 11 characters of the Logged column.

You have a Microsoft SharePoint Online site that contain several document libraries. One of the document libraries contains manufacturing reports saved as Microsoft Excel files. All the manufacturing reports have the same data structure. You need to use Power BI Desktop to load only the manufacturing reports to a table for analysis. What should you do?

Get data from a SharePoint Online folder and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

Get data from a SharePoint Online folder, enter the site URL, and then select Combine & Load.

Get data from a SharePoint Online list and enter the site URL. Select Combine & Transform, then filter by the folder path to the manufacturing reports library.

Get data from a SharePoint Online list, enter the site URL, and then select Combine & Load.

Which data profiling tools does Power Query have?

Column quality, distribution, and profile

Column from examples, custom column, and conditional column

Index column and duplicate column

Which data profiling tool can you use to check the number of errors in a column?

Column quality & column profile

What is the purpose of data profiling in Power Query?

Provide a visual way to explore data

Get a sense of your dataset composition

When would you use a tool from the Transform tab over the Add Column tab?

When you want to overwrite the values of existing columns

When you want to keep the values of existing columns

When you want to create new columns

PBI Quiz 1

Authored by Harvey Nguyen

English

University

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

79 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which query language do you use to extract data from Microsoft SQL Server?

DAX

T-SQL

MDX

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You're creating a Power BI report with data from an Azure Analysis Services Cube.
When the data refreshes in the cube, you would like to see it immediately in the Power BI report.
How should you connect?

Connect Live

Import

Direct Query

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What can you do to improve performance when you are getting data in Power BI?

Only pull data into the Power BI service, not Power BI Desktop

Use the Select SQL statement in your SQL queries when you are pulling data from a relational database

Combine date and time columns into a single column

Do some calculations in the original data source

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which storage mode leaves the data at the data source?

Import

Direct Query

Dual

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which technology improves performance by generating a single query statement to retrieve and transform source data?

Query folding

Adding index columns

Adding custom columns with complex logic

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What type of import error might leave a column blank?

Keep errors

Unpivot columns

Data type error

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have the following three versions of an Azure SQL database: Test, Production, Development.
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?

Create a JSON file that contains the database server names. Import the JSON file to the dataset

Create a parameter and update the queries to use the parameter.

Create a query for each database server and hide the development tables.

Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

74 questions

E8 - Unit 10 - Communication in the future

Quiz

•

8th Grade - University

80 questions

UNIT 1 - PEOPLE and PRIVATE LIFE

Quiz

•

8th Grade - University

75 questions

5th Grade Definitions and Conventions Review

Quiz

•

5th Grade - University

74 questions

Manifest Destiny & American Progress

Quiz

•

12th Grade - University

80 questions

Greek/Latin Stems

Quiz

•

5th Grade - University

76 questions

Vocabulary Review

Quiz

•

2nd Grade - University

80 questions

English Mid-Year Exam

Quiz

•

6th Grade - University

77 questions

Clothes and fashion

Quiz

•

5th Grade - University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for English

12 questions

IREAD Week 4 - Review

Quiz

•

3rd Grade - University

20 questions

Implicit vs. Explicit

Quiz

•

6th Grade - University

18 questions

The Basic Parts of an Essay

Quiz

•

9th Grade - University

PBI Quiz 1

Which query language do you use to extract data from Microsoft SQL Server?

You're creating a Power BI report with data from an Azure Analysis Services Cube.
When the data refreshes in the cube, you would like to see it immediately in the Power BI report.
How should you connect?

What can you do to improve performance when you are getting data in Power BI?

Which storage mode leaves the data at the data source?

Which technology improves performance by generating a single query statement to retrieve and transform source data?

What type of import error might leave a column blank?

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

Which of the following sources lets users connect to a set of pre-wired connections?

You plan to publish your SSAS Tabular (live connection) data model to Power BI Service.
What must be used in order for this to be possible?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for English

PBI Quiz 1

Which query language do you use to extract data from Microsoft SQL Server?

You're creating a Power BI report with data from an Azure Analysis Services Cube. When the data refreshes in the cube, you would like to see it immediately in the Power BI report. How should you connect?

What can you do to improve performance when you are getting data in Power BI?

Which storage mode leaves the data at the data source?

Which technology improves performance by generating a single query statement to retrieve and transform source data?

What type of import error might leave a column blank?

You have an Azure SQL database that contains sales transactions. The database is updated frequently. You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update. How should you configure the data connection?

Which of the following sources lets users connect to a set of pre-wired connections?

You plan to publish your SSAS Tabular (live connection) data model to Power BI Service. What must be used in order for this to be possible?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for English

You're creating a Power BI report with data from an Azure Analysis Services Cube.
When the data refreshes in the cube, you would like to see it immediately in the Power BI report.
How should you connect?

You plan to publish your SSAS Tabular (live connection) data model to Power BI Service.
What must be used in order for this to be possible?