Power BI Data Analyst Associate Certification (PL-300) Practice Test 1

Microsoft Power BI is where data analysts turn scattered operational data into dashboards leaders actually open. Data scientists use the same reports to explain model results to nontechnical sponsors. The Microsoft Power BI Data Analyst Associate (PL-300) credential shows that work meets a recognized Microsoft standard. Benefits include a portable badge, stronger screening when postings prefer certified analysts, and a clearer interview story. These free Microsoft Power BI Data Analyst Associate Certification (PL-300) Practice Test 1 let you rehearse pacing before the official attempt. Teams at Microsoft, Amazon, and Deloitte hire analysts who ship this reporting. 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.

To get hired, you need proficiency in Tableau, SQL, SAS, and Azure, alongside data engineering skills in Snowflake, Databricks, and PySpark. Data science and AI expertise in TensorFlow, PyTorch, LLMs, and Generative AI are increasingly required.

Modern roles blend data analysis, engineering, and AI, demanding versatility.

Welcome to your Microsoft Power BI – Test-1

Name

Phone

Q1. You need to import 45 Excel files to Power BI Desktop. All these files are in a unique desktop local folder and share the same structure. You want to import all these Excel files into a single table. Which of the following would help you in achieving the goal?

Select 1 option(s):

A. Adding the folder data source; using the Append Queries command

B. Adding the folder data source; using the Combine Files Command

C. Adding every single file to the model and then using Merge Query Command

D. Adding the MS Excel Data Source; selecting all files of the folder

E. Adding a folder data source and using the Merge Queries Command

Q2. You have a 200 GB data warehouse that has data consolidated from several applications and runs on SQL Server 2017 Enterprise Edition. You notice that with your reports, there is a default limitation of eight daily refreshes. Your manager asks you to ensure that the reports are never more outdated than 1 hour. Which of the following can help you in achieving the same?

Select 1 option(s):

A. Building an application for monitoring the changes in the database and pushing them out utilizing the real-time streaming API

B. Migrating the content to Power BI Premium

C. Adding an SSAS tabular layer on top and enabling the Live connections

D. Convert to DirectQuery to access the data warehouse

Q3. Suppose you have developed a query named consumers in Power BI Desktop to append the rows from 3 external tables with consumer data into a single table consumer.

Now you want to ensure that each row in the consumer table has a unique ID value. Which of the following is the best way to add a new fabricated ID column to the consumer table?

Select 1 option(s):

A. Changing the data model by extending the consumers table with an Index column

B. Changing the data model by extending consumer table with a Counter column

C. Modifying the consumers query by adding an Index column

D. Modifying the consumers query by adding a Counter column

Q4. Why is it advised to avoid the NULL values in the numeric column?

Select 1 option(s):

A. DAX expression having SUM function on such data will provide incorrect results

B. DAX expression having MAX function on such data will provide incorrect results

C. DAX expression having an AVERAGE function on such data will provide incorrect results

D. DAX Expressions cant be applied if a numeric column has one or multiple NULL values

E. All the above

Q5. Consider the following table:

After you pivot the columns, the table appears as shown below:

As you can see, there is an Error in the 3rd row. How would you fix this error? The solution needs to preserve all the data.

Select 1 option(s):

A. For the key column, use Duplicate Values

B. Rename column3

C. Use Remove Errors for Column3

D. Modify the Data Type of the Value Column

E. Change the Aggregate Value Function of the Pivot

Q6. Which of the following are the valid reasons to design your data model as a star schema?

Select 4 option(s):

A. It makes it clear to the end-users or the report builders which business attributes or entities they can slice and dice by

B. Performance as filtering on dimension rows, which are fewer, is generally faster than filtering directly on a larger fact table

C. Star Schema minimizes data redundancy by avoiding the repetition of data values as much as possible

D. Only Models designed with Star Schema can be published to Power BI service

E. It permits one to many relationships, which is the most recommended relationship type in Power BI, between the tables

F. Having a Date dimension is a recommended practice methodology to perform time intelligence in Power BI

Q7. Consider the statement below.

Row Level Security cant be applied in Power BI Desktop while connecting via a Live connection to Analysis Services, these need to be set within the AS model.

Select 1 option(s):

A. True

B. False

Q8. You need to write a measure that will calculate the ratio of a month of sales in a year. Which of the following function can be used for the purpose?

Select 1 option(s):

A. FILTER

B. ALL

C. ENDOFYEAR

D. WHOLEYEAR

E. FIRSTDATE

Q9. Can you create a relationship between two columns having different DATA TYPE?

Select 1 option(s):

A. Yes, but the cardinality of the relationship needs to set as one to many

B. Yes, but the cardinality of the relationship needs to set as many to many

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

D. No, the columns in a relationship need to share the same data type

Q10. You need to configure a Gauge chart. Where would you set the goal for this?

Select 1 option(s):

A. Format Settings

B. Power Query

C. Calculated Column

D. DAX Expression

Q11. There is a table Registrations that have the Registration data for Ph.D scholars from scholars throughout the world. The below table shows the sample dataset:

Country Year No_of_registrations
US 2020 500
India 2020 350
UK 2020 450
New Zealand 2020 550
You try to develop a map to demonstrate the Registrations by Country, but you notice that the map does not work. How would you fix the map visualization?

Select 1 option(s):

A. By adding a column that has longitude and latitude

B. Choose the Country field and change the data category from the Modeling tab

C. Choose the Country field and change the data type from the Modeling tab

D. Create another table named Area and make a relationship between Area and Registrations Tables

Q12. You have several dashboards. You want to ensure that when the users browse the available dashboards from powerbi.com, they should be able to view which dashboards have personally identifiable information (PII). The solution needs to minimize the configuration efforts and effect on the dashboard design.

Which of the following would you use?

Select 1 option(s):

A. Tiles

B. Comment

C. Active Directory groups

D. Data Classifications

E. Feedback

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

Select 2 option(s):

A. You can configure the slicer visual based on the Date column to utilize slider controls

B. The use of a slicer visual on Power BI reports is to offer the report consumers with interactive filtering behavior

C. While adding a field to the Field Well of a slicer visual, you can use either a measure or a column

D. A slicer visual from the report can be pinned to a dashboard for making the dashboard interactive

E. All of the above

Q14. Which of the following elements can you set in a bookmark?

Select 3 option(s):

A. The visibility property of some selected visuals in the selection pane

B. The visibility property of all visuals in the selection pane

C. The visibility properties of fields in the report pane

D. The list of visual types available in the visualization pane

E. The sort order on any visualizations that have been set

Q15. You are working with Q&A visual to display the expensive items (that you know are defined in your store as Rate>$140). But when you type this as a question, you got it underlined in Red. What can be done to resolve this issue or get the expected outcome.

Select 3 option(s):

A. Go to Teach Q&A option in Q&A setup and define an adjective filter condition in Teach Q&A for defining the expensive items

B. Build the visual just demonstrating the items ( without any filter condition in the question) and after building the visual, apply a visual level filter on Rate

C. Build a calculated column or measure for expensive items using the filter condition in DAX and utilize it in the question

D. It is not possible to resolve such type of issues

E. These issues can be resolved but none of the given issues will resolve the problem

Q16. You need to create a histogram with a fixed number of bins in Power BI. Below are the few steps (given in improper sequence) that you need for creating the histogram.

a. Choose New Group
b. Enter the bin count
c. Choose the clustered column chart icon on the visualization Pane
d. In the Fields Pane, right-click the data field that you need to analyze
e. Set the Group type option to Bin and Bin Type option to Number of bins
f. Drag the new Field (Buckets) into the axis of your chart and apply count measure on values.
Choose the right sequence of the steps that you will follow. [Build the suitable visualization type first]

Select 1 option(s):

A. a-b-c-d-e-f

B. a-c-b-d-e-f

C. a-c-b-e-d-f

D. c-d-a-e-b-f

E. c-a-d-e-b-f

F. c-a-d-b-e-f

Q17. Consider the statement below.

The nodes in a decomposition tree (the fields through which the metric is analyzed by in the visuals) are fixed and can‘t be modified by the end-users viewing the report.

Select 1 option(s):

A. True

B. False

Q18. Which of the following reserved parameters respectively configure the start and end of where Incremental refresh should happen?

Select 1 option(s):

A. Start and End parameters

B. StartRange and EndRange parameters

C. RangeStart and RangeEnd parameters

D. RefreshStart and RefreshEnd parameters

E. StartRefresh and EndRefresh parameters

Q19. Your company is planning to utilize the Power BI Service to get multiple visualizations from data stored in a custom application.

The developers ask to push the data into the Power BI Service from the custom app.
How would you ensure this task?

Select 1 option(s):

A. Go to Office 365 Admin portal and register a web application

B. Go to app.powerbi.com and build an empty report

C. Go to tenant settings from the Power BI admin portal and set the API permissions

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

Q20. Which of the following cant be seen from the data lineage view in Power BI?

Select 1 option(s):

A. Where the dataflows are being utilized as a data source for datasets

B. The data sources that are being utilized by the dashboards/reports/datasets in a workspace

C. The credentials utilized to connect to datasets

D. Where gateways are being utilized as a data source for datasets

Q21. You decide to create a measure to accomplish the reporting requirement of the sales department. Which of the following formulas would you include in the measure?

Select 1 option(s):

A. SUM(Sales[sale_id])

B. COUNTROWS(Sales)

C. COUNTCOLUMNS(Sales)

D. COUNTA(Sales[sale_id])

Q22. Being the data administrator, you need to ensure that the sales managers are provided with the required access (as per the case study).

Which of the following solutions would you implement?

Select 1 option(s):

A. Creating a security role with a table filter on the table Sales_Managers where username = UserName()

B. Creating a security role with a table filter on the table Region_Managers where SM_id = UserPrincipalName()

C. Creating a security role with a table filter on the table Sales_Managers where name = UserName()

D. Creating a security role with a table filter on the table Sales_Managers where username = SM_id

Q23. As stated in the case study, Sales Executives need a visual that will demonstrate sales by region and for that purpose, you need to develop the required relationship? Which of the following changes would you make before creating the relationship?

Select 1 option(s):

A. Change the data type of sale_id column in the Sales table to Varchar

B. Change the data type of sale_id column in Sales table to Decimal

C. Change the data type of region_id column in the Sales table to a Decimal Number

D. Change the data type of region_id column in the Sales table to Integer

E. Add Sum(sale_amount) in the Sales table

Q24. Which of the following visualization charts would you create to meet the requirements of Sales Managers?

Select 1 option(s):

A. Pie Chart

B. KPI

C. Key influencers

D. Card

E. Funnel chart

Q25. You are supposed to create or manage the required relationships to accomplish the requirements of the customer services department. As you are confused about what relations should be created, you take advice from one of your friends. He advises you that one of the relations that you must create is:

One to many relationships between Dates[date_id] to Weekly_Return[week_id]
Will it help in meeting the goal?

Select 1 option(s):

A. Yes

B. No

Q26. After creating the profit and loss dataset, you want to ensure that the business analysts are able to view the required/appropriate profit and loss data. Here are some tasks (not necessarily in the right order) that you might need to perform to accomplish the goal.

a. From Power BI Desktop, create four roles
b. From BI Desktop, publish the dataset to powerbi.com
c. Using powerbi.com, add the specific role members to the defined roles.
d. Using Power BI Desktop, add a Table Filter – DAX Expression to the defined roles
Arrange the above-given tasks in the right order.

Select 1 option(s):

A. a-b-c-d

B. a-c-b-d

C. a-d-b-c

D. b-d-a-c

E. b-d-c-a

Q27. Fill in the blanks to complete the following DAX expression that can be used in the balance sheet reports to retrieve the ending balances.

.. (. (Balance Sheet [BalanceAmount]), ..( ‘Date‘[Date] ) )

Select 1 option(s):

A. CALCULATE, SUM and DATESQTD

B. CALCULATE, SUM and LASTDATE

C. SUM, CALCULATE and LASTDATE

D. CALCULATE, MAX and LASTDATE

Q28. You have been asked to grant the required access to the business analysts. How would you configure the permissions required in powerbi.com and permission for the loss and profit dataset respectively?

Select 1 option(s):

A. Assign the member role to the workspace and build permission for the loss and profit datasets

B. Assign the member role to the workspace and delete permission for the loss and profit datasets

C. Assign the member role to the workspace and reshare permission for the loss and profit datasets

D. Assign the viewer role to the workspace and build permission for the loss and profit datasets

E. Assign the viewer role to the workspace and delete permission for the loss and profit datasets

F. Assign the viewer role to the workspace and reshare permission for the loss and profit datasets

Q29. Complete the following DAX measure that you would create in the data model to only allow users to view projections at the proper level of granularity.

Total Projected Revenue = (NOT (. (Date [Date])), ..(Projection [Revenue Projection]))

Select 1 option(s):

A. IF, ISFILTERED and SUM

B. IF, KEEPFILTERED and SUM

C. IF, ISFILTERED and SUMX

D. ISFILTERED, IF and SUM

E. KEEPFILTERED, IF and SUM

Q3o. You want to calculate/ return the last day of the month in the BS data to make sure that the BS data can be related to the Date table. Which of the following type of calculations would you use?

Select 1 option(s):

A. A DAX calculated column

B. A DAX calculated measure

C. An M custom column

D. None of the above

Q31. To return the % of late orders, you need to create a suitable measure.

Complete the below given DAX expression to meet the goal.
Late orders percent=
VAR OrderCount=
COUNTROWS(Orders)
VAR LateOrders=
_____________ COUNTROWS(Orders), __________(orders, ______________)
RETURN
DIVIDE(LateOrders, OrderCount)

Select 1 option(s):

A. CALCULATE, FILTER and Orders[ShippedDate]>=Orders[RequiredDate]

B. CALCULATETABLE, FILTER and Orders[ShippedDate]>=Orders[RequiredDate]

C. CALCULATE, FILTER and Orders[ShippedDate]>Orders[RequiredDate]

D. FILTER, CALCULATE, and Orders[ShippedDate]=Orders[RequiredDate]

Q32. You have been asked to create an appropriate relationship in the dataset for RLS. What type of relationship would you create between the Sales Employees table and the Suppliers table?

Select 1 option(s):

A. One-to-one

B. Many-to-one

C. One-to-many

D. Many-to-many

Q33. As per the case study, you are supposed to create the Top Customers report. Which of the following type of filters would you use at the visual level to meet the goal?

Select 1 option(s):

A. Basic

B. Advanced

C. TOP N

D. UPPER N

Q34. You have been asked to create an On-Time Shipping report which must contain a visualization that demonstrates the % of late orders.

Which of the following type of visualization would you create?

Select 1 option(s):

A. Scatterplot

B. Pie chart

C. Funnel Chart

D. Bar chart

Q35. Is it possible to create a relationship between the two columns i.e ProductID column of the Order Details table and the ProductName column of the Products table?

Select 1 option(s):

A. Yes

B. No

Q36. You are working on the K sliding window for model training and stuck with the inference. You approach your manager to know how many data points at a minimum should be accessible from the source file to ensure valid outcomes at the time of inference. What did he suggest?

Select 1 option(s):

A. K+1 points

B. K-1 points

C. K*K points

D. K points

E. 1 point

Q37. There are several methods that can be used to fill/handle the missing values (known as nan) in the merged table. Which of the following fillNAMethod would you use to fill the nan with the padding value?

Select 1 option(s):

A. Linear

B. Previous

C. Padding

D. Subsequent

E. Zero

F. Fixed

Q38. While attempting to enable the security labels in Power BI, you receive an error message and are not able to enable the security labels. Which of the following might be the possible reason?

Select 1 option(s):

A. You dont have an Azure Information Protection license

B. Sensitivity labels havent been migrated to the MS Information Protection version that Power BI support

C. No MS Information Protection sensitivity labels are defined/specified in the organization

D. Any of the above

Q39. Microsoft Information Protection sensitivity labels allow the users to classify the sensitive/critical content in Power BI without affecting the productivity or the collaborating ability.

These Sensitivity labels can be applied to which of the following items in Power BI Service?

Select 1 option(s):

A. Only datasets

B. Only reports

C. Only dashboards

D. Only dataflows

E. Only datasets and reports

F. All including reports, datasets, dataflows, and dashboards

Q40. As only a limited number of summaries can be created, Smart Narratives considers only the most interesting stuff to summarize for the visual. Complete the sentence below by filling in the blanks.

Smart Narratives can create up to _______ summaries per visual and up to ______ summaries per page.

Select 1 option(s):

A. 1, 2

B. 1, 4

C. 4,1

D. 4, 16

E. 2, 8

Q41. While creating visuals for your Power BI dashboards, there is an opportunity to break down your visuals into slices called small multiples.

Which of the following options cover the full list of visuals supporting small multiples?

Select 1 option(s):

A. Bar, column and line

B. Doughnut, bar, area and line

C. Bar, column, area and line

D. Pie, doughnut, bar, line

Q42. For your Power BI dashboard, you have just created a pie chart visualizing the actual sales figures by region for the last year. In order to give decision makers a deeper insight, you want to extend the visual with a breakdown by countries. You decide to use the small multiples feature as a comfortable way of exploding visuals by a given dimension.

Is it a feasible solution?

Select 1 option(s):

A. Yes

B. No

Q43. You have just created a bar chart visualizing the actual sales figures by region for the past years. In order to give decision makers a deeper insight, you want to extend the visual with a breakdown by countries using the small visuals feature, and you also want to enhance it by showing the trend lines.

Is it a feasible way of solving the problem?

Select 1 option(s):

A. Yes because all the formatting options available for visuals also work for small multiples

B. No because adding trend lines to small multiples charts is currently not available

C. Yes because while many formatting options doesnt work for small multiples, trend lines can be applied with no limitation

D. No because bar charts cannot be broken down into small multiples

Q44. You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

Select 1 option(s):

A. Edit interactions in the report and set all interactions to Filter.

B. Pin each chart as a tile.

C. Edit the dashboard theme and pin each chart as a tile.

D. Pin the report page as a live tile.

Q45. You need to create a data model that includes multiple tables. Which tool should you use?

Select 1 option(s):

Power BI

Power Automate

Power Apps

Power Query

Q46. You want to show the relationship between two variables in a dataset. Which chart type would be best to use?

Select 1 option(s):

A. Scatter chart

B. Bar chart

C. Line chart

D. Pie chart

Q47. How can you ensure that datasets are up-to-date in Power BI?

Select 1 option(s):

A. Manually refresh each dataset

B. Use a scheduled refresh

C. Use a live connection to the data source

D. Use a direct query to the data source

Q48. You are building a Power BI report.Users will view the report by using their mobile device.You need to configure the report to display data based on each user‘s location.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. From Power Query Editor, detect the data types of the relevant columns.

B. In Data Category, set the geographic data category for the relevant columns.

C. Create a hierarchy for columns of the geography data type.

D. Use the columns of the geography data type in all visuals.

E. For the relevant columns, set synonyms to match common geographical terms.

Q49. What is the difference between a shared and a personal workspace in Power BI?

Select 1 option(s):

Shared workspaces can be accessed by multiple users

Personal workspaces can only be accessed by the owner

Shared workspaces can be edited by multiple users

Personal workspaces can be shared with other users

Q50. How can you ensure that only authorized users have access to a dataset in Power BI?

Select 1 option(s):

A. Use row-level security

B. Use column-level security

C. Use object-level security

D. Use workspace-level security

Q51. How can you manage permissions for a workspace in Power BI?

Select 1 option(s):

Add or remove members

Assign roles to members

Set permissions for specific reports

Delete a workspace

Q52. What is the purpose of the Power BI Gateway?

Select 1 option(s):

To allow users to connect to on-premises data sources

To allow users to create custom visuals

To allow users to share reports with others

To allow users to create dashboards

Q53. What is the purpose of the Power BI data model?

Select 1 option(s):

To provide a visual representation of data

To store data in a centralized location

To create reports and dashboards

To analyze data using DAX formulas

Q54. You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need to create a Power BI report that connects to the project management app.Which connector should you select?

Select 1 option(s):

A. Microsoft Teams Personal Analytics

B. SQL Server database

C. Dataverse

D. Dataflows

Q55. You have four sales regions. Each region has multiple sales managers.You implement row-level security (RLS) in a data model. You assign the relevant mail-enabled security group to each role.You have sales reports that enable analysis by region. The sales managers can view the sales records of their region. The sales managers are prevented from viewing records from other regions.A sales manager changes to a different region.You need to ensure that the sales manager can see the correct sales data.What should you do?

Select 1 option(s):

A. Change the Microsoft Power BI license type of the sales manager.

B. From Microsoft Power BI Desktop, edit the Row-Level Security setting for the reports.

C. Manage the permissions of the underlying dataset.

D. Request that the sales manager be added to the correct Azure Active Directory group.

Power BI Data Analyst Associate Certification (PL-300) Practice Test 1

Q1. You need to import 45 Excel files to Power BI Desktop. All these files are in a unique desktop local folder and share the same structure. You want to import all these Excel files into a single table. Which of the following would help you in achieving the goal?

Q3. Suppose you have developed a query named consumers in Power BI Desktop to append the rows from 3 external tables with consumer data into a single table consumer.

Q4. Why is it advised to avoid the NULL values in the numeric column?

Q5. Consider the following table:

Q6. Which of the following are the valid reasons to design your data model as a star schema?

Q7. Consider the statement below.

Q8. You need to write a measure that will calculate the ratio of a month of sales in a year. Which of the following function can be used for the purpose?

Q9. Can you create a relationship between two columns having different DATA TYPE?

Q10. You need to configure a Gauge chart. Where would you set the goal for this?

Q11. There is a table Registrations that have the Registration data for Ph.D scholars from scholars throughout the world. The below table shows the sample dataset:

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

Q14. Which of the following elements can you set in a bookmark?

Q15. You are working with Q&A visual to display the expensive items (that you know are defined in your store as Rate>$140). But when you type this as a question, you got it underlined in Red. What can be done to resolve this issue or get the expected outcome.

Q16. You need to create a histogram with a fixed number of bins in Power BI. Below are the few steps (given in improper sequence) that you need for creating the histogram.

Q17. Consider the statement below.

Q18. Which of the following reserved parameters respectively configure the start and end of where Incremental refresh should happen?

Q19. Your company is planning to utilize the Power BI Service to get multiple visualizations from data stored in a custom application.

Q20. Which of the following cant be seen from the data lineage view in Power BI?

Q21. You decide to create a measure to accomplish the reporting requirement of the sales department. Which of the following formulas would you include in the measure?

Q22. Being the data administrator, you need to ensure that the sales managers are provided with the required access (as per the case study).

Q23. As stated in the case study, Sales Executives need a visual that will demonstrate sales by region and for that purpose, you need to develop the required relationship? Which of the following changes would you make before creating the relationship?

Q24. Which of the following visualization charts would you create to meet the requirements of Sales Managers?

Q26. After creating the profit and loss dataset, you want to ensure that the business analysts are able to view the required/appropriate profit and loss data. Here are some tasks (not necessarily in the right order) that you might need to perform to accomplish the goal.

Q27. Fill in the blanks to complete the following DAX expression that can be used in the balance sheet reports to retrieve the ending balances.

Q28. You have been asked to grant the required access to the business analysts. How would you configure the permissions required in powerbi.com and permission for the loss and profit dataset respectively?

Q29. Complete the following DAX measure that you would create in the data model to only allow users to view projections at the proper level of granularity.

Q3o. You want to calculate/ return the last day of the month in the BS data to make sure that the BS data can be related to the Date table. Which of the following type of calculations would you use?

Q31. To return the % of late orders, you need to create a suitable measure.

Q32. You have been asked to create an appropriate relationship in the dataset for RLS. What type of relationship would you create between the Sales Employees table and the Suppliers table?

Q33. As per the case study, you are supposed to create the Top Customers report. Which of the following type of filters would you use at the visual level to meet the goal?

Q34. You have been asked to create an On-Time Shipping report which must contain a visualization that demonstrates the % of late orders.

Q35. Is it possible to create a relationship between the two columns i.e ProductID column of the Order Details table and the ProductName column of the Products table?

Q36. You are working on the K sliding window for model training and stuck with the inference. You approach your manager to know how many data points at a minimum should be accessible from the source file to ensure valid outcomes at the time of inference. What did he suggest?

Q37. There are several methods that can be used to fill/handle the missing values (known as nan) in the merged table. Which of the following fillNAMethod would you use to fill the nan with the padding value?

Q38. While attempting to enable the security labels in Power BI, you receive an error message and are not able to enable the security labels. Which of the following might be the possible reason?

Q39. Microsoft Information Protection sensitivity labels allow the users to classify the sensitive/critical content in Power BI without affecting the productivity or the collaborating ability.

Q40. As only a limited number of summaries can be created, Smart Narratives considers only the most interesting stuff to summarize for the visual. Complete the sentence below by filling in the blanks.

Q41. While creating visuals for your Power BI dashboards, there is an opportunity to break down your visuals into slices called small multiples.

Q44. You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

Q45. You need to create a data model that includes multiple tables. Which tool should you use?

Q46. You want to show the relationship between two variables in a dataset. Which chart type would be best to use?

Q47. How can you ensure that datasets are up-to-date in Power BI?

Q49. What is the difference between a shared and a personal workspace in Power BI?

Q50. How can you ensure that only authorized users have access to a dataset in Power BI?

Q51. How can you manage permissions for a workspace in Power BI?

Q52. What is the purpose of the Power BI Gateway?

Q53. What is the purpose of the Power BI data model?

Q54. You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.You need to create a Power BI report that connects to the project management app.Which connector should you select?

Q20. Which of the following cant be seen from the data lineage view in Power BI?