2. Prepare data for analysis in power BI Flashcards
Native query relies on query folding?
Yes
No
Yes
By default data preview analyzes 5000 in the data state
- True
- False
- flase its 1000
- Merge -Combine two tables with a similar column
- Append / Combine two tables with the same schema
- 1 true true
- false 2 false
- true 2. true
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
- table profile
You should use grouping with the list type to combine distinct categories of data or list of categories into larger categories
True or False
True
Bining is similar to grouping, but it is used to grouping to continous fields such numbers and dates
True or false
True
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
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
Full Outer Join: All rows from left tables
Inner Join: Only matching rows from right tables.
Yes or not
no
Full Outer Join: All rows from both tables
Inner Join: Only matching rows from both tables.
Left Anti Join: Only rows from the left table.
Right Anti Join: Only rows from the right table
Yes or not
Yes
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
Yes
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
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
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
Yes
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
Yes
Column quality labels comes in this categories….which does not belong to the list
Valid
Error
Unknown
Missing
Unexpected error
Missing
Which feature doesn’t belong to column distribution
Unique
Distinct
Several
Group by value; filter by value, copy data are part of column profile or column distribution
Column profile
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
not
As the Filter is applied after the data is imported, it wont help in importing a sample of data from the table. Instead, adding a WHERE clause to the SQL statement could be the right solution
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
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
4
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
Common Data Service
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
Power Query
You want to create a data source that can be used by Power BI. Which type of data source should you use?
- SQL Server
- Common Data Service
- SharePoint
- OneDrive
1
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
Use the Power Query SDK
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
Common Data Service
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
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.
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
True
All Sharepoint report viewers must have Power BI pro license
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
Push Datasets
Hybrid Datasets
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
Yes