Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Second attempt PL-300 > 2. Prepare data for analysis in power BI > Flashcards

2. Prepare data for analysis in power BI Flashcards

1
Q

Native query relies on query folding?

Yes
No

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

By default data preview analyzes 5000 in the data state

  1. True
  2. False
A
  1. flase its 1000
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q
  1. Merge -Combine two tables with a similar column
  2. Append / Combine two tables with the same schema
  3. 1 true true
    1. false 2 false
A
  1. true 2. true
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is data profiling (in power Query M function) that gives you a table and gives all of those columns and date profiling info of those columns

1.new query
2. table.profile
3. columm quality
4. column distribution

A
  1. table profile
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

You should use grouping with the list type to combine distinct categories of data or list of categories into larger categories

True or False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Bining is similar to grouping, but it is used to grouping to continous fields such numbers and dates

True or false

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Left Outer Join: All rows from the right table, matching rows from the right table.
Right Outer Join: All rows from the left table, matching rows from the right table

Yes or not

A

No

Left Outer Join: All rows from the left table, matching rows from the right table.
Right Outer Join: All rows from the right table, matching rows from the left table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Full Outer Join: All rows from left tables
Inner Join: Only matching rows from right tables.

Yes or not

A

no

Full Outer Join: All rows from both tables
Inner Join: Only matching rows from both tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Left Anti Join: Only rows from the left table.
Right Anti Join: Only rows from the right table

Yes or not

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

You have a Microsoft Power BI report that connects to a SQL Server database. The report is experiencing slow performance when loading data from a specific table that contains millions of rows. What should you do to improve the performance of the report

Create a summary table or aggregate the data in the SQL Server database to reduce the number of rows accessed by the report.

Yes or not

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A company wants to analyze customer data stored in a Microsoft Excel workbook using Power BI. The workbook is regularly updated with new data, and they want to ensure that the Power BI report reflects the latest information without manual intervention.

Use Power Query Editor to connect to the Excel workbook and set up scheduled data refresh in Power BI.

Yes or not

A

Not

Convert the Excel workbook into a Power BI dataset and set up scheduled refresh in the Power BI service

That is the correct one

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

You have a SharePoint document library that contains Excel workbooks. The workbooks are updated daily with new data. You want to automate the process of importing the data from the Excel workbooks into Power BI. What should you do to achieve this?

Use Power Query to connect to the SharePoint document library and set up scheduled data refresh in Power BI.

Yes or not

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

You have a SharePoint document library that contains Excel workbooks. The workbooks are updated daily with new data. You want to automate the process of importing the data from the Excel workbooks into Power BI. What should you do to achieve this?

Use Power Query to connect to the SharePoint document library and set up scheduled data refresh in Power BI.

Yes or not

A

Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Column quality labels comes in this categories….which does not belong to the list

Valid
Error
Unknown
Missing
Unexpected error

A

Missing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Which feature doesn’t belong to column distribution

A

Unique
Distinct
Several

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Group by value; filter by value, copy data are part of column profile or column distribution

A

Column profile

17
Q

You are modelling the data with the help of Microsoft Power BI. The data model consists of a large Microsoft SQL Server table titled Transactions with records higher than 120 million.
During the development phase, it is required to import a sample of data from the Transactions table.
You decide to write a DAX expression that utilizes a filter function. Will this help you in achieving the goal?

Yes or not

A

not

As the Filter is applied after the data is imported, it won’t help in importing a sample of data from the table. Instead, adding a WHERE clause to the SQL statement could be the right solution

18
Q

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?

A. Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.
B. Change the data type of the Logged column to Date.
C. Split the Logged column by using at as the delimiter.
D. Apply a transformation to extract the first 11 characters of the Logged column.

A

A

19
Q

You need to create a data source that can be used offline. Which type of data source should you use?

1SQL Server
2Common Data Service
3 SharePoint
4 OneDrive

A

4

20
Q

You want to create a data source that can be accessed by external users. Which type of data source should you use?

SQL Server
Common Data Service
SharePoint
OneDrive

A

Common Data Service

21
Q

You want to create a custom connector to access data from a third-party API. Which tool should you use?

Power BI
Power Automate
Power Apps
Power Query

A

Power Query

22
Q

You want to create a data source that can be used by Power BI. Which type of data source should you use?

  1. SQL Server
  2. Common Data Service
  3. SharePoint
  4. OneDrive
A

1

23
Q

How can you create a custom data connector in Power BI?

Use the Power Query SDK
Use the Power BI API
Use the Power BI Embedded SDK
Use the Power BI Mobile app

A

Use the Power Query SDK

24
Q

You want to create a data source that can be used by multiple Power Apps. Which type of data source should you use?

SQL Server
Common Data Service
SharePoint
OneDrive

A

Common Data Service

25
Q

What is the best way to manage data sources in Power BI?

A. Use a single data source for all reports
B. Use a separate data source for each report
C. Use a data gateway to connect to on-premises data sources
D. Use a cloud-based data source for all reports

A

C. Use a data gateway to connect to on-premises data sources

Using a data gateway to connect to on-premises data sources is the best option as it allows for secure and efficient access to on-premises data sources without the need for data duplication.

26
Q

In order to use the Power BI web part in SharePoint Online, the report author as well as all the report consumers require a Power BI Pro license.
Is this statement true ?

TRUE
FALSE

A

True

All Sharepoint report viewers must have Power BI pro license

27
Q

Which of the following types of real-time data set in Power BI always store their data in Azure SQL Database? Select two

Streaming Datasets
Push Datasets
Hybrid Datasets

A

Push Datasets
Hybrid Datasets

28
Q

The Column profile view shows a column distribution chart of values as well as the minimum and maximum values. You can quickly see if your data has negative values by checking the distribution or by viewing the minimum value.

Yes or not

A

Yes

Second attempt PL-300 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions