Microsoft Power BI Certification (PL-300) Practice Test 6

Product teams ask which feature kept users, which campaign paid back, and which segment is stalling. Power BI lets analysts blend product, finance, and marketing tables into one shared dashboard. Data scientists publish experiment readouts there so managers see impact, not only a model file. The PL-300 Microsoft Power BI Data Analyst Associate certification adds a recognized signal on top of a portfolio and can help you clear “Power BI required” filters. This Free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 6 is the rehearsal round—build stamina, then sit the official exam when the format feels stable. Companies hiring for this reporting include Google, Salesforce, and Adobe. U.S. base pay varies by city and industry: junior data analysts often earn $58,000–$75,000, mid-level analysts commonly earn $78,000–$108,000, and senior data analysts frequently reach $112,000–$145,000. Synergisticit JOPP helps jobseekers get certified, prepared, and hired at top tech companies through our Job Placement programs—Java DevOps Full Stack JOPP and Data Science JOPP.

If you want to learn how to get hired as a Power BI Data Analyst, Data Scientist, Data Engineer, AI or ML engineer, Java developer, or software engineer, contact Synergisticit for expert upskilling and marketing connections to companies. Visit Synergisticit Contact Us and Synergisticit JOPP.

Welcome to your Microsoft Power BI - Test-6

Name

Phone

Q1. You have a Power BI model that contains the following tables:

Microsoft Power BI data table showing EnrollmentID and EnrollmentDate fields for data modeling practice.

Consider a new table named SchoolYearDate which has the same columns schema as the Date table. You want to create a report that shows the total Enrollments by SchoolYearDate and Calendar Month.
How can you achieve the task?

Select 1 option(s):

Add SchoolYearDate to the model and create a one-to-many relationship with the Enrollments Table.

Append SchoolYearDate into the Date table.

Union SchoolYearDate and Date as one table.

Delete Date Table and use SchoolYearDate as the main Date table.

Q2. Consider two Microsoft SQL Server databases named SQLtest and SQLlive. Both the server databases contain the same tables.

You create a new Power BI Desktop project based on 50 tables from SQLTest. Before publishing the report to Power BI Service, you need to connect the project to tables in SQLlive.
What should you do in the Query Editor, with a low administrative effort, in order to meet the goal?

Select 1 option(s):

Edit the on-premises gateway settings.

Configure the Data source settings.

Change manually the data source for each table.

Copy the model into another PowerBI Project.

Q3. Consider the table shown in the picture:

Microsoft Power BI data table with dates, enrollments IDs, and course IDs for data modeling

All cells in the date column must contain a date. You want to replace null values with the date from the previous row.
Which command should you run in Power Query?

Select 1 option(s):

Fill, and then Down.

Replace Errors.

Remove errors.

Date, and then Earliest.

Q4. Your colleague has shared with you a file containing a dataset about global market sales. After importing it inside your Power BI Desktop, you want to get a quality profile of the dataset.

How can you achieve this task?

Select 1 option(s):

From Power Query, check the data profiling functionalities.

Create a table visual which contains all the dataset columns, then order columns by errors and blank values.

Create a DAX calculated column that uses the FILTER function.

From Power BI Desktop, set a Page Filter that includes only errors and blank rows.

Q5. Consider two tables named Tab1 and Tab2 that retrieve data from an Oracle database. Both tables have the same data structure. You plan to combine the data from Tab1 and Tab2.

Select the right command to use.

Select 1 option(s):

Append Queries.

Combine Files.

Merge Queries.

Merge Rows.

Q6. Consider the tables shown in the picture:

The tables come from a Microsoft SQL Server database.
The Enrollments table contains more than two million rows. You plan to import a sample of data from the Enrollments table in Power BI Desktop.
There are two ways to achieve the goal from the following options, select them.

Select 2 option(s):

From Query Editor, create a column by using Custom Column command

From Query Editor, filter the table by Enrollment_date.

From Query Editor, add a SELECT statement that uses a WHERE clause.

In the Power BI Service, create a calculated table.

From Query Editor, create a custom column that SAMPLE Function.

Q7. Consider the table shown in picture 1:

Microsoft Power BI course list for data modeling and visualization training.

You want to configure the table as shown in picture 2:

Which command should you use?

Select 1 option(s):

From the Split Column menu, click By Delimiter.

From the Extract menu, click Text After Delimiter.

From the Format menu, click Trim.

From the Extract menu, click Last Characters.

Q8. You have imported a data source in Power BI Desktop, now you plan to use Power Query to add some data transformations.

You notice that the data model presents a huge list of queries that make it difficult to organize the transformation steps.

Which best practice can you adopt in Power Query to solve this issue?

Select 1 option(s):

Append queries when it is possible.

Reduce the list of queries by importing small parts of the original dataset.

Create a group of queries to classify the data-transformations.

Re-name all the queries with a classification syntax.

Q9. Consider the table shown in the picture:

Microsoft Power BI data table illustrating payment and discount code options for data modeling practice.

You want to replace the ”-” value in the DISCOUNT_CODE column with the text ”NO_DISCOUNT”.
Which M function completes the following formula?
Microsoft Power BI data visualization practice test and quiz for IT professionals.

Select 1 option(s):

Text.Replace

Column.ReplaceValue

Text.Clean

Table.ReplaceValue

Q10. Consider a Power BI Model containing the tables shown in the picture.

Microsoft Power BI table displaying CourseArea and Enrollments data for data modeling practice.

Course[CourseName] contains NULL values. You plan to add a new column to the Course table that uses the following formula:
=if [CourseName]=null then “NA” else [CourseName]
Select the option available in the Query Editor to meet the goal.

Select 1 option(s):

Index Column.

Column From Examples.

Conditional Column.

Pivot Column.

Q11. You are working on the Contoso Sales report in Power BI. It relies on a large dataset.

The Sales[DateKey] column is in the Date/time format as shown:
Microsoft Power BI data table illustrating data modeling and visualization for technical skill development.

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

Select 1 option(s):

Compress the databes into a zip file.

Use the CALENDARAUTO function in DAX.

Separate date and time into two distinct columns before importing them into Power BI.

Delete the Sales[DateKey] column.

Q12. In your Power BI report, you have the Sales table that has the following column:

Microsoft Power BI data table example with SalesKey, DateKey, and StoreKey columns.

The Sales table contains one million records per month. You want to minimize the data model size. Plus, you want to count sales by Date and Store. How can you meet the two goals?

Select 1 option(s):

Create a calculated measures with the COUNTROWS function.

Create a calculated table with the SalesAmount column.

Use the Group by function in Power Query, aggregating sales by DateKey and StoreKey using Sum as operation.

Use the Group by function in Power Query, aggregating sales by DateKey and StoreKey using Count Rows as operation.

Q13. You want to import 50 Microsoft Excel files to Power BI Desktop. All the files share the same structure and are they stored in a unique desktop local folder. You plan to import all Excel files into one table.

How can you achieve the goal?

Select 1 option(s):

Add a Microsoft Excel data source and select all the files in the folder

Add every single file to the model and then use the Merge Queries command.

Add a folder data source and use the Combine Files command.

Add a folder data source and use the Append Queries command.

Q14. Consider the table shown in the picture:

You want to create a custom column that hides the first seven digits of the NationalCode. The values in the new column should be displayed in the following format: xxx-xx-0000
Select the proper order of targets to complete the formula:
Microsoft Power BI data modeling visualization practice quiz example.

Select 1 option(s):

Text.Insert - Text.Start

Text.Insert - Text.Replace

Text.Replace -Text.Start

Text.Insert - Text.end

Q15. You have connected a Microsoft SQL Server Analysis Services (SSAS) cube to Power BI Desktop, generating the following query:

Microsoft Power BI code snippet illustrating data modeling and DAX formulas.

The query retrieves 10,200 records. After checking the data source, you discover that there are 21,300 records.
How can you ensure that the query retrieves all 21,300 records?

Select 1 option(s):

Delete the Remove Duplicates steps.

Change the query to use Direct Query mode.

Change the query to use Import connection mode.

From Power Query, select Unpivot Columns command.

Q16. You have created a query to append the rows of three different tables that contains product data into one table named Products.

Now you need to set-up a new ID Column to be sure that every row in the Products table contains a unique value.
How can you meet the goal?

Select 2 option(s):

Add an Index Column to Products Table.

Select a Product Table Column and click Remove Duplicates.

Add a Column from Examples to Products Table.

Add a counter column to Products Table.

Q17. Consider the following tables:

Microsoft Power BI table schema illustrating data modeling for professional development.

You plan to create a relationship between the Enrollments table and the Courses table on the Course _ ID column.

What task do you need to perform before creating the relationship?

Select 1 option(s):

In the Courses table query, use the Table.TrasformColumnTypes function.

In the Course table query, use the Table.TrasformRows function.

In the Enrollments table query, use the Tables.GetRelationships function.

In the Enrollments table query, use the Table.TrasformRows function.

Q18. You have the tables shown in the picture:

There is a relationship between tables, you want to create a report in Power BI Service that shows TotalPaid by EnrollmentDate and by CourseName.
N.B. Only the required columns must be shown in the report.
Select the right configuration of EnrollmentID column and TeacherID column.

Select 1 option(s):

From Query Editor, click on "Choose Columns" and remove the TeacherID column, then in the report view hide the EnrollmentID column.

From Query Editor, select EnrollmentID and click Remove other Columns then select TeacherID and click Hide.

From Query Editor, select EnrollmentID and click Remove Columns then select TeacherID and click Hide.

Q19. Consider two tables named Course and Teacher.

Microsoft Power BI practice test data table with course IDs, names, cities, and teacher IDs.

In the picture, you can find a sample of data for the tables. You want to know which Teacher is responsible for which course.
Which kind of Join should you use?

Select 1 option(s):

Left Join.

Right Join.

Outer Join.

Inner Join.

Q20. You have imported a dataset in Power BI Desktop from an Excel File. During the tables profiling, you discover two columns that need to be fixed:

– ColumnA presents several values starting with space;
– ColumnB contains several non-printable characters.
Which couple of commands should you use to fix the above column errors?

Select 1 option(s):

ColumnA: TRIM - ColumnB: CLEAN

ColumnA: LENGHT - ColumnB: TRIM

ColumnA: CLEAN WHITE SPACES - ColumnB: TRIM

ColumnA: CAPITALIZE EACH WORD - ColumnB: CLEAN

Q21. Consider the table named Courses shown in the picture:

Microsoft Power BI data table illustrating course details and data transformation concepts.

You plan to create a relationship between the Courses table and another table called Enrollments.
Which function let you optimize the query for Courses before creating the relationship?

Select 1 option(s):

Table.IsDistinct

Table.Join

Table.Group

Table.Distinct

Q22. Consider a column named Product_SKU. The values in the column have the following format:

• 7271-1123×998
• 7271-1123×945
• 7271-1123×924
The values after x in the Product_SKU column indicate the SKU extension. You plan to create a custom column in Query Editor that contains only the SKU extensions.
Select the right order of functions to complete the following formula:
Microsoft Power BI data modeling visualization practice test questions.
Select 1 option(s):

AFTERDELIMITER - REMOVERANGE

POSITIONOF - REMOVERANGE

POSITIONOF - TRIMEND

AFTERDELIMITER - RELATIVEPOSITION

Q23. How do you know that the TotalCost column has 0% of empty rows?

Microsoft Power BI data validation showing TotalCost with 100% valid data.

Select 1 option(s):

Thank to the DAX PERCENTAGES formula.

Thanks to the column quality tool in Power Query.

Thanks to the column distribution tool in Power Query.

Thanks to the column profile tool in Power Query.

Q24. Consider a table named Enrollments that contains a column named StudentID. The Data Type of StudentID is ”whole number”. After you have imported tables in Power BI Desktop, you discover that the StudentID column contains several non-numeric values. You want the non-numeric values in the StudentID column set to 0.

How can you achieve the goal?

Select 1 option(s):

The solution must request a low transformation effort.

From Query Editor, open Advanced Editor and use Text.Remove function.

From Query Editor, select the StudentID column and click Remove Errors.

From Query Editor, select the StudentID column. Click Replace Errors and set a value of 0.

From Query Editor, open Advanced Editor and use Text.Format function.

Q25. Consider a Power BI report that contains a Pie chart and a Line chart on the same page. The Line chart displays the total Enrollments by Year, while the Pie chart displays the total Enrollments by course.

You want to ensure that when you select a year on the Line chart, the Pie chart remains unchanged.
How can you perform this task?

Select 1 option(s):

Edit the interactions from the Format menu.

Delete the relationship between the Enrollments table and the Date table.

Set a visual level filter on the report page.

Set a visual level filter on the Pie chart.

Q26. You are configuring a Gauge Chart. Where do you set the Goal?

Select 1 option(s):

Power Query.

Calculated column.

Format settings.

DAX Formula.

Q27. Consider a table that contains the last two years of sales data. You want to identify the outliers.

Which type of visual best fits your needs?

Select 1 option(s):

Key Influencers.

Bar chart.

Scatter plot.

Area chart.

Q28. You plan to use R Scripting in Power BI Desktop to create several visualizations.

Which actions should you perform to use R scripting in Power BI Desktop?

Select 1 option(s):

You don't need to perform any action: R scripting is available in Power BI Desktop by default.

Download and install RStudio on the computer that has Power BI Desktop installed.

Download and install R plug-in for Power BI Desktop.

Download and install Microsoft R on the computer that has Power BI Desktop installed.

Q29. Consider a report in Power BI Desktop that contains several donut charts and a date slicer.

You plan to create a slide show that displays the donut charts filtered by different years. You want that the slide show can be used from Power BI Service.
What should you do before publishing the report?

Select 1 option(s):

Filter the donut charts by using the slicer, then create bookmarks.

Configure page level filters, and then create groups that use the Bin group type.

Configure drillthrough filters for each bar chart, and then select Selection Pane.

Configure report level filters, and then create groups that use the List group type.

Q30. Your workspace contains 10 dashboards. You want to allow users to find data by using natural language queries.

What should you do to meet the goal?

Select 1 option(s):

From the properties of the dashboard, modify the Q&A settings.

From the Power BI Desktop disallow Q&A option to the reports.

From the properties of the datasets, modify the Q&A settings.

Pin a Q&A tile into the dashboards.

Q31. Consider the following table scheme:

Microsoft Power BI data table schema for data modeling practice quiz

Note that in the Date table, the date_id column has a format of yyyymmdd and the month column has a format of yyyymm.
The week column in the Date table and the week_id column in the Weekly_Returns table have a format of yyyyww.
You are in charge of building a Power BI report following these requirements:
The Enrollments managers ask for a visual to analyze enrollment performance versus enrollment targets. You must include in the visualization a time trend across months.
Which visualization object should you select?

Select 1 option(s):

Multi row card.

KPI.

Gauge.

Key Influencers.

Q32. You want to use Python Scripting in Power BI Desktop in order to create several visualizations. After you have installed and configured Python for Power BI Desktop, you try to run the following code:

from matplotlib import pyplot;
ax = pyplot.gca();
dataset.plot.line(x = ‘Courses’, y = ‘Total Enrollments’, color = ‘green’, ax = ax)
Power BI Desktop returns the following error message:
Microsoft Power BI practice test questions and data visualization examples.

How can you fix the issue?

Select 1 option(s):

You should add the following command to the script: pyplot.show();

You must enable the Pyhton Visuals before running code.

You need to refresh the IDE settings.

You must refresh the dataset origin connection.

Q33. You have a table named Enrollments with the following columns:

– StudentID;
– CourseID;
– Date;
– CourseName;
– FeePaid.
You create a report that contains a Stacked Column Chart that shows the count of Students by CourseName, then you want to customize the information placed in the visualization tooltip for the chart.
What should you do first?

Select 1 option(s):

Create a new report page and set it as Tooltip.

Disable the tooltip option from the Format pane of the Stacked Column Chart.

Set the CourseName column as Tooltip field.

Set the StudentID column as Tooltip Field.

Q34. You create a Power BI Desktop project named Enrollments_BI that contains a table with the following columns:

– StudentID;
– StudentName;
– City;
– ProvState;
– Country.
You configure a bar chart to display the number of students by Country, and drill down to ProvState, and in the end to City.
You publish the Enrollments_BI project to Power BI Service and plan to share it with your colleagues: how could you share it?
N.B. Your colleagues must be able to use the Drill Down feature.
Solution: You create a dashboard and pin the Bar Chart visualization to it, then share the dashboard with your team.
Does this solution meet the goal?

Select 1 option(s):

Yes

Q35. Consider a table containing the following columns.

– Date;
– Funds;
– Expenses.
You configure a Line and Clustered Column Chart as the following:
– Date Column as Shared Axis
– Funds Column as Line Values
– Expenses Column as Column Values
You notice that the Line Values doesn’t’ match the correspondent Y-axis Values and it is set on the top of the chart by default as shown in the picture:
Microsoft Power BI data visualization chart demonstrating monthly trends.

How can you fix the visualization?

Select 1 option(s):

Set to Auto the Y-axis 'start' and 'end' settings.

Remove the Default Summarization from the Funds column.

Remove the Default Summarization from the Expenses column.

Edit the data type of Funds column as a Whole Number.

Q36. You have created a Power BI dashboard that contains visualizations of sales data.

You want to enable sample questions that users can ask when using the Q&A option.

What do you need to modify in the Power BI Settings?

Select 1 option(s):

Reports.

Dashboards.

Datasets.

Workbooks.

Q37. You plan to create a Corporate Power BI Desktop Project that will be shared with the entire organization.

You need to customize the report with both the corporate colors of your organization and a set of custom icons.
How can you meet the goal?

Select 1 option(s):

The solution must request the lowest administrative effort.

Select the visualization you want to add to the report, then edit their color properties from the Format Pane.

Configure an XML file and then import it in Power BI Desktop as Custom Theme.

Configure a JSON file and then import it in Power BI Desktop as Custom Theme.

Access to Power BI Theme Gallery and import a blank theme, then customize it.

Q38. Your Power BI report contains a clustered bar chart that has Sales[ReturnAmount] as the value and Product[ProductKey] as the axis.

You want to improve the visual by adding a horizontal line that shows which products have a return amount above the median amount.
How could you reach the goal?

Select 1 option(s):

In the Analitycs pane for the clustered bar chart, add a Percentile line set to 50%.

In the Format pane for the clustered bar chart, add a Constant line and set it to 0.5.

In the Analitycs pane for the clustered bar chart, add a Constant line and set it to 0.5.

In the Analitycs pane for the clustered bar chart, add a Trend line.

Q39. You have a dashboard named Sales_01. Q&A is enabled on the dashboard. When users try to get the count of clients, the query fails. Instead, when users ask for the count of subscribers, they receive the expected results. You want to ensure that both queries will return the same results.

Which action should you perform?

Select 1 option(s):

Edit Synonyms from Power BI Desktop.

Edit tables from Power Query in Power BI Desktop.

Edit Relationships from Power BI Desktop.

Edit Synonyms from Power BI Service.

Q40. Consider a table named Students with the following columns:

– StudentID;
– StudentName;
– City;
– ProvState;
– Country.
You are creating a Power BI report that includes a bar chart to display the number of students by location. You want that the report will show the number of students by Country, and drill down to ProvState, and in the end to City.
Select the right configuration of the drill down in the bar chart.

Select 1 option(s):

In the Legend field, add ProvState. In the Axis field, add Country and City.

In the Value field add all the columns in the following order: Country, ProvState, City.

In the Value field, add Country. In the Axis field, add ProvState and City.

In the Axis field, add all the columns in the following order: Country at the top, followed by ProvState and City.

Q41. You are building a complex report in Power BI, full of visuals.

You want to be sure that the user will read it in a logical way when he/she uses the keyboard.
On what should you have to work on?

Select 1 option(s):

Filters hierarchy.

Tab order.

Page order.

Layer order.

Q42. Consider a table named Enrollments that contains enrollments data for Europe. Check the sample dataset in the picture:

Microsoft Power BI data table showing area, year, and enrollments for UK, Spain, France, Italy,

You try to create a map to show Enrollments by Area, but you find out that the map doesn’t work.
What can you do to fix the map visualization?

Select 1 option(s):

Add a column that contains latitude and longitude.

Create a table named Country and create a relationship with the Enrollments table.

Select the Area field. From the Modeling tab, change the Data Category.

Select the Area field. From the Modeling tab, change the Data Type.

Q43. You have a Microsoft Excel file named Enrollments.csv that contains data about Student Enrollments by Region.

After you have imported the Excel file to Power BI Desktop, you create a bar chart showing the Enrollments amount by region.
Unfortunately, the Enrollments amount value appears as the count of Enrollments amount instead of the sum of Enrollments amount for each region.
You need to modify the query to ensure that the data appears correctly.
How can you fix the issue?

Select 1 option(s):

Change the Data Type of Enrollments amount column to Whole Number.

Create a calculated column that use the SUM function.

Delete the query, import the data into Microsoft One Drive for Business, and then from Power BI Service connect to the Enrollments.csv by clicking import.

Create a calculated measure that uses the SUMX function.

Q44. Your Power BI model contains two tables named StoreVisits and Date. After you have created a measure to calculate the number of Store Visits, you use it in a report visualization as shown in the picture.

Microsoft Power BI chart visualizing customer visits over time.

You found that the total number of customer visits was 60,000 and that there were only 5,000 customer visits in August. You check that the total number of visits was 90,000 and that there were only 10,000 visits in October.
How can you fix the report visualization?

Select 1 option(s):

Disable the default Summarization to the Number of visits column.

Modify the measure to use the sum DAX function.

Create a relationship between the StoreVisits and the Date table.

Modify the measure to use the Count function.

Q45. An area chart shows the discount quantity over years. Therefore, when you hover the mouse over a data point, you will see the discount quantity at a certain year:

Microsoft Power BI chart visualizing DiscountQuantity trends over time.

How could you provide additional information about the discount amount, on the black label?
The result should be as the following picture:
Microsoft Power BI chart visualizing DiscountQuantity and DiscountAmount over time.

Select 1 option(s):

Add the DiscountAmount column on the secondary values.

Add the DiscountAmount column on the tooltip.

Set a drillthrough option for the visual.

By right-clicking on the visual, select Analyze.

Q46. Your principal asks you to print some Power BI reports in order to physically share them with the other colleagues during the next meeting.

When you start to print the reports, you notice that some tables show less rows than they really have.
How can you solve this issue?

Select 1 option(s):

Change the table visual to a matrix visual.

Group the rows of the table to reduce its size.

Extend table visual to the whole page.

Create a Paginated Report.

Q47. Consider a table named Enrollments containing the sample data shown in the picture.

Microsoft Power BI data table displaying course enrollment details for SynergisticIT training.

After you have created a stacked bar chart to display CourseName by StartingDate, you notice that the axis shows all the individual dates. You want to set the drill down in the chart to display CourseName by year, by week, and day.
What is the first task to do?

Select 1 option(s):

From the Format Pane of the Chart set the type of the Y-Axis to Categorical.

Create a new table that has columns for the date, year, week, and day.

From the Format Pane of the Chart set the type of the X-Axis to Categorical.

Q48. You plan to create a custom visualization for Power BI. What do you install first?

Select 1 option(s):

Microsoft Azure PowerShell

Node.js

Power BI Service

JavaScript

Q49. Consider a table named Enrollments that contains the following three measures:

– A measure named Total Enrollments Last Year shows the Enrollments from the previous calendar year. The current value is 52,000.
– A measure named Total Enrollments This Year shows the Enrollments from the current calendar year. The current value is16,000.
– A measure named Total Sales Difference based on the following DAX formula: Enrollments[Last Year] – Enrollments[This Year].
You need to create the following visualization.
Microsoft Power BI gauge chart visualizing data modeling and dashboard configuration.

You plan to create a Gauge visualization by using the measures above. Select the right configuration for the visualization.

Select 1 option(s):

Value: Total Enrollments this Year - Maximum Value: Total Enrollments this Year - Target Value: Total Enrollments Last Year

Value: Total Enrollments this Year - Maximum Value: Total Enrollments last Year - Target Value: Total Enrollments Last Year

Value: Total Enrollments last Year - Maximum Value: Total Enrollments last Year - Target Value: Total Enrollments this Year

Value: Total Enrollments last Year - Maximum Value: Total Enrollments this Year - Target Value: Total Enrollments Last Year

Q50. Consider the table shown in the picture:

Microsoft Power BI data table showing enrollments by country.

You add Country and Enrollments columns to a table visualization in Power BI Desktop and the result appears as in the following picture:

Why does it show three rows of data instead of six?

Select 1 option(s):

Data Category of Country is set to Country.

The Enrollments column data type is set to text.

Because of Default Summarization on Country.

Because of Default Summarization on Enrollments.

Q51. You are analyzing the Customer Sales monthly report and you notice that the Churn Rate metric is strangely increased.

You want to understand which variables may affect this result.
Which solutions can help you to explore the possible causes in Power BI Desktop?

Select 2 option(s):

Decomposition tree visual.

Enable the Auto ML.

Use the Gauge visual.

Use the Key Influencer visual.

Q52. Your Organization plan to create a Power BI App which would include Power BI dashboards and other custom content.

The App will be available to all Organization users. You need to be sure that all the PowerBI users will have access to the App.

Select 1 option(s):

NB The solution must request the lowest administrative effort.

Add each user to the app workspace and give him "member" permissions.

Create an Office 365 Group named "all organization users" and give it app workspace "member" permissions.

Create an Office 365 group named "all organization users" and share the link to get the App.

Ask the PowerBI admin for enabling permission to install the app automatically to all users.

Q53. You have an app workspace. You collaborate in the app workspace with a user named User_01. User_01 is a member of the workspace. You plan to create a report that retrieves data from a Microsoft SQL Server database. You want that User_01 can edit the report both from Power BI Desktop and from powerbi.com.

Select the right order of the actions to achieve the goal.

Select 1 option(s):

From Power BI Service, create a report - From Power BI Service share the report in the App Workspace - From the App Workspace settings, allow User_01 to export data from the report.

From Power BI Service, create a report - From Power BI Service share the report with User_01.

From Power BI Desktop, add a data source - From Power BI Desktop, create a report - From Power BI Desktop, publish the report to the Power BI Service.

From Power BI Desktop, create a report - From Power BI Desktop, publish the report to the Power BI Service - Deploy an On-Premises Data Gateway (personal mode).

Q54. You have a report named Sales in an app workspace named Sales_BI. User_01 is a member of the Sales_BI.

You have enabled the option ”Allow users to build new content using the underlying dataset” from the report settings.
What will happen to the underlying dataset? Select the true statements.

Select 2 option(s):

Row-level security restrictions on the dataset are in effect.

You haven't made a copy of the dataset. The dataset still resides in its original location.

You have made a copy of the dataset. The dataset is duplicated in your workspace.

Q55. You manage a list of reports for the sales team of your company. The company operates across different regional markets and every region has its sales manager.

You need that the sales managers can interact with the data from their region. In addition, you want that sales managers can’t modify the report’s layout.
Note that the datasets use row-level security (RLS).
How can you meet the goal?

Select 1 option(s):

Disable Row Level Security.

Create a Power BI app that contains all the reports and give access permissions to the sales managers.

Create a new workspace, duplicate the datasets and reports, add the sales managers as owners of the workspace.

Publish the reports to a workspace and store the datasets in another one.

Q56. You have a Power BI app workspace that contains 30 reports shared with 55 users of your organization.

You plan to start a reports maintenance program. You need to know which reports present a critical usage.
How can you achieve this task?

Select 1 option(s):

Check the activity log by using the Power BI Management cmdlets for PowerShell.

Request to the Power BI admin enabling usage metrics for content creators.

Go to the Health tab in the Capacity settings area in the Admin portal.

You can use the Power BI Premium Capacity Metrics App.

Q57. You have a table named ‘Enrollments’ stored on a Microsoft Excel spreadsheet.

You want to add the Enrollments table to a Power BI dashboard as a tile.

What is the tile configuration?

Select 1 option(s):

From Excel, import the workbook to PowerBI Desktop, then publish it to PowerBI Service.

From the Power BI service, upload the Excel workbook.

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

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

Q58. You plan to publish a report from Power BI Desktop to Power BI Service.

The report retrieves data from an Azure SQL Database. How can you ensure that users of your organization will see the current data when they access the report on the Power BI Service?

Select 1 option(s):

In the Power BI service's Settings page, select the Datasets tab, choose the dataset that uses DirectQuery, and select Edit credentials.

Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.

Deploy an on-premises data gateway (personal mode). Connect to the data by using the Live Connectivity mode.

Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Connectivity mode.

Q59. A Power BI user in your organization has published a report to the Web. The report contained sensitive data.

What can you do to prevent the reports from being published on the Web?

Select 1 option(s):

From Azure AD remove the PowerBI Pro license from the user.

From the app workspace settings remove the user as a member.

From the Power BI Admin portal, disable the Publish to web setting.

From the Power BI Pro, delete the embedded codes.

Q60. Your organization owns a consistent number of dashboards on Power BI. Your goal is to ensure that when users browse the list of the available dashboard, they can see the ones that contain Personal Identifiable Information.

Which function best fit your needs?

Select 1 option(s):

Row Level Security.

Tiles.

KPIs.

Microsoft Information Protection sensitivity labels.

Q61. Your organization plan to use the Power BI Service to get several visualizations from data stored in a custom application.

The developers ask for pushing data into the Power BI Service from the custom app.
How can you ensure this task?

Select 1 option(s):

Go to Office 365 Admin portal and register a web app.

Go to Tenant Setting from PowerBI admin portal and set the API permissions.

Go to app.powerbi.com and create an empty report.

Go to dev.powerbi.com/apps and register an application.

Q62. You have a report named Sales_01. You plan to publish Sales_01 to a Blog, but you need to be sure that the report will preserve its size as a set on the report page.

Which View Mode should you set for the Sales_01 report?

Select 1 option(s):

Fit to Width.

Custom size.

16:09

Actual Size.

Q63. Your company stores sales data on a Microsoft SQL Server. You are responsible for creating a Power BI report, ensuring the quality and completeness of the sales data. In particular, you must be sure that the report doesn’t show negative amounts for sales data.

How can you review data in Power Query before creating the data model?

Select 1 option(s):

Create a column from examples and fill it with positive values only from the total_sales column.

Select Column profile, and then select the total_sales column.

Select the total_sales column and filter out negative values.

Select the total_sales column and delete all the negative values.

Q64. You create a Power Bl dataset from your organization’s data warehouse using DirectQuery with the tables shown in the below schema exhibit.

Microsoft Power BI table schema example for data modeling practice quiz.

You create a calculated table named Country from the dataset for unique values of country in the table named Customer.
You generate visualizations for the sales data including showing sales by product manager. The product manager data is not in the data warehouse. The product manager data is in an Excel workbook on your local computer as shown in the Workbook exhibit below.
Microsoft Power BI data table example showing table and column names, and data types.

You do not have the Power BI On-Premises Gateway installed. You need to explain to the user when the data in the visualizations was last refreshed.
Visuals referring to the Product Managers table show the values from..

Select 1 option(s):

when the user pressed F5

when the workbook was last loaded

when the dataset was last refreshed

when the user selected Refresh dashboard tiles

the latest values in the data warehouse

Q65. How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are created.

Select 1 option(s):

Connect to the files with Folder connector and use the Combine Binaries functionality

Connect to a new file each month, perform transformations, and use Append function in Power Query Editor to combine all targets in the same table