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

Pl-300 Questions & Answers

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

By admin
On

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

Leave a Reply

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

DeepNeuron