Microsoft Power BI Test - 13

Welcome to your Microsoft Power BI – Test-13

Name

Phone

Q1. You should create a report that shows the company‘s sales performance. The sales team asked you to add a single visualization that could help identify the factors that affect sales and influence success. Which of the following visualization would you use?

Select 1 option(s):

None of these

Key influencers

Funnel chart

Q&A visualization

Q2. You build a map of 3,40,000 students using an R visual. You ensure that the values of student_id, longitude, and latitude are added in the fields sent to the visual. Each Student_id is unique representing an individual student. But when the visual is loaded by the users in Power BI, it shows the details for only some of the students; not all. What is the reason behind this issue?

Select 1 option(s):

The data was duplicated

The number of records to be shown were higher than the capacity of R visuals

A different version of R was used to build the visual

The data originates from a Microsoft SQL Server source

Q3. You are working on the K slidingWindow for a model training and stuck with the inference. How many data points should be accessible from the source file during inference to get valid results?

Select 1 option(s):

K+1 points

K*K points

K points

K-1 points

Q4. You have recently joined an organization as a Database Administrator Associate. Your senior has asked you to create aggregation for a particular database. Which of the following methods cant be used to create the aggregation?

Select 1 option(s):

Aggregations can be created by using Data visualization tools in Power BI Desktop.

Aggregations can be created by using Power Query Editor in Power BI Desktop.

If you have access to the database, the summary can be created by creating a table with the summary and then importing the table into Power BI Desktop.

If you have access to the database, the aggregation can be created by creating a view for the aggregation and then importing the view into Power BI Desktop.

Q5. True or False: In Power BI, by default column profiling is based on the top 1,000 rows.

Select 1 option(s):

FALSE

TRUE

Q6. What does it mean to “assume referential integrity“ when developing relationships between tables in Power BI Desktop?

Select 1 option(s):

It is considered that there are no null or empty values in any data table in the relations.

The Require Referential Integrity setting causes queries to use INNER JOIN statements instead of OUTER JOIN statements, which increases the efficiency of the query.

It automatically considers the relationship as one to one.

It allows the calculated columns to be considered as relationship columns between the tables.

Q7. Which of the following options is not a privacy level in Power BI desktop?

Select 1 option(s):

Private

Confidential

Public

Organizational

Q8. Which of the following options is not a Microsoft 365 sensitivity label?

Select 1 option(s):

highly confidential

public

none

general

Q9. In Power BI, column _____ shows the number of valid, error, and empty cells in a column.

Select 1 option(s):

distribution

quality

analysis

profile

Q10. Select from the list below the types that are not valid in the M programming language?

Select 1 option(s):

Table

Record

Point

List

Q11. In Power BI, column _____ include(s) characteristics like count, error, empty, distinct, unique, zero, min, max, and average.

Select 1 option(s):

wide

statistics

analytics

charts

Q12. What is the first parameter in the DAX function PATHITEM?

Select 1 option(s):

the level you want to be returned

type

the text path describing the hierarchy

the name of the field you‘re interested in

Q13. You need to register an app for embedding Power BI content. You are thinking of using an account which does not have a Power BI Pro license. Will it work for you?

Select 1 option(s):

Yes

Q14. Which of the following is a way to improve performance when retrieving data in Power BI?

Select 1 option(s):

Pulling the data only in Power BI Service and not in Power BI Desktop.

Combining the date and time columns into a single column.

Using the SELECT SQL statement in SQL queries when retrieving data from a relational database.

Performing some calculations in the original data source.

Q15. You are creating a sales report that should consist of several pages. Each page is to contain the response to a specific business query.

You decide to create a menu page that displays all business queries. Users should be able to click on any business query and then be redirected to the page with the answer to the query they clicked on. You also need to make sure that the menu page works when it is published to any workspace.
What would you do to make this work?

Select 1 option(s):

Add a text box and link for each business query.

Create a Power Apps visual with a dropdown list. This list will consist of all business queries.

Add filters to the menu page.

Add a button for each business query and set the action type to Bookmark.

Q16. Your team is working on a project where there will be different scenarios for using the decomposition tree. For which purposes would you NOT recommend using the decomposition tree?

Select 1 option(s):

To perform a root cause analysis.

To perform what-if analysis with integrated parameters.

To automatically analyze the selected dimensions to check where the metric has the lowest or highest value.

To visualize the data across multiple dimensions.

Q17. What is the second parameter in the DAX function LOOKUPVALUE?

Select 1 option(s):

the table in which to look

the field with the value you‘re searching for

the name of the field you‘re interested in

the value you want to match on

Q18. Which Power BI license type is the standard license required for most Power BI development work?

Select 1 option(s):

Embedded

Premium Per User

Premium Per Capacity

Pro

Q19. You are developing a Power BI report for a large data set. You want to improve the performance of the dataset update by performing an incremental update. Which of the following statements about this scenario are true?

Select 3 option(s):

RangeStart and RangeEnd are two PowerQuery parameters needed for incremental refresh.

Use the “Incremental Update“ function for all data sources

A date field is required in a table in the dataset.

Use the Incremental Refresh feature only for data sources that support query folding.

Q20. Why is it advisable to avoid NULL values in a numeric column?

Select 1 option(s):

A DAX expression with the MAX function over such data gives wrong results.

A DAX expression with an AVERAGE function over such data returns incorrect results.

A DAX expression with the SUM function over such data will give wrong results.

None of these

Q21. Which of the following statements correctly defines the rules for creating table relationships when designing a data model? (Choose two)

Select 2 option(s):

A relationship between two tables can be created using multiple fields from each table.

A relationship between two tables must be created with a single field from each table.

You can create several relations between two tables and all of these relations can be marked as active.

You can create multiple relationships between two tables, but only one of these relationships can be marked as active.

Q22. Which of the following statements about calculated columns in Power BI is false?

Select 1 option(s):

A calculated column is populated when it‘s created.

A calculated column does not add to the dataset size.

A calculated column‘s values are updated when the dataset is refreshed.

Calculated column values are stored in the Power BI dataset like those of a standard column.

Q23. Which of the following tasks can be performed ONLY by the workspace admin? (Choose three)

Select 3 option(s):

Creating, editing, or deleting the content in the workspace

Publish, update, and/or share an app in a workspace

Configure data refreshes

Add/remove other users

Q24. Which of the following lists presents the phases of Power BI report creation in correct order?

Select 1 option(s):

analyze, define, develop, test, deploy

requirements, design, implementation

development, test, production

test, development, test, production

Q25. In Power BI, Power Query Editor is available through the ______ menu.

Select 1 option(s):

Transform

Query

Tools

Analyze

Q26. Which of the following elements can you set in a bookmark? (Choose three)

Select 3 option(s):

Sort order

Slicers, including slicer type and slicer state

Visual selection state

Properties of fields

Q27. You develop a dataset named from the flat files and use incremental refresh. The dataset is deployed to Premium Power BI along with other related reports. You discover that the incremental refresh for the dataset fails due to lack of resources. Which of the following could be a possible reason for this issue?

Select 1 option(s):

None of these

Data type for the column that is utilized for data partition has changed.

Query folding is not happening.

No filter is applied to the file.

Q28. There is an Azure SQL database that contains the records of sales transactions. The database is updated regularly. You need to generate reports from the sales data to identify false transactions. The data should be visible within 5 minutes of the update.

How can the data connection be configured to achieve the target?

Select 1 option(s):

By setting the data connectivity mode to DirectQuery

By setting the Command timeout in minutes setting

By adding a PL/SQL statement

By adding a SQL statement

Q29. True or False: The queries in the query editor do not have to be loaded into the data model. You can decide and select whether they should be loaded or not.

Select 1 option(s):

FALSE

TRUE

Q30. True or False: The nodes in a decomposition tree are fixed and cannot be changed by the end users viewing the report.

Select 1 option(s):

TRUE

FALSE

Q31. Your team leader has asked you to print some Power BI reports and distribute them to team members during the meeting. Before you start printing the reports, you notice that some tables show fewer rows than there actually are. Which of the following is the correct method to fix this problem?

Select 1 option(s):

Expand the table to the whole page

Reduce the table size by grouping the rows

Create a paginated report

Create a customize tooltip

Q32. Can you create a relationship between two columns with different DATA TYPE?

Select 1 option(s):

Yes, but the cardinality of the relationship must be set as one to many.

Yes, but the cardinality of the relationship must be set as many to many.

No, the columns in a relationship must have the same data type.

Yes, the latest versions of Power BI Desktops fully support the creation of relationships between such columns.

Q33. You model the data using Microsoft Power BI. The data model consists of a large Microsoft SQL Server table called “Transactions“ and more than 120 million records.

During the development phase, it is necessary to import a sample of data from the “Transactions“ table.
You decide to write a DAX expression that uses a filter function.
Will this help you achieve your goal?

Select 1 option(s):

Yes

Q34. You want to split your query into two parts. Which of the following options would you use in Power BI?

Select 1 option(s):

Format Query

Extract previous

None of these

Split Query

Q35. For what reasons is the Lineage view in Power BI important? (Choose three)

Select 3 option(s):

Saves time by simplifying your task of identifying reports and dashboards that haven‘t been refreshed.

It helps in analyzing the data sets and finding the patterns, trends, and outliers.

Allows you to manage your workspaces and observe the impact of a single change in one dataset to reports and dashboards.

Simplifies the troubleshooting process because you can see the path that the data takes from source to destination and determine pain points and bottlenecks.

Q36. Which of the following statements about Slicer Visual in a Power BI report are true?

Select 2 option(s):

You can configure the Slicer Visual based on the date column to use sliders.

When adding a field to the Field Well of a Slicer Visual, you can use either a key figure or a column.

The purpose of using a Slicer Visual in Power BI reports is to provide an interactive filtering experience for report consumers.

A slicer visual from the report can be pinned to a dashboard to make the dashboard interactive.

Q37. You want to develop some visualizations in Power BI Desktop using R Scripting. Which of the following actions do you need to perform to use R Scripting in Power BI Desktop?

Select 1 option(s):

You must install Microsoft R on your system where Power BI Desktop is already installed.

None of these

You need to install R Studio on your system where Power BI Desktop is already installed.

R scripting is available by default in Power BI Desktop. You do not need to perform any special action to use R-Scripting.

Q38. You need to create Power BI reports which are to be deployed to Power BI Report Server. Which of the following tools would you use?

Select 1 option(s):

Power BI Report Builder

Power BI Desktop optimized for Report Server

None of these

Power BI Desktop

Q39. Which three parameters are required in the API requests for training and inference? (Choose three)

Select 3 option(s):

startTime

source

endTime

ratio

Q40. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars.You need to create a reference line to show which employees are above the median salary.Solution: You create a percentile line by using the Salary measure and set the percentile to 50%.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q41. What is the difference between a calculated column and a measure in Power BI?

Select 1 option(s):

A calculated column is computed at the row level, while a measure is computed at the aggregate level

A calculated column is computed at the aggregate level, while a measure is computed at the row level

A calculated column is used for filtering data, while a measure is used for sorting data

A calculated column is used for sorting data, while a measure is used for filtering data

Q43. For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder.The data model contains several measures.You need to create a Power BI report from the existing data. The solution must minimize development effort.Which type of data source should you use?

Select 1 option(s):

A. Power BI dataset

B. a SharePoint folder

C. Power BI dataflows

D. an Excel workbook

Q43. What is the difference between a calculated column and a calculated table in Power BI?

Select 1 option(s):

A calculated column is computed at the row level, while a calculated table is computed at the table level

A calculated column is computed at the table level, while a calculated table is computed at the row level

A calculated column is used for filtering data, while a calculated table is used for sorting data

A calculated column is used for sorting data, while a calculated table is used for filtering data

Q44. You have multiple dashboards.You need to ensure that when users browse the available dashboards from powerbi.com, they can see which dashboards contain Personally IdentifiableInformation (PII). The solution must minimize configuration effort and impact on the dashboard design.What should you use?

Select 1 option(s):

A. Microsoft Information Protection sensitivity labels

B. tiles

C. comments

D. Active Directory groups

Q45. Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:✑ Due Date✑ Order Date✑ Delivery DateYou need to support the analysis of sales over time based on all the date foreign keys.Solution: For each date foreign key, you add inactive relationships between the sales table and the date table.Does this meet the goal?

Select 1 option(s):

A. Yes

B. No

Q46. How can you ensure that a report is up-to-date in Power BI?

Select 1 option(s):

A. Manually refresh the report

B. Use a scheduled refresh

C. Use a live connection to the data source

D. Use a direct query to the data source

Q47. A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The Enhanced Dataflows Compute Engine is turned on for the dataflow. You need to use the dataflow in a report. The solution must meet the following requirements: ✑ Minimize online processing operations. ✑ Minimize calculation times and render times for visuals. ✑ Include data from the current year, up to and including the previous day. What should you do?

Select 1 option(s):

A. Create a dataflows connection that has DirectQuery mode selected.

B. Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.

C. Create a dataflows connection that has Import mode selected and schedule a daily refresh.

D. Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

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

Select 1 option(s):

SQL Server

Common Data Service

SharePoint

OneDrive

Q49. You have a Power BI workspace named Inventory that contains a dataset, a report, and a dashboard.You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

Select 2 option(s):

A. Ask a question by using Q&A.

B. Hide the report page.

C. Pin the visual to the dashboard.

D. Use quick insights on the dashboard.

E. Add the visual to the report.

Q50. How can you handle data that is not in the correct format for analysis?

Select 1 option(s):

Use data transformation tools

Use data modeling tools

Use data visualization tools

Use data profiling tools

Q51. You have a collection of reports for the HR department of your company.You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.Which type of visualization should you use?

Select 1 option(s):

A. ribbon chart

B. scatter chart

C. line chart

D. key influencers

Q52. You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings.You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column.What should you do?

Select 1 option(s):

A. Select the donut chart and set the column chart interaction to Filter.

B. Select the column chart and set the donut chart interaction to Filter.

C. Select the donut chart and set the column chart interaction to None.

D. Select the column chart and set the donut chart interaction to None.

Q53. From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR.You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.What should you do?

Select 1 option(s):

A. From powerbi.com, add users to the HR role for the dataset.

B. From powerbi.com, share the dataset to the HR team members.

C. From Power BI Desktop, change the Row-Level Security settings.

D. From Power BI Desktop, import a table that contains the HR team members.

Q54. How can you ensure that a report is using the correct dataset in Power BI?

Select 1 option(s):

A. Use a data source filter

B. Use a report-level filter

C. Use a page-level filter

D. Use a visual-level filter

Q55. You have a Power BI report.You have a table named Data1 that contains 10 million rows.Data1 is used in the following visuals:✑ A card that shows the number of records✑ A bar chart that shows total transaction amount by territory✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territoryYou need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals.What should you do?

Select 1 option(s):

A. Add a count field of the transaction amount to the size bucket of the scatter plot.

B. Add a trend line to the scatter plot.

C. Enable high-density sampling on the scatter plot.

D. Apply a row filter to the Data1 query in Power Query Editor.

Microsoft Power BI Test - 13

Q1. You should create a report that shows the company‘s sales performance. The sales team asked you to add a single visualization that could help identify the factors that affect sales and influence success. Which of the following visualization would you use?

Q3. You are working on the K slidingWindow for a model training and stuck with the inference. How many data points should be accessible from the source file during inference to get valid results?

Q4. You have recently joined an organization as a Database Administrator Associate. Your senior has asked you to create aggregation for a particular database. Which of the following methods cant be used to create the aggregation?

Q5. True or False: In Power BI, by default column profiling is based on the top 1,000 rows.

Q6. What does it mean to “assume referential integrity“ when developing relationships between tables in Power BI Desktop?

Q7. Which of the following options is not a privacy level in Power BI desktop?

Q8. Which of the following options is not a Microsoft 365 sensitivity label?

Q9. In Power BI, column _____ shows the number of valid, error, and empty cells in a column.

Q10. Select from the list below the types that are not valid in the M programming language?

Q11. In Power BI, column _____ include(s) characteristics like count, error, empty, distinct, unique, zero, min, max, and average.

Q12. What is the first parameter in the DAX function PATHITEM?

Q13. You need to register an app for embedding Power BI content. You are thinking of using an account which does not have a Power BI Pro license. Will it work for you?

Q14. Which of the following is a way to improve performance when retrieving data in Power BI?

Q15. You are creating a sales report that should consist of several pages. Each page is to contain the response to a specific business query.

Q16. Your team is working on a project where there will be different scenarios for using the decomposition tree. For which purposes would you NOT recommend using the decomposition tree?

Q17. What is the second parameter in the DAX function LOOKUPVALUE?

Q18. Which Power BI license type is the standard license required for most Power BI development work?

Q19. You are developing a Power BI report for a large data set. You want to improve the performance of the dataset update by performing an incremental update. Which of the following statements about this scenario are true?

Q20. Why is it advisable to avoid NULL values in a numeric column?

Q21. Which of the following statements correctly defines the rules for creating table relationships when designing a data model? (Choose two)

Q22. Which of the following statements about calculated columns in Power BI is false?

Q23. Which of the following tasks can be performed ONLY by the workspace admin? (Choose three)

Q24. Which of the following lists presents the phases of Power BI report creation in correct order?

Q25. In Power BI, Power Query Editor is available through the ______ menu.

Q26. Which of the following elements can you set in a bookmark? (Choose three)

Q28. There is an Azure SQL database that contains the records of sales transactions. The database is updated regularly. You need to generate reports from the sales data to identify false transactions. The data should be visible within 5 minutes of the update.

Q29. True or False: The queries in the query editor do not have to be loaded into the data model. You can decide and select whether they should be loaded or not.

Q30. True or False: The nodes in a decomposition tree are fixed and cannot be changed by the end users viewing the report.

Q31. Your team leader has asked you to print some Power BI reports and distribute them to team members during the meeting. Before you start printing the reports, you notice that some tables show fewer rows than there actually are. Which of the following is the correct method to fix this problem?

Q32. Can you create a relationship between two columns with different DATA TYPE?

Q33. You model the data using Microsoft Power BI. The data model consists of a large Microsoft SQL Server table called “Transactions“ and more than 120 million records.

Q34. You want to split your query into two parts. Which of the following options would you use in Power BI?

Q35. For what reasons is the Lineage view in Power BI important? (Choose three)

Q36. Which of the following statements about Slicer Visual in a Power BI report are true?

Q37. You want to develop some visualizations in Power BI Desktop using R Scripting. Which of the following actions do you need to perform to use R Scripting in Power BI Desktop?

Q38. You need to create Power BI reports which are to be deployed to Power BI Report Server. Which of the following tools would you use?

Q39. Which three parameters are required in the API requests for training and inference? (Choose three)

Q41. What is the difference between a calculated column and a measure in Power BI?

Q43. What is the difference between a calculated column and a calculated table in Power BI?

Q46. How can you ensure that a report is up-to-date in Power BI?

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

Q50. How can you handle data that is not in the correct format for analysis?

Q51. You have a collection of reports for the HR department of your company.You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months.Which type of visualization should you use?

Q53. From Power BI Desktop, you publish a new dataset and report to a Power BI workspace. The dataset has a row-level security (RLS) role named HR.You need to ensure that the HR team members have RLS applied when they view reports based on the dataset.What should you do?

Q54. How can you ensure that a report is using the correct dataset in Power BI?

Q4. You have recently joined an organization as a Database Administrator Associate. Your senior has asked you to create aggregation for a particular database. Which of the following methods cant be used to create the aggregation?