{"id":88416,"date":"2023-04-19T05:57:22","date_gmt":"2023-04-19T11:27:22","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=88416"},"modified":"2023-08-08T00:03:21","modified_gmt":"2023-08-08T05:33:21","slug":"practice-questions-microsoft-power-bi-pl-300","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/","title":{"rendered":"Free Questions for Microsoft Power BI Data Analyst Exam (PL-300)"},"content":{"rendered":"<div class=\"group w-full text-gray-800 dark:text-gray-100 border-b border-black\/10 dark:border-gray-900\/50 bg-gray-50 dark:bg-[#444654]\">\n<div class=\"text-base gap-4 md:gap-6 md:max-w-2xl lg:max-w-xl xl:max-w-3xl p-4 md:py-6 flex lg:px-0 m-auto\">\n<div class=\"relative flex w-[calc(100%-50px)] flex-col gap-1 md:gap-3 lg:w-[calc(100%-115px)]\">\n<div class=\"flex flex-grow flex-col gap-3\">\n<p class=\"min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap\">Are you ready to put your data analysis skills to the test and become a certified <a href=\"https:\/\/www.whizlabs.com\/microsoft-power-bi-certification-pl-300\/\" target=\"_blank\" rel=\"noopener\">Microsoft Power BI Data Analyst<\/a>? Look no further! Here we provide some updated free questions on Microsoft Power BI Data Analyst Exam (PL-300) exam.<\/p>\n<p class=\"min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap\">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.<\/p>\n<p class=\"min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap\">By knowing how to work with <strong><a href=\"https:\/\/www.whizlabs.com\/blog\/what-is-power-bi\/\" target=\"_blank\" rel=\"noopener\">Power BI<\/a><\/strong>, you can help out the business to eliminate risks like data breaches and malware threats.<\/p>\n<p class=\"min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap\">So, let&#8217;s dive in and unlock the power of Power BI!<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #ea7e02;color:#ea7e02\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #ea7e02;color:#ea7e02\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Prerequisites_for_Microsoft_Power_BI_Data_Analyst\" >Prerequisites for Microsoft Power BI Data Analyst<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Salary_and_Scope_of_Microsoft_Power_BI_Data_Analyst\" >Salary and Scope of Microsoft Power BI Data Analyst<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Microsoft_Power_BI_Data_Analyst_Exam_PL-300_certification_Free_Questions\" >Microsoft Power BI Data Analyst Exam (PL-300) certification Free Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Prepare_the_Data\" >Domain: Prepare the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Prepare_the_Data-2\" >Domain: Prepare the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Model_the_Data\" >Domain: Model the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Model_the_Data-2\" >Domain: Model the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Model_the_Data-3\" >Domain: Model the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Model_the_Data-4\" >Domain: Model the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Visualize_the_Data\" >Domain: Visualize the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Visualize_the_Data-2\" >Domain: Visualize the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Visualize_the_Data-3\" >Domain: Visualize the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Analyze_the_Data\" >Domain: Analyze the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Analyze_the_Data-2\" >Domain: Analyze the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Deploy_and_Maintain_Deliverables\" >Domain: Deploy and Maintain Deliverables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Deploy_and_Maintain_Deliverables-2\" >Domain: Deploy and Maintain Deliverables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Deploy_and_Maintain_Deliverables-3\" >Domain: Deploy and Maintain Deliverables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Prepare_the_Data-3\" >Domain: Prepare the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Prepare_the_Data-4\" >Domain: Prepare the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Prepare_the_Data-5\" >Domain: Prepare the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Prepare_the_Data-6\" >Domain: Prepare the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Analyze_the_Data-3\" >Domain: Analyze the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Analyze_the_Data-4\" >Domain: Analyze the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Deploy_and_Maintain_Deliverables-4\" >Domain: Deploy and Maintain Deliverables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Deploy_and_Maintain_Deliverables-5\" >Domain: Deploy and Maintain Deliverables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Deploy_and_Maintain_Deliverables-6\" >Domain: Deploy and Maintain Deliverables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#OutDated_Questions\" >OutDated Questions<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Prepare_the_Data-7\" >Domain: Prepare the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Analyze_the_Data-5\" >Domain: Analyze the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Domain_Model_the_Data-5\" >Domain: Model the Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.whizlabs.com\/blog\/practice-questions-microsoft-power-bi-pl-300\/#Final_Words\" >Final Words<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Prerequisites_for_Microsoft_Power_BI_Data_Analyst\"><\/span>Prerequisites for Microsoft Power BI Data Analyst<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>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:<\/p>\n<ul>\n<li>Proficiency in fundamental data concepts.<\/li>\n<li>Expertise in managing relational data within cloud environments.<\/li>\n<li>Proficiency in handling non-relational data in cloud-based settings.<\/li>\n<li>Understanding of data analysis and visualization principles.<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Salary_and_Scope_of_Microsoft_Power_BI_Data_Analyst\"><\/span>Salary and Scope of Microsoft Power BI Data Analyst<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you are a <a href=\"https:\/\/learn.microsoft.com\/en-us\/certifications\/power-bi-data-analyst-associate\/\" target=\"_blank\" rel=\"nofollow noopener\">Microsoft Power BI certified data analyst<\/a>, 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.<\/p>\n<figure id=\"attachment_88422\" aria-describedby=\"caption-attachment-88422\" style=\"width: 1097px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"wp-image-88422 size-full\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Microsoft-Power-BI-Salary-trends.webp\" alt=\"Microsoft Power BI\" width=\"1097\" height=\"642\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Microsoft-Power-BI-Salary-trends.webp 1097w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Microsoft-Power-BI-Salary-trends-300x176.webp 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Microsoft-Power-BI-Salary-trends-1024x599.webp 1024w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Microsoft-Power-BI-Salary-trends-768x449.webp 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Microsoft-Power-BI-Salary-trends-150x88.webp 150w\" sizes=\"(max-width: 1097px) 100vw, 1097px\" \/><figcaption id=\"caption-attachment-88422\" class=\"wp-caption-text\">Dataflair.com<\/figcaption><\/figure>\n<p>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.<\/p>\n<p>Making a\u00a0career in the field of Power BI is expected to be one of the most in-demand careers\u00a0globally in the near future.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Microsoft_Power_BI_Data_Analyst_Exam_PL-300_certification_Free_Questions\"><\/span>Microsoft Power BI Data Analyst Exam (PL-300) certification Free Questions<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p class=\"min-h-[20px] flex flex-col items-start gap-4 whitespace-pre-wrap\">Here, we have covered some domains that are vital for clearing the Microsoft Power BI Data Analyst Exam (PL-300) exam and they are:<\/p>\n<h4><strong>Domain: Model the data<\/strong><\/h4>\n<p><strong>Question 1: Consider the below-given sample data:<\/strong><\/p>\n<table style=\"height: 274px;\" width=\"551\">\n<tbody>\n<tr>\n<td><strong>Date<\/strong><\/td>\n<td><strong>Day<\/strong><\/td>\n<td><strong>Month<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>2021-02-01<\/strong><\/td>\n<td><strong>1<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>2021-02-02<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>2021-02-03<\/strong><\/td>\n<td><strong>3<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<\/tr>\n<tr>\n<td><strong>2021-02-04<\/strong><\/td>\n<td><strong>4<\/strong><\/td>\n<td><strong>2<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>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?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>FORMAT([Date],\u201dM\u201d)|| FORMAT([Date],\u201dD\u201d)|| FORMAT([Date],\u201dY\u201d)<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B.<\/strong> FORMAT([Date],\u201dMMMM DD, YYYY\u201d)<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>FORMAT([Date],\u201dMMM\u201d)|| FORMAT([Date],\u201dDD\u201d)|| FORMAT([Date],\u201dYYYY\u201d)<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>FORMAT(\u2018Date_Table\u2019 [Date],\u201dMMM\u201d)|| FORMAT(\u2018Date_Table\u2019 [Date],\u201dDD\u201d)|| FORMAT(\u2018Date_Table\u2019 [Date],\u201dYYYY\u201d)<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">&#8220;MMMM&#8221; is a user-defined format for date\/time that displays the full month name as the month.\u00a0 FORMAT([Date],\u201dMMMM DD, YYYY\u201d) is the right DAX expression<\/span><b>.<\/b><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">The given DAX expression is not correct to show the date in the required format.<\/span><\/p>\n<p><b>Option B is correct. <\/b><span style=\"font-weight: 400;\">FORMAT([Date],\u201dMMMM DD, YYYY&#8221;) is the right DAX expression to show the date in the required format.<\/span><\/p>\n<p><b>Option C is incorrect. <\/b><span style=\"font-weight: 400;\">The given DAX expression is not correct to show the date in the required format.<\/span><\/p>\n<p><b>Option D is incorrect. <\/b><span style=\"font-weight: 400;\">The given DAX expression is not correct to show the date in the required format.<\/span><\/p>\n<p><b>Reference:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Check the full custom date and time formats list for the FORMAT function here: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/custom-date-and-time-formats-for-the-format-function\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/dax\/custom-date-and-time-formats-for-the-format-function<\/span><\/a><\/p>\n<h4><b>Domain: <\/b><b>Model the data<\/b><\/h4>\n<p><strong>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%.<\/strong><\/p>\n<p><strong>Fill in blanks by selecting the right sequence of the words from the given option to create the required measure.<\/strong><\/p>\n<p><strong>= \u2026\u2026\u2026\u2026\u2026 (<\/strong><br \/>\n<strong>\u00a0 \u00a0\u00a0 \u2026\u2026\u2026.. (\u2026\u2026\u2026\u2026\u2026\u2026 (\u2018Date\u2019[year]),\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/strong><br \/>\n<strong>\u00a0 \u2018Date\u2019[year]&lt;2015)<\/strong><br \/>\n<strong>\u00a0 \u00a0\u00a0 ),<\/strong><br \/>\n<strong>\u00a0 \u00a0\u00a0 \u2026\u2026\u2026\u2026\u2026(\u2018Date\u2019[year]&gt;=2010,<\/strong><br \/>\n<strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 [Sales Amount]*1.2,<\/strong><br \/>\n<strong>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 [Sales Amount]*1.1)<\/strong><br \/>\n<strong>\u00a0 \u00a0 \u00a0 \u00a0 )<\/strong><br \/>\n<strong>)<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>FILTER, SUM, VALUES, TABLE<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>SUMX, FILTER, VALUES, IF<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>IF, VALUES, CONCATENATE, TABLE<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>IF, TABLE, SUM, FILTER<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>E. <\/strong>SUM, FILTER, IF, VALUES<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">The following is the correct DAX expression for the required purpose:<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. The given sequence FILTER, SUM, VALUES, TABLE is not the correct answer.<\/span><br \/>\n<b>Option B is correct. <\/b><span style=\"font-weight: 400;\">The given sequence SUMX, FILTER, VALUES, IF is the correct answer.<\/span><br \/>\n<b>Option C is incorrect. <\/b><span style=\"font-weight: 400;\">The given sequence IF, VALUES, CONCATENATE, TABLE is not the correct answer.<\/span><br \/>\n<b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> The given sequence IF, TABLE, SUM, FILTER is not the correct answer.<\/span><br \/>\n<b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> The given sequence SUM, FILTER, IF, VALUES is not the correct answer.<\/span><\/p>\n<p><b>Reference:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">To know more about the DAX functions, please refer to the link below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/dax\/<\/span><\/a><\/p>\n<h4><b>Domain: <\/b><b>Model the data<\/b><\/h4>\n<p><strong>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.<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>True<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>False<\/span><\/p>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">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.\u00a0 Therefore, reducing the size of the data model by removing the unnecessary rows or columns will help in improving the performance of the reports.<\/span><\/p>\n<p><b>Reference:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">To know more about the optimization, please refer to the link below: <\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization?WT.mc_id=DP-MVP-5003635\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization?WT.mc_id=DP-MVP-5003635<\/span><\/a><\/p>\n<h4><b>Domain: <\/b><b>Visualize and analyze the data<\/b><\/h4>\n<p><strong>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?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>A different version of R was used to build the visual<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>The data was duplicated<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>The data originates from a Microsoft SQL Server source<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>The number of records to be shown were higher than the capacity of R visuals<\/span><\/p>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. Using the different versions of R can&#8217;t be the possible reason behind showing the details for only a few students, not all.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. As each student_id is unique, the data can\u2019t be duplicated.<\/span><br \/>\n<b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. <\/span><i><span style=\"font-weight: 400;\">The data that originates from a Microsoft SQL Server source<\/span><\/i><span style=\"font-weight: 400;\"> is not the potential cause of the issue.<\/span><br \/>\n<b>Option D is correct.<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Reference:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">To know more about the R Visuals, please refer to the link below: <\/span><a style=\"font-size: 16px; font-weight: 400; background-color: #ffffff;\" href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/service-r-visuals\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/service-r-visuals<\/span><\/a><\/p>\n<h4><b>Domain: <\/b><b>Visualize and analyze the data<\/b><\/h4>\n<p><strong>Question 5: Which of the following statements are true for Power BI paginated reports?<\/strong><\/p>\n<p><span style=\"font-weight: 400;\"><strong>A. <\/strong>Power BI paginated reports are created using Power BI Desktop<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>B. <\/strong>Power BI paginated reports are created using Power BI Service<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>C. <\/strong>Power BI paginated reports are created using Power BI Report Builder<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>D. <\/strong>Power BI paginated reports are descendants of SQL Server Reporting Services<\/span><br \/>\n<span style=\"font-weight: 400;\"><strong>E. <\/strong>Power BI paginated reports are descendants of SQL Server Analysis Services<\/span><\/p>\n<p><b>Correct Answers: C and D<\/b><\/p>\n<p><b>Explanation<\/b><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are created using Power BI Report Builder, not Power BI Desktop.<\/span><br \/>\n<b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are created using Power BI Report Builder, not Power BI Service.<\/span><br \/>\n<b>Option C is correct<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are created using Power BI Report Builder.<\/span><br \/>\n<b>Option D is correct<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are descendants of SQL Server Reporting Services.<\/span><br \/>\n<b>Option E is incorrect<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are descendants of SQL Server Reporting Services, not SQL Server Analysis Services.<\/span><\/p>\n<p><b>Reference:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">To know more about the Power BI paginated reports, please refer to the link below: <\/span><a style=\"font-size: 16px; font-weight: 400; background-color: #ffffff;\" href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-paginated-reports-power-bi\/1-introduction\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-paginated-reports-power-bi\/1-introduction<\/span><\/a><\/p>\n<p><b style=\"font-style: inherit; font-size: 1.5em;\">Domain: Prepare the Data<\/b><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<p><b>Question 6. Which of the following data sources can be connected through the &#8220;Get Data&#8221; option in the Power BI Desktop?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI datasets<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI dataflows<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI Template Apps<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All of the above<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">Here is the snapshot for the most common data types that are possible to connect with:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Options A, B and C are the data sources that can be connected through the &#8220;Get Data&#8221; option in the Power BI Desktop.<\/span><\/p>\n<p><b>Reference:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-data-sources\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-data-sources<\/span><\/a><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Prepare_the_Data\"><\/span><b>Domain: Prepare the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 7: For the query opened in Power Query Editor, <\/b><b>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?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Column profile<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Show Whitespaces<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Column quality<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0Column distribution<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">\u00a0In 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, <\/span><span style=\"font-weight: 400;\">Column quality\u00a0is the one that can be used to show\u00a0the percentages of data that is in error, empty and valid.\u00a0<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. <\/span><span style=\"font-weight: 400;\">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.\u00a0<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. Using Column Quality, not Show Whitespaces, is the correct option.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\">. Column quality\u00a0is the data preview option that is used to show\u00a0the percentages of data that is in error, empty and valid.\u00a0<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Column distribution\u00a0displays\u00a0the\u00a0data distribution within the column and the counts of unique and distinct values. It is not the right choice for the target goal.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the Profile Data, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/6-profile-data\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/6-profile-data<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Prepare_the_Data-2\"><\/span><b>Domain: Prepare the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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.\u00a0\u00a0<\/b><\/p>\n<p><b>Students<\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Name<\/b><\/td>\n<td><b>Registration_id<\/b><\/td>\n<td><b>Grade<\/b><\/td>\n<td><b>Region_id<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Aron<\/span><\/td>\n<td><span style=\"font-weight: 400;\">13456<\/span><\/td>\n<td><span style=\"font-weight: 400;\">A<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1010<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Frank<\/span><\/td>\n<td><span style=\"font-weight: 400;\">13457<\/span><\/td>\n<td><span style=\"font-weight: 400;\">B+<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1026<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Adam<\/span><\/td>\n<td><span style=\"font-weight: 400;\">13458<\/span><\/td>\n<td><span style=\"font-weight: 400;\">A+<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1067<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">Steve<\/span><\/td>\n<td><span style=\"font-weight: 400;\">13459<\/span><\/td>\n<td><span style=\"font-weight: 400;\">C<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u00a0 1010<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><b>Area<\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Region_id<\/b><\/td>\n<td><b>Country<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1010<\/span><\/td>\n<td><span style=\"font-weight: 400;\">USA<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1026<\/span><\/td>\n<td><span style=\"font-weight: 400;\">USA\u00a0<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">1067<\/span><\/td>\n<td><span style=\"font-weight: 400;\">UK<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><span style=\"font-weight: 400;\">Y<\/span><b>ou 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.\u00a0 Which of the following will help in achieving the goal?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Append the Students and Area tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Transpose both students and Area tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Merge the Students and Area tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Group the Students and Area table on Region_id column<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Apply intersection operations on the students and Area tables.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">Merge and Append are two main methods of combining the queries.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> To <\/span><i><span style=\"font-weight: 400;\">Append the Students and Area tables<\/span><\/i> <span style=\"font-weight: 400;\">is not the right option. Instead, the tables Students and Area should be merged.\u00a0<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> To <\/span><i><span style=\"font-weight: 400;\">Transpose both students and Area tables<\/span><\/i><span style=\"font-weight: 400;\"> won\u2019t help in achieving the whole information of the students in one table.\u00a0<\/span><\/p>\n<p><b>Option C is correct. <\/b><span style=\"font-weight: 400;\">You need to merge the tables Students and Area to have the whole details of the students including the country in one query.\u00a0<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Grouping the Students and Area table on the Region_id column is not the right choice. Rather, the students and Area should be merged.<\/span><\/p>\n<p><b>Option E is incorrect. <\/b><span style=\"font-weight: 400;\">Apply intersection operations on the students and Area tables is not the right choice. Rather, the Students and Area should be merged.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the Combining tables, please refer to the link below:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/5-combine-tables\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/5-combine-tables<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Model_the_Data\"><\/span><b>Domain: Model the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 9. Which of the following statements are true about data granularity? <\/b><b>(Select Multiple Options)<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data granularity represents the level of the details represented within the data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data granularity represents the relationships among the various data entities.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Data granularity represents the type of values contained by the data<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Higher data granularity, greater the level of detail within the data.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Higher data granularity, high domain range for the data<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A and D<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: 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.\u00a0 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.<\/span><\/p>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. Data granularity represents the level of the details represented within the data.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Data granularity represents the level of the details represented within the data; not the relationships among the various data entities.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Data granularity represents the level of the details represented within the data; not the type of values contained by the data.<\/span><\/p>\n<p><b>Option D is correct.<\/b><span style=\"font-weight: 400;\"> Higher data granularity represents a greater level of details.<\/span><\/p>\n<p><b>Option E is incorrect<\/b><span style=\"font-weight: 400;\">. Data granularity represents the level of the details; not the domain values.<\/span><\/p>\n<p><b>Reference:<\/b> <span style=\"font-weight: 400;\">To know more about the data granularity, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/design-model-power-bi\/5-data-granularity\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/design-model-power-bi\/5-data-granularity<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Model_the_Data-2\"><\/span><b>Domain: Model the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 10: Consider the below-given sample data:<\/b><\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Date<\/b><\/td>\n<td><b>Day<\/b><\/td>\n<td><b>Month<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2021-02-01<\/span><\/td>\n<td><span style=\"font-weight: 400;\">1<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2021-02-02<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2021-02-03<\/span><\/td>\n<td><span style=\"font-weight: 400;\">3<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">2021-02-04<\/span><\/td>\n<td><span style=\"font-weight: 400;\">4<\/span><\/td>\n<td><span style=\"font-weight: 400;\">2<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>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?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FORMAT([Date],\u201dM\u201d)|| FORMAT([Date],\u201dD\u201d)|| FORMAT([Date],\u201dY\u201d)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FORMAT([Date],\u201dMMMM DD, YYYY\u201d)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FORMAT([Date],\u201dMMM\u201d)|| FORMAT([Date],\u201dDD\u201d)|| FORMAT([Date],\u201dYYYY\u201d)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FORMAT(\u2018Date_Table\u2019 [Date],\u201dMMM\u201d)|| FORMAT(\u2018Date_Table\u2019 [Date],\u201dDD\u201d)|| FORMAT(\u2018Date_Table\u2019 [Date],\u201dYYYY\u201d)<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:\u00a0 <\/b><span style=\"font-weight: 400;\">&#8220;MMMM&#8221; is a user-defined format for date\/time that displays the full month name as the month.\u00a0 <\/span><span style=\"font-weight: 400;\">FORMAT([Date],\u201dMMMM DD, YYYY\u201d) is the right DAX expression<\/span><b>.\u00a0<\/b><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">The given DAX expression is not correct to show the date in the required format.<\/span><\/p>\n<p><b>Option B is correct. <\/b><span style=\"font-weight: 400;\">FORMAT([Date],\u201dMMMM DD, YYYY&#8221;) is the right DAX expression to show the date in the required format.<\/span><b>\u00a0<\/b><\/p>\n<p><b>Option C is incorrect. <\/b><span style=\"font-weight: 400;\">The given DAX expression is not correct to show the date in the required format.<\/span><\/p>\n<p><b>Option D is incorrect. <\/b><span style=\"font-weight: 400;\">The given DAX expression is not correct to show the date in the required format.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">Check the full custom date and time formats list for the FORMAT function here:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/custom-date-and-time-formats-for-the-format-function\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/dax\/custom-date-and-time-formats-for-the-format-function<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Model_the_Data-3\"><\/span><b>Domain: Model the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 11.\u00a0 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%.<\/b><\/p>\n<p><b>Fill in blanks by selecting the right sequence of the words from the given option to create the required measure.<\/b><\/p>\n<p><span style=\"font-weight: 400;\">= \u2026\u2026\u2026\u2026\u2026 (\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u2026\u2026\u2026.. (\u2026\u2026\u2026\u2026\u2026\u2026 (\u2018Date\u2019[year]),\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u2018Date\u2019[year]&lt;2015)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0),\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u2026\u2026\u2026\u2026\u2026(\u2018Date\u2019[year]&gt;=2010,<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0[Sales Amount]*1.2,<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0[Sales Amount]*1.1)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">)\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">FILTER, SUM, VALUES, TABLE<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">SUMX, FILTER, VALUES, IF<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">IF, VALUES, CONCATENATE, TABLE<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">IF, TABLE, SUM, FILTER<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The following is the correct DAX expression for the required purpose:<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. The given sequence FILTER, SUM, VALUES, TABLE is not the correct answer.<\/span><\/p>\n<p><b>Option B is correct. <\/b><span style=\"font-weight: 400;\">The given sequence SUMX, FILTER, VALUES, IF is the correct answer.<\/span><\/p>\n<p><b>Option C is incorrect. <\/b><span style=\"font-weight: 400;\">The given sequence IF, VALUES, CONCATENATE, TABLE is not the correct answer.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> The given sequence IF, TABLE, SUM, FILTER is not the correct answer.<\/span><\/p>\n<p><b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> The given sequence SUM, FILTER, IF, VALUES is not the correct answer.<\/span><\/p>\n<p><b>Reference:<\/b> <span style=\"font-weight: 400;\">To know more about the DAX functions, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/dax\/\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/dax\/<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Model_the_Data-4\"><\/span><b>Domain: Model the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 12.\u00a0 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.\u00a0<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">True<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">False<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">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.\u00a0 Therefore, reducing the size of the data model by removing the unnecessary rows or columns will help in improving the performance of the reports.<\/span><b>\u00a0<\/b><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the optimization, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization?WT.mc_id=DP-MVP-5003635\" target=\"_blank\" rel=\"nofollow noopener\"><b>https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization?WT.mc_id=DP-MVP-5003635<\/b><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Visualize_the_Data\"><\/span><b>Domain: Visualize the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A different version of R was used to build the visual<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The data was duplicated<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The data originates from a Microsoft SQL Server source<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The number of records to be shown were higher than the capacity of R visuals<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. Using the different versions of R can&#8217;t be the possible reason behind showing the details for only a few students, not all.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. As each student_id is unique, the data can\u2019t be duplicated.\u00a0<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. <\/span><i><span style=\"font-weight: 400;\">The data that originates from a Microsoft SQL Server source<\/span><\/i><span style=\"font-weight: 400;\"> is not the potential cause of the issue.<\/span><\/p>\n<p><b>Option D is correct.<\/b> <span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Reference:<\/b> <span style=\"font-weight: 400;\">To know more about the R Visuals, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/service-r-visuals\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/service-r-visuals<\/span><\/a><\/p>\n<p><b>Question 14.\u00a0 Which of the following statements are true for Power BI paginated reports? <\/b><b>(Select Multiple Options)<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI paginated reports are created using Power BI Desktop.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI paginated reports are created using Power BI Service.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI paginated reports are created using Power BI Report Builder.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI paginated reports are descendants of SQL Server Reporting Services\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI paginated reports are descendants of SQL Server Analysis Services<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C and D<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are created using Power BI Report Builder, not Power BI Desktop.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are created using Power BI Report Builder, not Power BI Service.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are created using Power BI Report Builder.<\/span><\/p>\n<p><b>Option D is correct<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are descendants of SQL Server Reporting Services.<\/span><\/p>\n<p><b>Option E is incorrect<\/b><span style=\"font-weight: 400;\"> as Power BI paginated reports are descendants of SQL Server Reporting Services, not SQL Server Analysis Services.\u00a0<\/span><\/p>\n<p><b>Reference:<\/b> <span style=\"font-weight: 400;\">To know more about the <\/span><span style=\"font-weight: 400;\">Power BI paginated reports<\/span><span style=\"font-weight: 400;\">, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-paginated-reports-power-bi\/1-introduction\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-paginated-reports-power-bi\/1-introduction<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Visualize_the_Data-2\"><\/span><b>Domain: Visualize the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 15. Which of the following statements are true for dashboards and reports? <\/b><b>(Select Multiple Options)<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dashboards can have only a single page while reports can have multiple pages<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Reports can have only a single page while Dashboards can have multiple pages<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Both Dashboards and Reports can have multiple pages<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Both reports and dashboards can be refreshed to display the latest data<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dashboards can be refreshed to display the latest data while the reports can\u2019t<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Reports can be refreshed to display the latest data while the Dashboards can\u2019t<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A and D<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The key similarities and differences between the reports and dashboards are:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A Dashboard can be created from many datasets or reports.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dashboards do not consist of Visualization, Filter,\u00a0and\u00a0Fields\u00a0panes that are available in Power BI Desktop which means it is not possible to add new filters and slicers or make edits.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dashboards can have only a single page while reports can have multiple pages.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">The underlying dataset can\u2019t be seen directly in a dashboard, while it is possible to see the dataset in the report under the\u00a0Data\u00a0tab in Power BI Desktop.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Both reports and dashboards can be refreshed to display the latest data.<\/span><\/li>\n<\/ol>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\"> as Dashboards can have only a single page while reports can have multiple pages.<\/span><\/p>\n<p><b>Option B is incorrect <\/b><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option C is incorrect <\/b><span style=\"font-weight: 400;\">as only the reports can have multiple pages while the dashboards can have only a single page.<\/span><\/p>\n<p><b>Option D is correct <\/b><span style=\"font-weight: 400;\">as Both reports and dashboards can be refreshed to display the latest data.<\/span><\/p>\n<p><b>Option E is incorrect <\/b><span style=\"font-weight: 400;\">as both reports and dashboards can be refreshed to display the latest data.<\/span><\/p>\n<p><b>Option F is incorrect <\/b><span style=\"font-weight: 400;\">as both reports and dashboards can be refreshed to display the latest data.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: <\/span><span style=\"font-weight: 400;\">To know more about the Reports and Dashboards, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-dashboards-power-bi\/1-introduction\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-dashboards-power-bi\/1-introduction<\/span><\/a><\/p>\n<p><b>Question 16.\u00a0 <\/b><b>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.<\/b><\/p>\n<p><b>You provide users access to the dashboard through the Viewer role on the workspace.<\/b><\/p>\n<p><b>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?<\/b><\/p>\n<ol>\n<li><b><\/b><span style=\"font-weight: 400;\">Creating a data alert.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\">Sharing the dashboard to the user.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\">Creating a subscription.<\/span><\/li>\n<li><b><\/b><span style=\"font-weight: 400;\">Tagging the user in a comment.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\">\u00a0 <\/span><span style=\"font-weight: 400;\">Sharing the dashboard to the user is not the right option to automate the notifications.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> Creating a subscription will help in automating the notification on daily basis for the number displayed on the card visual.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Tagging the user in a comment is not the right option.<\/span><\/p>\n<p><b>References:<\/b> <span style=\"font-weight: 400;\">To know more about the data alerts and subscriptions, please refer to the links below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-report-subscribe\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-report-subscribe<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-set-data-alerts\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/service-set-data-alerts<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Visualize_the_Data-3\"><\/span><b>Domain: Visualize the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 17.\u00a0 What is the unique benefit of using a customized tooltip?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">With a customized tooltip, any image or color can be set as the background for the visual<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can demonstrate the value and category of the data points<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can demonstrate the images, visuals, and any other collection of items that are created by the user on the report page<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">With a customized tooltip, a border can be created around the visual for isolating the visual from other elements on the canvas.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b> <i><span style=\"font-weight: 400;\">Tooltips<\/span><\/i><span style=\"font-weight: 400;\"> is an amazing feature that provides more contextual detail and information to data points on a visual.\u00a0 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.\u00a0<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. It is the background section, not the tooltips, that allows setting any image or color as the background for the visual.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\">. The main benefit of a customized tooltip is that <\/span><span style=\"font-weight: 400;\">it can demonstrate the images, visuals, and any other collection of items that are created by the user on the report page<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. It is the border section, not the tooltips section, that allows setting <\/span><span style=\"font-weight: 400;\">a border around the visual for isolating the visual from other elements on the canvas.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: <\/span><span style=\"font-weight: 400;\">To know more about the visuals in Power BI, please refer to the link below:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/visuals-power-bi\/4-format\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/visuals-power-bi\/4-format<\/span><\/a><\/p>\n<p><b>Question 18. You have created a line visual that displays the number of students getting scholarships over time.<\/b><b> Now, you are interested in seeing <\/b><b>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? <\/b><b>(Select Multiple Options)<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Add a Scholarship_amount to the Tooltips<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Add a Scholarship_amount to the drill through fields<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Add a Scholarship_amount to the Visual Filters<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">None of the above<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A and C<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">Customized Tooltips and Visual Filters help the users by providing them with additional information and context about the visuals.\u00a0 Scholarship_amount can be added to either Tooltips or Visual Filters to see the total scholarship cost of the students.<\/span><\/p>\n<p><b>Option A is correct.<\/b> <span style=\"font-weight: 400;\">Tooltips bring an amazing feature that provides more contextual detail and information to data points on a visual.\u00a0 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.\u00a0 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.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. 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.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>References: <\/b><span style=\"font-weight: 400;\">To know more about the Tooltips and Filters, please refer to the links below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-custom-tooltips\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-custom-tooltips<\/span><\/a><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/data-driven-story-power-bi\/6-advanced-interactions\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/data-driven-story-power-bi\/6-advanced-interactions<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Analyze_the_Data\"><\/span><b>Domain: Analyze the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 19<\/b><span style=\"font-weight: 400;\">. Which of the following chart is the great choice to identify or display the outliers?<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Line Chart<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Scatter Chart<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Bar chart<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Donut chart<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> 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 \u201cScatter chart\u201d that shows the number of orders by Orders Shipped by Product Category.\u00a0<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as Line charts are not appropriate to display the outliers. Scatter charts are the better choice.<\/span><\/p>\n<p><b>Option B is correct<\/b><span style=\"font-weight: 400;\"> as the Scatter chart is a good choice to display the outliers.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\"> as Bar charts are not appropriate to display the outliers. Scatter charts are the better choice.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\"> as the Scatter chart, not Donut charts, are a good choice to display the outliers.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\">\u00a0 <\/span><span style=\"font-weight: 400;\">To know more about the <\/span><span style=\"font-weight: 400;\">visuals<\/span><span style=\"font-weight: 400;\">, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/perform-analytics-power-bi\/3-visuals\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/perform-analytics-power-bi\/3-visuals<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Analyze_the_Data-2\"><\/span><b>Domain: Analyze the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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. \u00a0 Which of the following visualization would you use?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Key influencers<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Funnel chart<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Donut Chart<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Q&amp;A visualization<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: 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.\u00a0 The two most important scenario where key influencers do great are :\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To see the factors that affect the metric being analyzed.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">To contrast the relative importance of the identified factors.\u00a0<\/span><\/li>\n<\/ul>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\"> as Key influencers are a good choice to identify what factors drive the sale and affect the success.<\/span><\/p>\n<p><b>Option B is incorrect. <\/b><span style=\"font-weight: 400;\">The\u00a0funnel\u00a0charts display a linear process that consists of sequential connected stages and the items flow sequentially from one stage to the next stage. They don\u2019t help in identifying the factors that affect a metric.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b> <span style=\"font-weight: 400;\">Donut charts represent the data by dividing it into slices and are not helpful in identifying the key factors.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Q&amp;A\u00a0visualizations allow the users to ask natural language questions and get answers in the form of a visual.\u00a0<\/span><\/p>\n<p><b>References:<\/b><span style=\"font-weight: 400;\"> To know more about the <\/span><span style=\"font-weight: 400;\">visuals<\/span><span style=\"font-weight: 400;\">, please refer to the links below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/visuals-power-bi\/3-effective-visualization\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/visuals-power-bi\/3-effective-visualization<\/span><\/a><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-visualization-influencers\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/visuals\/power-bi-visualization-influencers<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Deploy_and_Maintain_Deliverables\"><\/span><b>Domain: Deploy and Maintain Deliverables<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 21.\u00a0 Promotion and certification are two ways to endorse dataset. Which of the following statements are true about Promotion and Certification? <\/b><b>(Select Multiple Options)<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">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.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">In terms of permission, there is no difference between promotion and certification.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Certification is the ideal way to endorse the dataset when the dataset is ready for broad usage.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A and E<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> 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. \u00a0 Certification enhances the security of the dataset.\u00a0 It is a quite selective process that ensures that only truly reliable and authoritative datasets are utilized across the organization.<\/span><\/p>\n<p><b>Option A is correct<\/b><span style=\"font-weight: 400;\">. Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. 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.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Promotion does not require specific permissions from the admin, whereas Certification needs permission from the dataset owner or admin to access the dataset.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. It is the promotion, not a certification, that is the ideal to endorse the dataset when the datasets are ready for broad usage.<\/span><\/p>\n<p><b>Option E is correct<\/b><span style=\"font-weight: 400;\">. Promotion is the ideal way to endorse the dataset when the dataset is ready for broad usage.<\/span><\/p>\n<p><b>Reference<\/b><span style=\"font-weight: 400;\">: <\/span><span style=\"font-weight: 400;\">To know more about Managing Datasets, please refer to the link below:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/manage-datasets-power-bi\/7-manage-datasets\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/manage-datasets-power-bi\/7-manage-datasets<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Deploy_and_Maintain_Deliverables-2\"><\/span><b>Domain: Deploy and Maintain Deliverables<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 22. Which of the following is not the feature of the \u201cLineage view\u201d in Power BI?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It allows the users\u00a0to troubleshoot the flow of data from its source to its destination.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It simplifies the task of identifying the dashboards and reports that haven&#8217;t been refreshed.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It helps in analyzing the data sets and finding the patterns, trends, and outliers.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The\u00a0Lineage\u00a0view 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.\u00a0 This view is quite crucial in Power BI as<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">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.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It simplifies the task of identifying the dashboards and reports that haven&#8217;t been refreshed.\u00a0<\/span><\/li>\n<\/ul>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as the Lineage view allows the users\u00a0to troubleshoot the flow of data from its source to its destination. In this view, t<\/span><span style=\"font-weight: 400;\">he users can see the path taken by the data from source to destination and identify the pain points and bottlenecks.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as the Lineage view in Power BI <\/span><span style=\"font-weight: 400;\">allows the users to manage the workspaces and analyze the impact of a single change in one dataset to dashboards and reports.<\/span><\/p>\n<p><strong>Option C is incorre<\/strong><b>ct<\/b><span style=\"font-weight: 400;\"> as the Lineage view simplifies the task of identifying the dashboards and reports that haven&#8217;t been refreshed.<\/span><\/p>\n<p><b>Option D is correct<\/b><span style=\"font-weight: 400;\"> as it is the <\/span><i><span style=\"font-weight: 400;\">Quick Insights <\/span><\/i><span style=\"font-weight: 400;\">feature of Power BI, not Lineage view, that helps in analyzing the data sets and finding the patterns, trends, and outliers.<\/span><\/p>\n<p><b>Reference:<\/b> <span style=\"font-weight: 400;\">To know more about the <\/span><span style=\"font-weight: 400;\">Lineage view<\/span><span style=\"font-weight: 400;\">, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-manage-workspaces-power-bi\/5-troubleshoot-data\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-manage-workspaces-power-bi\/5-troubleshoot-data<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Deploy_and_Maintain_Deliverables-3\"><\/span><b>Domain: Deploy and Maintain Deliverables<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI Desktop<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI Desktop optimized for Report Server<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI desktop optimized for Paginated reports<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Power BI Report Builder<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation:<\/b> <span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. Using <\/span><span style=\"font-weight: 400;\">Power BI Desktop is not the correct answer. The Power BI Desktop needs to be optimized for the Report Server.<\/span><\/p>\n<p><b>Option B is correct.<\/b> <span style=\"font-weight: 400;\">Using Power BI Desktop optimized for Report Server is the right tool that needs to be used <\/span><span style=\"font-weight: 400;\">to create the Power BI reports for Power BI Report Server.<\/span><\/p>\n<p><b>\u00a0Option C is incorrect<\/b><span style=\"font-weight: 400;\">. <\/span><span style=\"font-weight: 400;\">Power BI desktop optimized for Paginated reports is not the right tool for the purpose.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Power BI Desktop optimized for Report Server, not Power BI Report Builder, should be used <\/span><span style=\"font-weight: 400;\">to create the Power BI reports for Power BI Report Server.<\/span><\/p>\n<p><b>Reference:<\/b> <span style=\"font-weight: 400;\">To know more about Power BI Desktop, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/report-server\/install-powerbi-desktop?WT.mc_id=DP-MVP-5003635\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/report-server\/install-powerbi-desktop?WT.mc_id=DP-MVP-5003635<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Prepare_the_Data-3\"><\/span><b>Domain: Prepare the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Building an application for monitoring the changes in the database and pushing them out utilizing the real-time streaming API<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Migrating the content to Power BI Premium<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Adding an SSAS tabular layer on top and enabling the Live connections<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Convert to DirectQuery to access the data warehouse.<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: 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.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">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\u2019t need to deal with such problems. Also, DirectQuery has no limitation of the 1-GB dataset.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\">. 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.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Migrating the content to Power BI Premium won\u2019t help in achieving the goal.\u00a0<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Adding an SSAS tabular layer on top and enabling the Live connections won\u2019t help in achieving the goal.<\/span><\/p>\n<p><b>Option D is correct<\/b><span style=\"font-weight: 400;\">. Convert to DirectQuery to access the data warehouse is the right approach to achieve the goal.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the DirectQuery approach, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-use-directquery\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-use-directquery<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Prepare_the_Data-4\"><\/span><b>Domain: Prepare the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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.<\/b><\/p>\n<p><b>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?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Changing the data model by extending the consumers table with an Index column\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Changing the data model by extending consumer table with a Counter column\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Modifying the consumers\u2019 query by adding an Index column<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Modifying the consumers\u2019 query by adding a Counter column<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">Query editor has an option Index Column to add an indexed column starting from 1,0 or any custom number. \u201cInsert Index Column\u201d is present in the \u201cAdd Column\u201d 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.<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Modifying the consumers query by adding an Index column is the best way to add a new ID column to the consumer table.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Modifying the consumers query by adding an Index column is the best way to add a new ID column to the consumer table.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> Modifying the consumers\u2019 query by adding an Index column is the best way to add a new ID column to the consumer table.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Modifying the consumers\u2019 query by adding an Index column is the best way to add a new ID column to the consumer table.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about \u201cInsert Index Column\u201d, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/powerbi.microsoft.com\/fr-fr\/blog\/4-new-updates-in-power-query\/\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/powerbi.microsoft.com\/fr-fr\/blog\/4-new-updates-in-power-query\/<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Prepare_the_Data-5\"><\/span><b>Domain: Prepare the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 26. Why is it advised to avoid the NULL values in the numeric column?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DAX expression having SUM function on such data will provide incorrect results.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DAX expression having MAX function on such data will provide incorrect results.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DAX expression having an AVERAGE function on such data will provide incorrect results.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">DAX Expressions can\u2019t be applied if a numeric column has one or multiple NULL values.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">All the above<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> AVERAGE function calculates the average by considering the total and dividing that by the number of non-null values. As Null values won\u2019t be considered, the returned average will be greater than the accurate average.<\/span><\/p>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as the SUM function will ignore the null values. As Null values are just like zero, it will return the accurate result.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as the MAX expression will take the maximum non-null value and therefore return the correct result.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\"> 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\u2019t be considered, the returned average will be greater than the accurate average.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option E is incorrect.<\/b><span style=\"font-weight: 400;\"> Option C is the correct answer.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about DAX expressions and data shaping, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/2-shape-data\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/clean-data-power-bi\/2-shape-data<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Prepare_the_Data-6\"><\/span><b>Domain: Prepare the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 27. <\/b><b>Consider the following table:<\/b><\/p>\n<p><b>After you pivot the columns, the table appears as shown below:<\/b><\/p>\n<p><b>As you can see, there is an Error in the 3<\/b><b>rd<\/b><b> row. How would you fix this error? The solution needs to preserve all the data.<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">For the key column, use \u201cDuplicate Values\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Rename column3<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use \u201cRemove Errors\u201d for Column3<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Modify the Data Type of the Value Column<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Change the Aggregate Value Function of the Pivot<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: E<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">Changing the Aggregate Value Function of the Pivot is the right answer.<\/span> <span style=\"font-weight: 400;\">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\u2019t choose the Sum option:<\/span><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Using duplicate values won\u2019t help in resolving the issue.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\">. Renaming the column won\u2019t help in resolving the issue.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Using \u201cRemove Error\u201d is not the correct choice.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. Modifying the Data Type of the Value column won&#8217;t help in resolving the issue.<\/span><\/p>\n<p><b>Option E is correct.<\/b><span style=\"font-weight: 400;\"> Changing the Aggregate Value Function of the Pivot is the right answer.<\/span> <span style=\"font-weight: 400;\">While using the Pivot feature, you need to take care of the Aggregate Value Functions.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about Pivot and Unpivot columns, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/databear.com\/power-bi-pivot-and-unpivot-columns\/\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/databear.com\/power-bi-pivot-and-unpivot-columns\/<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Analyze_the_Data-3\"><\/span><b>Domain: Analyze the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 28. Which of the following are the potential ways to enhance the performance of a report<\/b><span style=\"font-weight: 400;\">?<\/span><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Restrict the number of data points shown in a visual for example in a table with the help of the Top N filter.\u00a0\u00a0<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Optimize the DAX expressions to iterate through fewer rows<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Split out the dimensions and associated attributes into their own tables minimizing the number of columns within a fact tables<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Reduce the number of bookmarks applied to a report.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Use FILTER as parts of CALCULATE measure instead of writing the filter condition directly within the function<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: A, B, C, D<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option A is correct.<\/b><span style=\"font-weight: 400;\"> To aggregate the data to reduce the number of rows is a potential way to enhance the performance of a report.<\/span><\/p>\n<p><b>Option B is correct.<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> Optimizing the DAX expressions to iterate through a fewer number of rows is a potential way to enhance the performance of a report.<\/span><\/p>\n<p><b>Option D is correct.<\/b><span style=\"font-weight: 400;\">\u00a0 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.<\/span><\/p>\n<p><b>Option E is incorrect<\/b><span style=\"font-weight: 400;\">. Reducing the number of bookmarks applied on a report won\u2019t help in improving the performance of a report.<\/span><\/p>\n<p><b>Option F is incorrect<\/b><span style=\"font-weight: 400;\">. Utilizing FILTER as parts of CALCULATE measure instead of writing the filter condition directly within the function won\u2019t help in improving the performance of a report.<\/span><\/p>\n<p><b>Reference: <\/b><b>\u00a0<\/b><span style=\"font-weight: 400;\">To know more about the<\/span> <span style=\"font-weight: 400;\">report performance, visit the below link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization?WT.mc_id=DP-MVP-5003635\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/guidance\/power-bi-optimization?WT.mc_id=DP-MVP-5003635<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Analyze_the_Data-4\"><\/span><b>Domain: Analyze the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 29. There is a dataset containing the survey results for the percentage of Facebook usage by Gender, year, and age.\u00a0 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.<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Here is the list of some actions that might be performed.<\/span><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400;\">A. Set the group type to Bin<\/span><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400;\">B.Set the Bin size to 4<\/span><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400;\">C. Set the Bin Count to 15<\/span><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400;\">D. Set the Bin count to 4<\/span><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400;\">E. Set Group type to list<\/span><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400;\">F. Set the Bin type to the number of Bins<\/span><\/p>\n<p><span style=\"font-size: 16px; font-weight: 400;\">G. Right-click on the column Age and Choose New Group<\/span><\/p>\n<p><b>Choose the correct sequence of the actions (you may choose some or all actions from the given list) that you would perform.<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">a-b-c-f-g<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">a-c-b-g-h<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">a-b-c-e-g<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">g-a-f-d<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">a-g-f-d<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> The correct sequence to be followed is:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Right Click on the column Age and choose New Group.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Set Group Type to Bin<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Set Bin Type to number of bins<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Set Bin Count to 4<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">So, the correct sequence is &#8211; g-a-f-d<\/span><\/p>\n<p><span style=\"font-weight: 400;\">First of all, you need to right-click on the column &#8220;Age&#8221; and choose the New Group.\u00a0 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.\u00a0 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.\u00a0 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.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Reference:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">To know more about Grouping and Binning, please go through the link below:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0<\/span><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-grouping-and-binning\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/create-reports\/desktop-grouping-and-binning<\/span><\/a><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Deploy_and_Maintain_Deliverables-4\"><\/span><b>Domain: Deploy and Maintain Deliverables<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 30. Which of the below-given settings are possible to be managed in a dataset in Power BI Service?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A. Adding a new data source<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B. Adding a new DAX measure<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C. Configure Scheduled Refreshes<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D. View the refresh history<\/span><\/p>\n<p><span style=\"font-weight: 400;\">E. Creating a new table relationship<\/span><\/p>\n<p><span style=\"font-weight: 400;\">F. If you are not the current owner, you can take over the dataset.<\/span><\/p>\n<p><b>Correct Answer:<\/b><span style=\"font-weight: 400;\"> C, D, F<\/span><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">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.<\/span><\/p>\n<p><b>Option A is incorrect. <\/b><span style=\"font-weight: 400;\">Adding a new data source is not possible in the Power BI service. It is done in Power BI Desktop<\/span><b>.<\/b><\/p>\n<p><b>Option B is incorrect. <\/b><span style=\"font-weight: 400;\">Adding a new DAX measure is not possible in the Power BI service. It is done in Power BI Desktop<\/span><b>.<\/b><\/p>\n<p><b>Option C is correct. <\/b><span style=\"font-weight: 400;\">You can configure scheduled refreshes in Power BI Service<\/span><b>.<\/b><\/p>\n<p><b>Option D is correct. <\/b><span style=\"font-weight: 400;\">You can view the refresh history in a dataset in Power BI Service<\/span><b>.<\/b><\/p>\n<p><b>Option E is incorrect. <\/b><span style=\"font-weight: 400;\">It is not possible to create a new table relationship in Power BI Services. It is done in Power BI Desktop<\/span><b>.<\/b><\/p>\n<p><b>Option F is correct. <\/b><span style=\"font-weight: 400;\">If you are not the current owner, you can take over the dataset in Power BI Service.<\/span><\/p>\n<p><b>Reference:\u00a0 <\/b><span style=\"font-weight: 400;\">To know more about the Scheduled Refresh, please click the below-given link:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/refresh-scheduled-refresh?WT.mc_id=DP-MVP-5003635\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/refresh-scheduled-refresh?WT.mc_id=DP-MVP-5003635<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Deploy_and_Maintain_Deliverables-5\"><\/span><b>Domain: Deploy and Maintain Deliverables<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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?<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A. Use Incremental Refresh feature only for the data sources supporting query folding<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B. RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh<\/span><\/p>\n<p><span style=\"font-weight: 400;\">C. Use Incremental Refresh feature for all data sources<\/span><\/p>\n<p><span style=\"font-weight: 400;\">D. A date field is needed on a table in the dataset<\/span><\/p>\n<p><b>Correct Answers: A, B, and D<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\"> 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&#8217;t use incremental refresh without a date filed.<\/span><\/p>\n<p><b>Option A is correct.<\/b><span style=\"font-weight: 400;\"> 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.<\/span><\/p>\n<p><b>Option B is correct.<\/b><span style=\"font-weight: 400;\"> RangeStart and RangeEnd are two PowerQuery parameters that are needed for the incremental Refresh to filter the datasets.<\/span><\/p>\n<p><b>Option C is incorrect.<\/b><span style=\"font-weight: 400;\"> Incremental Refresh Feature should be used only for the data sources supporting query folding.<\/span><\/p>\n<p><b>Option D is correct.<\/b><span style=\"font-weight: 400;\"> A date field is needed on a table in the dataset to specify how incremental record changes will be returned by the filter.<\/span><\/p>\n<p><b>References:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">To know more about the Incremental Refresh, please click the below-given link:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/manage-datasets-power-bi\/6-incremental-refresh\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/manage-datasets-power-bi\/6-incremental-refresh<\/span><\/a><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/admin\/service-premium-incremental-refresh\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/admin\/service-premium-incremental-refresh<\/span><\/a><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Deploy_and_Maintain_Deliverables-6\"><\/span><b>Domain: Deploy and Maintain Deliverables<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 32. Which of the following is not a benefit offered by the workspaces?<\/b><\/p>\n<p><b>A. Workspaces can be used to house dashboards and reports for use by multiple teams.\u00a0<\/b><\/p>\n<p><b>B. Workspaces allow you to share and present dashboards and reports in a single environment.<\/b><\/p>\n<p><b>C. Workspaces allow you to view and edit the data model, create visualizations and transform the data.<\/b><\/p>\n<p><b>D. Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets.<\/b><\/p>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation:<\/b><span style=\"font-weight: 400;\">\u00a0 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:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">workspaces can be used to house dashboards and reports for use by multiple teams.<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Workspaces allow you to share and present dashboards and reports in a single environment.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets.<\/span><\/li>\n<\/ul>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as workspaces can be used to house dashboards and reports for use by multiple teams.<\/span><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as <\/span><span style=\"font-weight: 400;\">Workspaces allow you to share and present dashboards and reports in a single environment.<\/span><\/p>\n<p><b>Option C is correct<\/b><span style=\"font-weight: 400;\"> as <\/span><span style=\"font-weight: 400;\">To view and edit the data model, create visualizations and transform the data <\/span><span style=\"font-weight: 400;\">is not the feature or benefit offered by the workspaces.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\"> as Workspaces ensure the highest level of security by controlling who can access the dashboards, reports, and datasets.<\/span><\/p>\n<p><b>Reference:<\/b> <span style=\"font-weight: 400;\">To know more about the <\/span><span style=\"font-weight: 400;\">Workspaces<\/span><span style=\"font-weight: 400;\">, please check the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-manage-workspaces-power-bi\/1-introduction\" target=\"_blank\" rel=\"noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/create-manage-workspaces-power-bi\/1-introduction<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"OutDated_Questions\"><\/span><span style=\"text-decoration: underline;\"><strong>OutDated Questions<\/strong><\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>&nbsp;<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Prepare_the_Data-7\"><\/span><b>Domain: Prepare the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>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?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Adding the folder data source; using the Append Queries command<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Adding the folder data source; using the Combine Files Command<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Adding every single file to the model and then using Merge Query Command<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Adding the MS Excel Data Source; selecting all files of the folder<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Adding a folder data source and using the Merge Queries Command<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: B<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">Adding a folder data source and using the Combine Files command is the right choice.<\/span> <span style=\"font-weight: 400;\">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.\u00a0<\/span><\/p>\n<p><b>Option A <\/b><b>is incorrect.<\/b><span style=\"font-weight: 400;\"> You need to use the Combine Files command rather than the Append Queries command.<\/span><\/p>\n<p><b>Option B is correct.<\/b><span style=\"font-weight: 400;\"> Adding a folder data source and using the Combine Files Command is the right choice to achieve the goal.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\">. Adding every single file to the model and then using Merge Queries Command is not the right choice.<\/span><\/p>\n<p><b>Option D is incorrect.<\/b><span style=\"font-weight: 400;\"> Adding a Microsoft Excel Data Source and selecting all files of the folder is not the right choice.<\/span><\/p>\n<p><b>Option E is incorrect<\/b><span style=\"font-weight: 400;\">. You need to use the Combine Files command rather than the Merge Queries command.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about combining files, please refer to the doc below:<\/span><\/p>\n<p><a href=\"https:\/\/support.microsoft.com\/en-ie\/office\/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/support.microsoft.com\/en-ie\/office\/combine-files-in-a-folder-with-combine-binaries-power-query-94b8023c-2e66-4f6b-8c78-6a00041c90e4<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Analyze_the_Data-5\"><\/span><b>Domain: Analyze the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 2. Which of the following is not a core component of Q &amp; A Visualization?<\/b><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">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.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A pre-populated list of suggested questions.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An icon that can be selected by the users to convert the Q&amp;A visual into a standard visual.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An icon that can be selected by the users to automatically create a custom tooltip<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An icon that can be selected by the users to open Q&amp;A tooling where they can configure the underlying natural language engine.\u00a0<\/span><\/li>\n<\/ol>\n<p><b>Correct Answer: D<\/b><\/p>\n<p><b>Explanation<\/b><span style=\"font-weight: 400;\">: In <\/span><span style=\"font-weight: 400;\">Q&amp;A,\u00a0visualization 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&amp;A analysis are as given below:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">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.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">A pre-populated list of suggested questions.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An icon that can be selected by the users to convert the Q&amp;A visual into a standard visual.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">An icon that can be selected by the users to open Q&amp;A tooling where they can configure the underlying natural language engine.\u00a0<\/span><\/li>\n<\/ul>\n<p><b>Option A is incorrect<\/b><span style=\"font-weight: 400;\"> as \u201cQuestion Box\u201d is the core component of Q&amp;A analysis.<\/span><\/p>\n<p><b>Option B is incorrect<\/b><span style=\"font-weight: 400;\"> as \u201cA pre-populated list of suggested questions\u201d is also a core component of Q&amp;A analysis.<\/span><\/p>\n<p><b>Option C is incorrect<\/b><span style=\"font-weight: 400;\"> as \u201cAn icon that can be selected by the users to convert the Q&amp;A visual into a standard visual\u201d is a core component of Q&amp;A analysis.<\/span><\/p>\n<p><b>Option D is correct<\/b><span style=\"font-weight: 400;\"> as \u201cAn icon that can be selected by the users to automatically create a custom tooltip\u201d is not a core component of Q&amp;A analysis.<\/span><\/p>\n<p><b>Option E is incorrect<\/b><span style=\"font-weight: 400;\"> as \u201cAn icon that can be selected by the users to open Q&amp;A tooling where they can configure the underlying natural language engine\u201d is a core component of Q&amp;A analysis.<\/span><\/p>\n<p><b>Reference:<\/b><span style=\"font-weight: 400;\"> To know more about the Q&amp;A Analysis, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/visuals-power-bi\/3-effective-visualization\" target=\"_blank\" rel=\"nofollow noopener\"><span style=\"font-weight: 400;\">https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/visuals-power-bi\/3-effective-visualization<\/span><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Domain_Model_the_Data-5\"><\/span><b>Domain: Model the Data<\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><b>Question 3. You have a CSV file having the workers&#8217; badging. There is a column \u201cStarting Time\u201d in the file and the data in this column exists in the format like <\/b><b><i>2020-12-25 at 10:00<\/i><\/b><b>.<\/b><\/p>\n<p><b>You need to analyze the Workers\u2019 Badging trend with the column \u201cStarting Time\u201d and utilize a built-in date hierarchy. What would you do?<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a column by example starting with <\/span><i><span style=\"font-weight: 400;\">2020-12-25<\/span><\/i><\/li>\n<\/ul>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Duplicate the column \u201cStarting Time\u201d and apply the TRIM function<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Create a column by example starting with <\/span><i><span style=\"font-weight: 400;\">2020-12-25 and set \u201cDATE\u201d as the data type of the new column\u00a0<\/span><\/i><\/li>\n<\/ul>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><i><span style=\"font-weight: 400;\">Create a new Date table with the help of the CALENDER function<\/span><\/i><\/li>\n<\/ul>\n<p><b>Correct Answer: C<\/b><\/p>\n<p><b>Explanation: <\/b><span style=\"font-weight: 400;\">For using the built-in date hierarchy, you need to create a new column by example starting with <\/span><i><span style=\"font-weight: 400;\">2020-12-25 and set \u201cDATE\u201d as the data type of that column.\u00a0<\/span><\/i><\/p>\n<p><b>Option A is incorrect.<\/b><span style=\"font-weight: 400;\"> Just creating a column by example starting with <\/span><i><span style=\"font-weight: 400;\">2020-12-25 won\u2019t allow using <\/span><\/i><span style=\"font-weight: 400;\">the<\/span> <span style=\"font-weight: 400;\">built-in date hierarchy.<\/span><\/p>\n<p><b>Option B is incorrect.<\/b><span style=\"font-weight: 400;\"> Duplicating the column \u201cStarting Time\u201d and applying the TRIM function is not the right option.<\/span><\/p>\n<p><b>Option C is correct.<\/b><span style=\"font-weight: 400;\"> Creating a column by example starting with <\/span><i><span style=\"font-weight: 400;\">2020-12-25 and setting \u201cDATE\u201d as the data type of new column <\/span><\/i><span style=\"font-weight: 400;\">will allow you to use <\/span><i><span style=\"font-weight: 400;\">the <\/span><\/i><span style=\"font-weight: 400;\">built-in date hierarchy.<\/span><\/p>\n<p><b>Option D is incorrect<\/b><span style=\"font-weight: 400;\">. <\/span><i><span style=\"font-weight: 400;\">Creating a new Date table with the help of the CALENDER function <\/span><\/i><span style=\"font-weight: 400;\">is not the right option.<\/span><\/p>\n<p><b>Reference: <\/b><span style=\"font-weight: 400;\">To know more about the date hierarchy, please refer to the link below:<\/span><\/p>\n<p><a href=\"https:\/\/5minutebi.com\/2017\/11\/29\/how-to-use-powerbi-date-hierarchy\" target=\"_blank\" rel=\"nofollow noopener\"><b>https:\/\/5minutebi.com\/2017\/11\/29\/how-to-use-powerbi-date-hierarchy<\/b><\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Final_Words\"><\/span>Final Words<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>I hope you&#8217;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.<\/p>\n<p>Whizlabs offers you the PL-300 exam preparation materials to pass the certification exam. With the help of our video courses, practice exams, <a href=\"https:\/\/www.whizlabs.com\/labs\/\" target=\"_blank\" rel=\"noopener\">hands-on labs<\/a>, and <a href=\"https:\/\/www.whizlabs.com\/power-bi-sandbox\/\" target=\"_blank\" rel=\"noopener\">Power BI sandboxes<\/a> for in-the-moment testing.<\/p>\n<p>If you have any clarifications or doubts, please feel free to comment us!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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, [&hellip;]<\/p>\n","protected":false},"author":386,"featured_media":88424,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[10],"tags":[3983,5002],"class_list":["post-88416","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud-computing-certifications","tag-microsoft-power-bi","tag-pl-300-exam"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",1280,720,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-150x150.webp",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-300x169.webp",300,169,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-768x432.webp",768,432,true],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-1024x576.webp",1024,576,true],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",1280,720,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",1280,720,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",24,14,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",48,27,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",96,54,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",150,84,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300.webp",300,169,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-250x250.webp",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-640x720.webp",640,720,true],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-96x96.webp",96,96,true],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2023\/04\/Free-questions-for-Microsoft-Power-BI-Data-Analyst-Exam-PL-300-150x84.webp",150,84,true]},"uagb_author_info":{"display_name":"Basant Singh","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/basant-singh\/"},"uagb_comment_info":469,"uagb_excerpt":"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&hellip;","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/88416","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/386"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=88416"}],"version-history":[{"count":20,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/88416\/revisions"}],"predecessor-version":[{"id":90495,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/88416\/revisions\/90495"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/88424"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=88416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=88416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=88416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}