Microsoft Power BI

Free Questions for Microsoft Power BI Data Analyst Exam (PL-300)

Are you ready to put your data analysis skills to the test and become a certified Microsoft Power BI Data Analyst? Look no further! Here we provide some updated free questions on Microsoft Power BI Data Analyst Exam (PL-300) exam.

You can utilize those free questions to get familiar with the real exam concepts. With these free questions, you can be able to demonstrate your skills and knowledge on data analysis using Microsoft Power BI tools.

By knowing how to work with Power BI, you can help out the business to eliminate risks like data breaches and malware threats.

So, let’s dive in and unlock the power of Power BI!

Prerequisites for Microsoft Power BI Data Analyst

Even though there are no formal pre-requisites needed to clear the PL-300 exam, Microsoft recommended some of the skills to be acquired before appearing the exam and they are:

  • Proficiency in fundamental data concepts.
  • Expertise in managing relational data within cloud environments.
  • Proficiency in handling non-relational data in cloud-based settings.
  • Understanding of data analysis and visualization principles.

Salary and Scope of Microsoft Power BI Data Analyst

If you are a Microsoft Power BI certified data analyst, then you will earn a salary of $91,000 p.a. And if you level up practical knowledge and skills, you can make it up to as high as $134,000.

Microsoft Power BI
Dataflair.com

A recent survey found that around 18K+ businesses use Power BI, accounting for 5.8% of the market. Soon, Power BI will rank among the most popular products. One of the primary features of this is that it functions and appears like an advanced version of Excel, making it simple and adaptable for users to use without too many problems.

Making a career in the field of Power BI is expected to be one of the most in-demand careers globally in the near future.

Microsoft Power BI Data Analyst Exam (PL-300) certification Free Questions

Here, we have covered some domains that are vital for clearing the Microsoft Power BI Data Analyst Exam (PL-300) exam and they are:

Domain: Model the data

Question 1: Consider the below-given sample data:

Date Day Month
2021-02-01 1 2
2021-02-02 2 2
2021-02-03 3 2
2021-02-04 4 2

You need to create a calculated column to show the date in a format like this February 01, 2021. Which of the following DAX expressions would you use?

A. FORMAT([Date],”M”)|| FORMAT([Date],”D”)|| FORMAT([Date],”Y”)
B. FORMAT([Date],”MMMM DD, YYYY”)
C. FORMAT([Date],”MMM”)|| FORMAT([Date],”DD”)|| FORMAT([Date],”YYYY”)
D. FORMAT(‘Date_Table’ [Date],”MMM”)|| FORMAT(‘Date_Table’ [Date],”DD”)|| FORMAT(‘Date_Table’ [Date],”YYYY”)

Correct Answer: B

Explanation

“MMMM” is a user-defined format for date/time that displays the full month name as the month.  FORMAT([Date],”MMMM DD, YYYY”) is the right DAX expression.

Option A is incorrect. The given DAX expression is not correct to show the date in the required format.

Option B is correct. FORMAT([Date],”MMMM DD, YYYY”) is the right DAX expression to show the date in the required format.

Option C is incorrect. The given DAX expression is not correct to show the date in the required format.

Option D is incorrect. The given DAX expression is not correct to show the date in the required format.

Reference:

Check the full custom date and time formats list for the FORMAT function here: https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function

Domain: Model the data

Question 2: You have been provided with the sales data of ABC company for the years 2005-2020 and asked to build a measure that will calculate the total sale for all years up to 2015, multiplied by a fixed multiplier. For the years 2005-2010, the multiplier was 15% and for the years 2010-2015, it was 25%.

Fill in blanks by selecting the right sequence of the words from the given option to create the required measure.

= …………… (
     ……….. (……………… (‘Date’[year]),      
  ‘Date’[year]<2015)
     ),
     ……………(‘Date’[year]>=2010,
                  [Sales Amount]*1.2,
                  [Sales Amount]*1.1)
        )
)

A. FILTER, SUM, VALUES, TABLE
B. SUMX, FILTER, VALUES, IF
C. IF, VALUES, CONCATENATE, TABLE
D. IF, TABLE, SUM, FILTER
E. SUM, FILTER, IF, VALUES

Correct Answer: B

Explanation

The following is the correct DAX expression for the required purpose:

Option A is incorrect. The given sequence FILTER, SUM, VALUES, TABLE is not the correct answer.
Option B is correct. The given sequence SUMX, FILTER, VALUES, IF is the correct answer.
Option C is incorrect. The given sequence IF, VALUES, CONCATENATE, TABLE is not the correct answer.
Option D is incorrect. The given sequence IF, TABLE, SUM, FILTER is not the correct answer.
Option E is incorrect. The given sequence SUM, FILTER, IF, VALUES is not the correct answer.

Reference:

To know more about the DAX functions, please refer to the link below: https://docs.microsoft.com/en-us/dax/

Domain: Model the data

Question 3: The data model has an impact on the time consumed in the refreshing of a model but once the model is loaded in the memory, it has no impact on the performance of the reports.

A. True
B. False

Correct Answer: B

Explanation

In the case of a large data model, the measures need to iterate over more data and therefore the evaluation is likely to consume more time that will certainly affect the performance of the reports.  Therefore, reducing the size of the data model by removing the unnecessary rows or columns will help in improving the performance of the reports.

Reference:

To know more about the optimization, please refer to the link below: https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization?WT.mc_id=DP-MVP-5003635

Domain: Visualize and analyze the data

Question 4: 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?

A. A different version of R was used to build the visual
B. The data was duplicated
C. The data originates from a Microsoft SQL Server source
D. The number of records to be shown were higher than the capacity of R visuals

Correct Answer: D

Explanation

There are a number of limitations of R visuals in Power BI Services and data size limitation is one of them. Data considered by the R visuals for plotting is limited to 1,50,000 rows. If the users select more than 1,50,000 rows, only the top 1,50,000 rows are considered and a message is shown on the image. Also, there is a limit of 250 MB for the input data.

Option A is incorrect. Using the different versions of R can’t be the possible reason behind showing the details for only a few students, not all.
Option B is incorrect. As each student_id is unique, the data can’t be duplicated.
Option C is incorrect. The data that originates from a Microsoft SQL Server source is not the potential cause of the issue.
Option D is correct. Data considered by the R visuals for plotting is limited to 1,50,000 rows. If the users select more than 1,50,000 rows, only the top 1,50,000 rows are considered.

Reference:

To know more about the R Visuals, please refer to the link below: https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

Domain: Visualize and analyze the data

Question 5: Which of the following statements are true for Power BI paginated reports?

A. Power BI paginated reports are created using Power BI Desktop
B. Power BI paginated reports are created using Power BI Service
C. Power BI paginated reports are created using Power BI Report Builder
D. Power BI paginated reports are descendants of SQL Server Reporting Services
E. Power BI paginated reports are descendants of SQL Server Analysis Services

Correct Answers: C and D

Explanation

Paginated reports provide a pixel-perfect view of the data which means that you have total control of how the report renders. Power BI paginated reports are created using Power BI Report Builder and are descendants of SQL Server Reporting Services.

Option A is incorrect as Power BI paginated reports are created using Power BI Report Builder, not Power BI Desktop.
Option B is incorrect as Power BI paginated reports are created using Power BI Report Builder, not Power BI Service.
Option C is correct as Power BI paginated reports are created using Power BI Report Builder.
Option D is correct as Power BI paginated reports are descendants of SQL Server Reporting Services.
Option E is incorrect as Power BI paginated reports are descendants of SQL Server Reporting Services, not SQL Server Analysis Services.

Reference:

To know more about the Power BI paginated reports, please refer to the link below: https://docs.microsoft.com/en-us/learn/modules/create-paginated-reports-power-bi/1-introduction

Domain: Prepare the Data

Question 6. Which of the following data sources can be connected through the “Get Data” option in the Power BI Desktop?

  1. Power BI datasets
  2. Power BI dataflows
  3. Power BI Template Apps
  4. All of the above

Correct Answer: D

Explanation: Here is the snapshot for the most common data types that are possible to connect with:

Options A, B and C are the data sources that can be connected through the “Get Data” option in the Power BI Desktop.

Reference:

Domain: Prepare the Data

Question 7: For the query opened in Power Query Editor, you are interested in finding out the percentage of empty cells or values in each column as soon as possible. Which of the following data Preview Options would you select?

  1. Column profile
  2. Show Whitespaces
  3. Column quality
  4.  Column distribution

Correct Answer: C

Explanation:  In Power Query Editor, Column Quality, Column distribution, and Column Profile are data profiling functionalities under the View tab in Data Preview Section. These functionalities help in understanding the data anomalies and statistics. Out of these three functionalities, Column quality is the one that can be used to show the percentages of data that is in error, empty and valid. 

Option A is incorrect. The Column profile provides a deeper look into the statistics within the column. This column can be used to provide many different values like the count of rows but it does not help in identifying the percentage of empty cells in the column. 

Option B is incorrect. Using Column Quality, not Show Whitespaces, is the correct option.

Option C is correct. Column quality is the data preview option that is used to show the percentages of data that is in error, empty and valid. 

Option D is incorrect. Column distribution displays the data distribution within the column and the counts of unique and distinct values. It is not the right choice for the target goal.

Reference: To know more about the Profile Data, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/clean-data-power-bi/6-profile-data

Domain: Prepare the Data

Question 8. Consider the below two tables Students and Area. In table Students, Registration_id is unique and in table Area, Region_id is unique; both respecting a unique row in respective tables.  

Students

Name Registration_id Grade Region_id
Aron 13456 A 1010
Frank 13457 B+ 1026
Adam 13458 A+ 1067
Steve 13459 C   1010

 

Area

Region_id Country
1010 USA
1026 USA 
1067 UK

You are interested in creating a query that will have one row for each student and besides Name, Registration_id, Grade, Region_id, each row should also include the country of the student.  Which of the following will help in achieving the goal?

  1. Append the Students and Area tables
  2. Transpose both students and Area tables
  3. Merge the Students and Area tables
  4. Group the Students and Area table on Region_id column
  5. Apply intersection operations on the students and Area tables.

Correct Answer: C

Explanation: Merge and Append are two main methods of combining the queries.

Merge is the operation that is used to combine the data from multiple tables into one single table depending upon the common column between both tables. Append is the operation that is performed to add up the additional rows of a table into the existing one.

Option A is incorrect. To Append the Students and Area tables is not the right option. Instead, the tables Students and Area should be merged. 

Option B is incorrect. To Transpose both students and Area tables won’t help in achieving the whole information of the students in one table. 

Option C is correct. You need to merge the tables Students and Area to have the whole details of the students including the country in one query. 

Option D is incorrect. Grouping the Students and Area table on the Region_id column is not the right choice. Rather, the students and Area should be merged.

Option E is incorrect. Apply intersection operations on the students and Area tables is not the right choice. Rather, the Students and Area should be merged.

Reference: To know more about the Combining tables, please refer to the link below:

 https://docs.microsoft.com/en-us/learn/modules/clean-data-power-bi/5-combine-tables

Domain: Model the Data

Question 9. Which of the following statements are true about data granularity? (Select Multiple Options)

  1. Data granularity represents the level of the details represented within the data.
  2. Data granularity represents the relationships among the various data entities.
  3. Data granularity represents the type of values contained by the data
  4. Higher data granularity, greater the level of detail within the data.
  5. Higher data granularity, high domain range for the data

Correct Answer: A and D

Explanation: Data granularity represents the level of the details represented within the data and therefore is an important concept in data analysis. Higher data granularity represents a greater level of details.  It is very important to define the right data granularity level as it greatly affects the usability and performance of Power BI reports and visuals.

Option A is correct. Data granularity represents the level of the details represented within the data.

Option B is incorrect. Data granularity represents the level of the details represented within the data; not the relationships among the various data entities.

Option C is incorrect. Data granularity represents the level of the details represented within the data; not the type of values contained by the data.

Option D is correct. Higher data granularity represents a greater level of details.

Option E is incorrect. Data granularity represents the level of the details; not the domain values.

Reference: To know more about the data granularity, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/design-model-power-bi/5-data-granularity

Domain: Model the Data

Question 10: Consider the below-given sample data:

Date Day Month
2021-02-01 1 2
2021-02-02 2 2
2021-02-03 3 2
2021-02-04 4 2

You need to create a calculated column to show the date in a format like this February 01, 2021. Which of the following DAX expression would you use?

  1. FORMAT([Date],”M”)|| FORMAT([Date],”D”)|| FORMAT([Date],”Y”)
  2. FORMAT([Date],”MMMM DD, YYYY”)
  3. FORMAT([Date],”MMM”)|| FORMAT([Date],”DD”)|| FORMAT([Date],”YYYY”)
  4. FORMAT(‘Date_Table’ [Date],”MMM”)|| FORMAT(‘Date_Table’ [Date],”DD”)|| FORMAT(‘Date_Table’ [Date],”YYYY”)

Correct Answer: B

Explanation:  “MMMM” is a user-defined format for date/time that displays the full month name as the month.  FORMAT([Date],”MMMM DD, YYYY”) is the right DAX expression

Option A is incorrect. The given DAX expression is not correct to show the date in the required format.

Option B is correct. FORMAT([Date],”MMMM DD, YYYY”) is the right DAX expression to show the date in the required format. 

Option C is incorrect. The given DAX expression is not correct to show the date in the required format.

Option D is incorrect. The given DAX expression is not correct to show the date in the required format.

Reference: Check the full custom date and time formats list for the FORMAT function here:

https://docs.microsoft.com/en-us/dax/custom-date-and-time-formats-for-the-format-function

Domain: Model the Data

Question 11.  You have been provided with the sales data of ABC company for the years 2005-2020 and asked to build a measure that will calculate the total sale for all years up to 2015, multiplied by a fixed multiplier. For the years 2005-2010, the multiplier was 15% and for the years 2010-2015, it was 25%.

Fill in blanks by selecting the right sequence of the words from the given option to create the required measure.

= …………… ( 

        ……….. (……………… (‘Date’[year]),       

     ‘Date’[year]<2015)

        ), 

        ……………(‘Date’[year]>=2010,

                     [Sales Amount]*1.2,

                     [Sales Amount]*1.1)

           )

  1. FILTER, SUM, VALUES, TABLE
  2. SUMX, FILTER, VALUES, IF
  3. IF, VALUES, CONCATENATE, TABLE
  4. IF, TABLE, SUM, FILTER

Correct Answer: B

Explanation: The following is the correct DAX expression for the required purpose:

Option A is incorrect. The given sequence FILTER, SUM, VALUES, TABLE is not the correct answer.

Option B is correct. The given sequence SUMX, FILTER, VALUES, IF is the correct answer.

Option C is incorrect. The given sequence IF, VALUES, CONCATENATE, TABLE is not the correct answer.

Option D is incorrect. The given sequence IF, TABLE, SUM, FILTER is not the correct answer.

Option E is incorrect. The given sequence SUM, FILTER, IF, VALUES is not the correct answer.

Reference: To know more about the DAX functions, please refer to the link below:

https://docs.microsoft.com/en-us/dax/

Domain: Model the Data

Question 12.  The data model has an impact on the time consumed in the refreshing of a model but once the model is loaded in the memory, it has no impact on the performance of the reports. Select whether the statement is True/False. 

  1. True
  2. False

Correct Answer: B

Explanation: In the case of a large data model, the measures need to iterate over more data and therefore the evaluation is likely to consume more time that will certainly affect the performance of the reports.  Therefore, reducing the size of the data model by removing the unnecessary rows or columns will help in improving the performance of the reports. 

Reference: To know more about the optimization, please refer to the link below:

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization?WT.mc_id=DP-MVP-5003635

Domain: Visualize the Data

Question 13. 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?

  1. A different version of R was used to build the visual
  2. The data was duplicated
  3. The data originates from a Microsoft SQL Server source
  4. The number of records to be shown were higher than the capacity of R visuals

Correct Answer: D

Explanation: There are a number of limitations of R visuals in Power BI Services and data size limitation is one of them. Data considered by the R visuals for plotting is limited to 1,50,000 rows. If the users select more than 1,50,000 rows, only the top 1,50,000 rows are considered and a message is shown on the image. Also, there is a limit of 250 MB for the input data.

Option A is incorrect. Using the different versions of R can’t be the possible reason behind showing the details for only a few students, not all.

Option B is incorrect. As each student_id is unique, the data can’t be duplicated. 

Option C is incorrect. The data that originates from a Microsoft SQL Server source is not the potential cause of the issue.

Option D is correct. Data considered by the R visuals for plotting is limited to 1,50,000 rows. If the users select more than 1,50,000 rows, only the top 1,50,000 rows are considered.

Reference: To know more about the R Visuals, please refer to the link below:

https://docs.microsoft.com/en-us/power-bi/visuals/service-r-visuals

Question 14.  Which of the following statements are true for Power BI paginated reports? (Select Multiple Options)

  1. Power BI paginated reports are created using Power BI Desktop.
  2. Power BI paginated reports are created using Power BI Service.
  3. Power BI paginated reports are created using Power BI Report Builder.
  4. Power BI paginated reports are descendants of SQL Server Reporting Services 
  5. Power BI paginated reports are descendants of SQL Server Analysis Services

Correct Answer: C and D

Explanation: Paginated reports provide a pixel-perfect view of the data which means that you have total control of how the report renders. Power BI paginated reports are created using Power BI Report Builder and are descendants of SQL Server Reporting Services.

Option A is incorrect as Power BI paginated reports are created using Power BI Report Builder, not Power BI Desktop.

Option B is incorrect as Power BI paginated reports are created using Power BI Report Builder, not Power BI Service.

Option C is correct as Power BI paginated reports are created using Power BI Report Builder.

Option D is correct as Power BI paginated reports are descendants of SQL Server Reporting Services.

Option E is incorrect as Power BI paginated reports are descendants of SQL Server Reporting Services, not SQL Server Analysis Services. 

Reference: To know more about the Power BI paginated reports, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/create-paginated-reports-power-bi/1-introduction

Domain: Visualize the Data

Question 15. Which of the following statements are true for dashboards and reports? (Select Multiple Options)

  1. Dashboards can have only a single page while reports can have multiple pages
  2. Reports can have only a single page while Dashboards can have multiple pages
  3. Both Dashboards and Reports can have multiple pages
  4. Both reports and dashboards can be refreshed to display the latest data
  5. Dashboards can be refreshed to display the latest data while the reports can’t
  6. Reports can be refreshed to display the latest data while the Dashboards can’t

Correct Answer: A and D

Explanation: The key similarities and differences between the reports and dashboards are:

  1. A Dashboard can be created from many datasets or reports.
  2. Dashboards do not consist of Visualization, Filter, and Fields panes that are available in Power BI Desktop which means it is not possible to add new filters and slicers or make edits.
  3. Dashboards can have only a single page while reports can have multiple pages.
  4. The underlying dataset can’t be seen directly in a dashboard, while it is possible to see the dataset in the report under the Data tab in Power BI Desktop.
  5. Both reports and dashboards can be refreshed to display the latest data.

Option A is correct as Dashboards can have only a single page while reports can have multiple pages.

Option B is incorrect as these are the dashboards, not the reports, that can have only a single page while the reports, not the dashboards, can have multiple pages.

Option C is incorrect as only the reports can have multiple pages while the dashboards can have only a single page.

Option D is correct as Both reports and dashboards can be refreshed to display the latest data.

Option E is incorrect as both reports and dashboards can be refreshed to display the latest data.

Option F is incorrect as both reports and dashboards can be refreshed to display the latest data.

Reference: To know more about the Reports and Dashboards, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/create-dashboards-power-bi/1-introduction

Question 16.  You have created a dashboard with the help of Microsoft Power BI Service. The dashboard has a card visual that displays the total sales from the last year.

You provide users access to the dashboard through the Viewer role on the workspace.

A user is interested in receiving daily notifications for the number displayed on the card visual. Which of the following is the right choice to automate the notifications?

  1. Creating a data alert.
  2. Sharing the dashboard to the user.
  3. Creating a subscription.
  4. Tagging the user in a comment.

Correct Answer: C

Explanation: You can subscribe your mates and yourself to the dashboards, report pages, and paginated reports that are significant to you. Power BI e-mail subscription allows you to choose how frequently you are interested in receiving the emails: monthly, weekly, daily, hourly, or once a day after the initial data refresh and even the time you are interested in receiving the email if you select monthly, weekly, daily or hourly.

Option A is incorrect. Creating a data alert is not the right option. Data alerts are created to notify you when the data in the dashboard is changed beyond the limits set by you.

Option B is incorrect.  Sharing the dashboard to the user is not the right option to automate the notifications.

Option C is correct. Creating a subscription will help in automating the notification on daily basis for the number displayed on the card visual.

Option D is incorrect. Tagging the user in a comment is not the right option.

References: To know more about the data alerts and subscriptions, please refer to the links below:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe

 https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts

Domain: Visualize the Data

Question 17.  What is the unique benefit of using a customized tooltip?

  1. With a customized tooltip, any image or color can be set as the background for the visual
  2. It can demonstrate the value and category of the data points
  3. It can demonstrate the images, visuals, and any other collection of items that are created by the user on the report page
  4. With a customized tooltip, a border can be created around the visual for isolating the visual from other elements on the canvas.

Correct Answer: C

Explanation: Tooltips is an amazing feature that provides more contextual detail and information to data points on a visual.  The default tooltips display the value and category of data points but the customized tooltips can also include the images, visuals, and any other collection of items that the users create on the report page. 

Option A is incorrect. It is the background section, not the tooltips, that allows setting any image or color as the background for the visual.

Option B is incorrect as demonstrating the value and category of the data points is not the unique feature of customized tooltips. Even the default tooltip displays the value and category of the data points.

Option C is correct. The main benefit of a customized tooltip is that it can demonstrate the images, visuals, and any other collection of items that are created by the user on the report page

Option D is incorrect. It is the border section, not the tooltips section, that allows setting a border around the visual for isolating the visual from other elements on the canvas.

Reference: To know more about the visuals in Power BI, please refer to the link below:

 https://docs.microsoft.com/en-us/learn/modules/visuals-power-bi/4-format

Question 18. You have created a line visual that displays the number of students getting scholarships over time. Now, you are interested in seeing the total scholarship cost of the students when you hover over a data point. Which of the following are the possible options to accomplish this goal? (Select Multiple Options)

  1. Add a Scholarship_amount to the Tooltips
  2. Add a Scholarship_amount to the drill through fields
  3. Add a Scholarship_amount to the Visual Filters
  4. None of the above

Correct Answer: A and C

Explanation: Customized Tooltips and Visual Filters help the users by providing them with additional information and context about the visuals.  Scholarship_amount can be added to either Tooltips or Visual Filters to see the total scholarship cost of the students.

Option A is correct. Tooltips bring an amazing feature that provides more contextual detail and information to data points on a visual.  The default tooltips display the value and category of data points but the customized tooltips can also include the images, visuals, and any other collection of items that the users create on the report page.  Custom tooltips allow the users to specify additional data points that show as part of the tooltip. To achieve the targeted goal of seeing the total scholarship cost of the students, Scholarship_amount can be added to the Tooltips.

Option B is incorrect. Drill through field in Power BI allows creating a report page that emphasizes a particular entity like students, instructors, course, etc. While using the drill through, the report readers right-click a data point in other pages of the reports and drill through to the target or focused page to retrieve the details filtered to that context. A button can also be created that drills through to details after clicking it.

Option C is correct. Visual Filters are applied to a single visual or tile on a report page. only visual level filters selected visuals are shown on the report canvas. Adding a Scholarship_amount to the Visual Filters is the right option to see the total scholarship cost of the student.

Option D is incorrect. Add a Scholarship_amount to the Tooltips and Add a Scholarship_amount to the Visual Filters are the right choices to see the total scholarship cost of the student.

References: To know more about the Tooltips and Filters, please refer to the links below:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-tooltips

https://docs.microsoft.com/en-us/learn/modules/data-driven-story-power-bi/6-advanced-interactions

Domain: Analyze the Data

Question 19. Which of the following chart is the great choice to identify or display the outliers?

  1. Line Chart
  2. Scatter Chart
  3. Bar chart
  4. Donut chart

Correct Answer: B

Explanation: Scatter chart is the best choice to identify the outliers in the data. After identification of the outliers, the reasons for their existence can be investigated or explored and corrective action is taken. The following is an example of a “Scatter chart” that shows the number of orders by Orders Shipped by Product Category. 

Option A is incorrect as Line charts are not appropriate to display the outliers. Scatter charts are the better choice.

Option B is correct as the Scatter chart is a good choice to display the outliers.

Option C is incorrect as Bar charts are not appropriate to display the outliers. Scatter charts are the better choice.

Option D is incorrect as the Scatter chart, not Donut charts, are a good choice to display the outliers.

Reference:  To know more about the visuals, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/perform-analytics-power-bi/3-visuals

Domain: Analyze the Data

Question 20. You need to create a report that will demonstrate the sales performance of the company. The sales team has requested you to add a single visualization (if possible) that might help them in identifying the factors that drive the sales and affect the success.   Which of the following visualization would you use?

  1. Key influencers
  2. Funnel chart
  3. Donut Chart
  4. Q&A visualization

Correct Answer: A

Explanation: key influencers are a specific type of visuals that help in identifying the factors that drive the target matric. It analyzes the given data, ranks the factors that matter, and shows them as key influencers.  The two most important scenario where key influencers do great are : 

  • To see the factors that affect the metric being analyzed.
  • To contrast the relative importance of the identified factors. 

Option A is correct as Key influencers are a good choice to identify what factors drive the sale and affect the success.

Option B is incorrect. The funnel charts display a linear process that consists of sequential connected stages and the items flow sequentially from one stage to the next stage. They don’t help in identifying the factors that affect a metric.

Option C is incorrect. Donut charts represent the data by dividing it into slices and are not helpful in identifying the key factors.

Option D is incorrect. Q&A visualizations allow the users to ask natural language questions and get answers in the form of a visual. 

References: To know more about the visuals, please refer to the links below:

https://docs.microsoft.com/en-us/learn/modules/visuals-power-bi/3-effective-visualization

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

Domain: Deploy and Maintain Deliverables

Question 21.  Promotion and certification are two ways to endorse dataset. Which of the following statements are true about Promotion and Certification? (Select Multiple Options)

  1. Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset.
  2. Promotion needs permission from the dataset owner or admin to access the dataset whereas Certification does not require specific permissions from the admin, whereas Certification.
  3. In terms of permission, there is no difference between promotion and certification.
  4. Certification is the ideal way to endorse the dataset when the dataset is ready for broad usage.
  5. Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage.

Correct Answer: A and E

Explanation: Promotion and certification are two ways to endorse dataset. Promote datasets when they are ready for broad usage. To promote the dataset, there is only a need of write permission. Any workspace member having Write permission can promote the datasets. In certification, Request certification for the promoted datasets from an admin user that is given in the Dataset Certification tenant admin setting.   Certification enhances the security of the dataset.  It is a quite selective process that ensures that only truly reliable and authoritative datasets are utilized across the organization.

Option A is correct. Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset.

Option B is incorrect. It is the certification that needs permission from the dataset owner or admin. Any workspace member having the write permission can promote the database. It does not need any permission from the database owner.

Option C is incorrect. Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset.

Option D is incorrect. It is the promotion, not a certification, that is the ideal to endorse the dataset when the datasets are ready for broad usage.

Option E is correct. Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage.

Reference: To know more about Managing Datasets, please refer to the link below:

 https://docs.microsoft.com/en-us/learn/modules/manage-datasets-power-bi/7-manage-datasets

Domain: Deploy and Maintain Deliverables

Question 22. Which of the following is not the feature of the “Lineage view” in Power BI?

  1. It allows the users to troubleshoot the flow of data from its source to its destination.
  2. It allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports.
  3. It simplifies the task of identifying the dashboards and reports that haven’t been refreshed.
  4. It helps in analyzing the data sets and finding the patterns, trends, and outliers.

Correct Answer: D

Explanation: The Lineage view is a great feature in Power BI that quickly refreshes the datasets and allows the users to see the relationships between the artifacts in a workspace and their external dependencies.  This view is quite crucial in Power BI as

  • It simplifies the troubleshooting process. The users can see the path taken by the data from source to destination and identify the pain points and bottlenecks.
  • It allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports.
  • It simplifies the task of identifying the dashboards and reports that haven’t been refreshed. 

Option A is incorrect as the Lineage view allows the users to troubleshoot the flow of data from its source to its destination. In this view, the users can see the path taken by the data from source to destination and identify the pain points and bottlenecks.

Option B is incorrect as the Lineage view in Power BI allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports.

Option C is incorrect as the Lineage view simplifies the task of identifying the dashboards and reports that haven’t been refreshed.

Option D is correct as it is the Quick Insights feature of Power BI, not Lineage view, that helps in analyzing the data sets and finding the patterns, trends, and outliers.

Reference: To know more about the Lineage view, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/5-troubleshoot-data

Domain: Deploy and Maintain Deliverables

Question 23. 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?

  1. Power BI Desktop
  2. Power BI Desktop optimized for Report Server
  3. Power BI desktop optimized for Paginated reports
  4. Power BI Report Builder

Correct Answer: B

Explanation: To develop the Power BI reports for Power BI Report Server, you need to download, install and use the version of the Power BI Desktop that is optimized for the Power BI Report Server.

Option A is incorrect. Using Power BI Desktop is not the correct answer. The Power BI Desktop needs to be optimized for the Report Server.

Option B is correct. Using Power BI Desktop optimized for Report Server is the right tool that needs to be used to create the Power BI reports for Power BI Report Server.

 Option C is incorrect. Power BI desktop optimized for Paginated reports is not the right tool for the purpose.

Option D is incorrect. Power BI Desktop optimized for Report Server, not Power BI Report Builder, should be used to create the Power BI reports for Power BI Report Server.

Reference: To know more about Power BI Desktop, please refer to the link below:

https://docs.microsoft.com/en-us/power-bi/report-server/install-powerbi-desktop?WT.mc_id=DP-MVP-5003635

Domain: Prepare the Data

Question 24. 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?

  1. Building an application for monitoring the changes in the database and pushing them out utilizing the real-time streaming API
  2. Migrating the content to Power BI Premium
  3. Adding an SSAS tabular layer on top and enabling the Live connections
  4. Convert to DirectQuery to access the data warehouse.

Correct Answer: D

Explanation: While connecting to the data source in Power BI Desktop, it is always possible to import a copy of data in the Power BI Desktop. DirectQuery is another approach that you can use to connect directly to the data source. In DirectQuery, no data is copied or imported into Power BI Desktop. As you build a visualization or interact with any visual, Power BI Desktop queries the underlying data source and therefore you always view the current data. 

With other connecting modes, Underlying data changes might demand a refresh of data and for some reports, there may be a need for large data transfers to show the current data that might make reimporting data unfeasible. On the other hand, DirectQuery reports always use the current data and therefore you don’t need to deal with such problems. Also, DirectQuery has no limitation of the 1-GB dataset.

Option A is incorrect. Building an application for monitoring the changes in the database and pushing them out utilizing the real-time streaming API is not the right choice. Instead, you should Convert to DirectQuery to access the data warehouse.

Option B is incorrect. Migrating the content to Power BI Premium won’t help in achieving the goal. 

Option C is incorrect. Adding an SSAS tabular layer on top and enabling the Live connections won’t help in achieving the goal.

Option D is correct. Convert to DirectQuery to access the data warehouse is the right approach to achieve the goal.

Reference: To know more about the DirectQuery approach, please refer to the link below:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Domain: Prepare the Data

Question 25. 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?

  1. Changing the data model by extending the consumers table with an Index column 
  2. Changing the data model by extending consumer table with a Counter column 
  3. Modifying the consumers’ query by adding an Index column
  4. Modifying the consumers’ query by adding a Counter column

Correct Answer: C

Explanation: Query editor has an option Index Column to add an indexed column starting from 1,0 or any custom number. “Insert Index Column” is present in the “Add Column” tab that allows the creation of a new index column starting from 0, 1, or any custom number. Users can customize the starting value and row increment for the index.

Option A is incorrect. Modifying the consumers query by adding an Index column is the best way to add a new ID column to the consumer table.

Option B is incorrect. Modifying the consumers query by adding an Index column is the best way to add a new ID column to the consumer table.

Option C is correct. Modifying the consumers’ query by adding an Index column is the best way to add a new ID column to the consumer table.

Option D is incorrect. Modifying the consumers’ query by adding an Index column is the best way to add a new ID column to the consumer table.

Reference: To know more about “Insert Index Column”, please refer to the link below:

https://powerbi.microsoft.com/fr-fr/blog/4-new-updates-in-power-query/

Domain: Prepare the Data

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

  1. DAX expression having SUM function on such data will provide incorrect results.
  2. DAX expression having MAX function on such data will provide incorrect results.
  3. DAX expression having an AVERAGE function on such data will provide incorrect results.
  4. DAX Expressions can’t be applied if a numeric column has one or multiple NULL values.
  5. All the above

Correct Answer: C

Explanation: AVERAGE function calculates the average by considering the total and dividing that by the number of non-null values. As Null values won’t be considered, the returned average will be greater than the accurate average.

Option A is incorrect as the SUM function will ignore the null values. As Null values are just like zero, it will return the accurate result.

Option B is incorrect as the MAX expression will take the maximum non-null value and therefore return the correct result.

Option C is correct as the AVERAGE function calculates the average by considering the total and dividing that total by the number of non-null values. As Null values won’t be considered, the returned average will be greater than the accurate average.

Option D is incorrect as DAX expressions can be applied even if the column has null values and the expressions like SUM and MAX return the correct result even in the case of NULL values.

Option E is incorrect. Option C is the correct answer.

Reference: To know more about DAX expressions and data shaping, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/clean-data-power-bi/2-shape-data

Domain: Prepare the Data

Question 27. 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.

  1. For the key column, use “Duplicate Values”.
  2. Rename column3
  3. Use “Remove Errors” for Column3
  4. Modify the Data Type of the Value Column
  5. Change the Aggregate Value Function of the Pivot

Correct Answer: E

Explanation: Changing the Aggregate Value Function of the Pivot is the right answer. While using the Pivot feature, you need to take care of the Aggregate Value Functions shown in the Advanced options; if you are interested in preserving all duplicated values, don’t choose the Sum option:

Option A is incorrect. Using duplicate values won’t help in resolving the issue.

Option B is incorrect. Renaming the column won’t help in resolving the issue.

Option C is incorrect. Using “Remove Error” is not the correct choice.

Option D is incorrect. Modifying the Data Type of the Value column won’t help in resolving the issue.

Option E is correct. Changing the Aggregate Value Function of the Pivot is the right answer. While using the Pivot feature, you need to take care of the Aggregate Value Functions.

Reference: To know more about Pivot and Unpivot columns, please refer to the link below:

https://databear.com/power-bi-pivot-and-unpivot-columns/

Domain: Analyze the Data

Question 28. Which of the following are the potential ways to enhance the performance of a report?

A. Aggregate the data to reduce the number of rows. For example, the transactions can be grouped by the month rather than showing them by date.

Restrict the number of data points shown in a visual for example in a table with the help of the Top N filter.  

  1. Optimize the DAX expressions to iterate through fewer rows
  2. Split out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact tables
  3. Reduce the number of bookmarks applied to a report.
  4. Use FILTER as parts of CALCULATE measure instead of writing the filter condition directly within the function

Correct Answer: A, B, C, D

Explanation: The performance of a report can be significantly improved by aggregating the data and reduce the number of rows, restricting the number of data points shown in a visual, Optimizing the DAX expressions to iterate through a fewer number of rows, and Splitting out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact table.

Option A is correct. To aggregate the data to reduce the number of rows is a potential way to enhance the performance of a report.

Option B is correct. To restrict the number of data points shown in a visual for example in a table with the help of the Top N filter is a potential way to enhance the performance of a report.

Option C is correct. Optimizing the DAX expressions to iterate through a fewer number of rows is a potential way to enhance the performance of a report.

Option D is correct.  Splitting out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact table is also a potential way to enhance the performance of a report.

Option E is incorrect. Reducing the number of bookmarks applied on a report won’t help in improving the performance of a report.

Option F is incorrect. Utilizing FILTER as parts of CALCULATE measure instead of writing the filter condition directly within the function won’t help in improving the performance of a report.

Reference:  To know more about the report performance, visit the below link:

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization?WT.mc_id=DP-MVP-5003635

Domain: Analyze the Data

Question 29. There is a dataset containing the survey results for the percentage of Facebook usage by Gender, year, and age.  The age of the survey respondents lies between 10 and 70 years. You need to build a bar chart demonstrating the percentage of Facebook usage for equal age ranges of 15 years.

Here is the list of some actions that might be performed.

A. Set the group type to Bin

B.Set the Bin size to 4

C. Set the Bin Count to 15

D. Set the Bin count to 4

E. Set Group type to list

F. Set the Bin type to the number of Bins

G. Right-click on the column Age and Choose New Group

Choose the correct sequence of the actions (you may choose some or all actions from the given list) that you would perform.

  1. a-b-c-f-g
  2. a-c-b-g-h
  3. a-b-c-e-g
  4. g-a-f-d
  5. a-g-f-d

Correct Answer: D

Explanation: The correct sequence to be followed is:

  • Right Click on the column Age and choose New Group.
  • Set Group Type to Bin
  • Set Bin Type to number of bins
  • Set Bin Count to 4

So, the correct sequence is – g-a-f-d

First of all, you need to right-click on the column “Age” and choose the New Group.  It will open the Group dialog. Set the group Type to Bin. Group Type should be set to the bin when you do need to group numeric or data values.  Setting the Group Type to Bin will expose the Bin size and Bin type fields. In the Next step, Set the Bin type to the number of Bins and the Bin count to 4.  As there are 60 years between the age of 10 and 70 years, for getting the bins that cover 15 years, you need to set the Bin Count to 4. Making the Bin count to 4 will crate the age range of 15 years.

Setting the Group type to List is not the correct action. The list type is used for grouping the data categories, not the numeric data.

Setting the Bin Size to 4 is also not a correct option. As there are 60 years between the age of 10-70. Setting the Bin Size to 4 will create the age range of 4 years but we need the age range of 15 years.

Setting the Bin Count to 15 is also not the correct action. As there are 60 years between the age of 10 and 70 years, to get the bins that cover 15 years, you need to set the Bin Count to 4. If you set the Bin count to 15, it will create an age range of 4 but we need an age range of 15.

Reference:

To know more about Grouping and Binning, please go through the link below:

Domain: Deploy and Maintain Deliverables

Question 30. Which of the below-given settings are possible to be managed in a dataset in Power BI Service?

A. Adding a new data source

B. Adding a new DAX measure

C. Configure Scheduled Refreshes

D. View the refresh history

E. Creating a new table relationship

F. If you are not the current owner, you can take over the dataset.

Correct Answer: C, D, F

Explanation: In Power BI Service, it is possible to configure the scheduled refreshes, view the refresh history, and takeover the dataset if you are the current owner.

Option A is incorrect. Adding a new data source is not possible in the Power BI service. It is done in Power BI Desktop.

Option B is incorrect. Adding a new DAX measure is not possible in the Power BI service. It is done in Power BI Desktop.

Option C is correct. You can configure scheduled refreshes in Power BI Service.

Option D is correct. You can view the refresh history in a dataset in Power BI Service.

Option E is incorrect. It is not possible to create a new table relationship in Power BI Services. It is done in Power BI Desktop.

Option F is correct. If you are not the current owner, you can take over the dataset in Power BI Service.

Reference:  To know more about the Scheduled Refresh, please click the below-given link:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh?WT.mc_id=DP-MVP-5003635

Domain: Deploy and Maintain Deliverables

Question 31. You develop a Power BI Report for a huge dataset. You are looking to enhance the performance of dataset refresh through an incremental refresh. Which of the following statements are true regarding this scenario?

A. Use Incremental Refresh feature only for the data sources supporting query folding

B. RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh

C. Use Incremental Refresh feature for all data sources

D. A date field is needed on a table in the dataset

Correct Answers: A, B, and D

Explanation: The Incremental Refresh feature should be used only for the queries and data sources that support query folding otherwise all the data will be pulled multiple times by the Incremental Refresh feature. For incremental Refresh, RangeStart and RangeEnd are two date and time parameters in PowerQuery that are used to filter the datasets. Also, a date field is needed to specify how incremental record changes will be returned by the filter. You can’t use incremental refresh without a date filed.

Option A is correct. It is always recommended to use the Incremental Refresh feature only for the data sources supporting query folding. If the data source does not support query folding, data will be pulled multiple times through Incremental Refresh.

Option B is correct. RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh to filter the datasets.

Option C is incorrect. Incremental Refresh Feature should be used only for the data sources supporting query folding.

Option D is correct. A date field is needed on a table in the dataset to specify how incremental record changes will be returned by the filter.

References:

To know more about the Incremental Refresh, please click the below-given link:

Domain: Deploy and Maintain Deliverables

Question 32. Which of the following is not a benefit offered by the workspaces?

A. Workspaces can be used to house dashboards and reports for use by multiple teams. 

B. Workspaces allow you to share and present dashboards and reports in a single environment.

C. Workspaces allow you to view and edit the data model, create visualizations and transform the data.

D. Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets.

Correct Answer: C

Explanation:  Workspaces are centralized repositories that allow you to collaborate with colleagues and teams to generate collections of reports and dashboards. The various benefits offered by the workspaces are: 

  • workspaces can be used to house dashboards and reports for use by multiple teams. 
  • Workspaces allow you to share and present dashboards and reports in a single environment.
  • Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets.

Option A is incorrect as workspaces can be used to house dashboards and reports for use by multiple teams. 

Option B is incorrect as Workspaces allow you to share and present dashboards and reports in a single environment.

Option C is correct as To view and edit the data model, create visualizations and transform the data is not the feature or benefit offered by the workspaces.

Option D is incorrect as Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets.

Reference: To know more about the Workspaces, please check the link below:

https://docs.microsoft.com/en-us/learn/modules/create-manage-workspaces-power-bi/1-introduction

OutDated Questions

 

Domain: Prepare the Data

Question 1. 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?

  1. Adding the folder data source; using the Append Queries command
  2. Adding the folder data source; using the Combine Files Command
  3. Adding every single file to the model and then using Merge Query Command
  4. Adding the MS Excel Data Source; selecting all files of the folder
  5. Adding a folder data source and using the Merge Queries Command

Correct Answer: B

Explanation: Adding a folder data source and using the Combine Files command is the right choice. Implement Get and Transform feature of Excel for combining the multiple files having the exact same schema, from a single folder into a single table. 

Option A is incorrect. You need to use the Combine Files command rather than the Append Queries command.

Option B is correct. Adding a folder data source and using the Combine Files Command is the right choice to achieve the goal.

Option C is incorrect. Adding every single file to the model and then using Merge Queries Command is not the right choice.

Option D is incorrect. Adding a Microsoft Excel Data Source and selecting all files of the folder is not the right choice.

Option E is incorrect. You need to use the Combine Files command rather than the Merge Queries command.

Reference: To know more about combining files, please refer to the doc below:

https://support.microsoft.com/en-ie/office/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4

Domain: Analyze the Data

Question 2. Which of the following is not a core component of Q & A Visualization?

  1. The question box where the question is entered by the users. It also shows the suggestions to the users that help them in completing their questions. 
  2. A pre-populated list of suggested questions.
  3. An icon that can be selected by the users to convert the Q&A visual into a standard visual.
  4. An icon that can be selected by the users to automatically create a custom tooltip
  5. An icon that can be selected by the users to open Q&A tooling where they can configure the underlying natural language engine. 

Correct Answer: D

Explanation: In Q&A, visualization is a specific type of visualization where the users can ask natural language questions and the answers are displayed in the form of visuals. The four core components of Q&A analysis are as given below:

  • The question box where the question is entered by the users. It also shows the suggestions to the users that help them in completing their questions. 
  • A pre-populated list of suggested questions.
  • An icon that can be selected by the users to convert the Q&A visual into a standard visual.
  • An icon that can be selected by the users to open Q&A tooling where they can configure the underlying natural language engine. 

Option A is incorrect as “Question Box” is the core component of Q&A analysis.

Option B is incorrect as “A pre-populated list of suggested questions” is also a core component of Q&A analysis.

Option C is incorrect as “An icon that can be selected by the users to convert the Q&A visual into a standard visual” is a core component of Q&A analysis.

Option D is correct as “An icon that can be selected by the users to automatically create a custom tooltip” is not a core component of Q&A analysis.

Option E is incorrect as “An icon that can be selected by the users to open Q&A tooling where they can configure the underlying natural language engine” is a core component of Q&A analysis.

Reference: To know more about the Q&A Analysis, please refer to the link below:

https://docs.microsoft.com/en-us/learn/modules/visuals-power-bi/3-effective-visualization

Domain: Model the Data

Question 3. You have a CSV file having the workers’ badging. There is a column “Starting Time” in the file and the data in this column exists in the format like 2020-12-25 at 10:00.

You need to analyze the Workers’ Badging trend with the column “Starting Time” and utilize a built-in date hierarchy. What would you do?

  • Create a column by example starting with 2020-12-25
    1. Duplicate the column “Starting Time” and apply the TRIM function
  • Create a column by example starting with 2020-12-25 and set “DATE” as the data type of the new column 
  • Create a new Date table with the help of the CALENDER function

Correct Answer: C

Explanation: For using the built-in date hierarchy, you need to create a new column by example starting with 2020-12-25 and set “DATE” as the data type of that column. 

Option A is incorrect. Just creating a column by example starting with 2020-12-25 won’t allow using the built-in date hierarchy.

Option B is incorrect. Duplicating the column “Starting Time” and applying the TRIM function is not the right option.

Option C is correct. Creating a column by example starting with 2020-12-25 and setting “DATE” as the data type of new column will allow you to use the built-in date hierarchy.

Option D is incorrect. Creating a new Date table with the help of the CALENDER function is not the right option.

Reference: To know more about the date hierarchy, please refer to the link below:

https://5minutebi.com/2017/11/29/how-to-use-powerbi-date-hierarchy

Final Words

I hope you’ve enjoyed this article and found it helpful in preparing for the PL-300 exam on Microsoft Power BI Data Analyst. Spending more time studying before taking the actual certification exam is generally recommended. You should attempt the PL-300 free practice test, which offers a collection of sample questions to evaluate your skills, in addition to studying by answering these free questions.

Whizlabs offers you the PL-300 exam preparation materials to pass the certification exam. With the help of our video courses, practice exams, hands-on labs, and Power BI sandboxes for in-the-moment testing.

If you have any clarifications or doubts, please feel free to comment us!

About Basant Singh

Basant Singh is a Cloud Product Manager with over 18+ years of experience in the field. He holds a Bachelor's degree in Instrumentation Engineering, and has dedicated his career to mastering the intricacies of cloud computing technologies. With expertise in Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP), he stays current with the latest developments in the industry. In addition, he has developed a strong interest and proficiency in Google Go Programming (Golang), Docker, and NoSQL databases. With a history of successfully leading teams and building efficient operations and infrastructure, he is well-equipped to help organizations scale and thrive in the ever-evolving world of cloud technology.

Leave a Comment

Your email address will not be published. Required fields are marked *


Scroll to Top