Free PL-300 Exam Braindumps (page: 24)

Page 24 of 62

HOTSPOT (Drag and Drop is not supported)
You have the Power BI data model shown in the following exhibit.



You need to create a measure to count the number of product categories that had products sold during a selected period.

How should you complete the DAX expression? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com.
The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00.
The report is a single page that contains 15 AppSource visuals and 10 default visuals.
Users say that the report is slow to load the visuals when they access and interact with the report.
You need to recommend a solution to improve the performance of the report.
What should you recommend?

  1. Enable visual interactions.
  2. Change any DAX measures to use iterator functions.
  3. Implement row-level security (RLS).
  4. Remove unused columns from tables in the data model.

Answer(s): D



HOTSPOT (Drag and Drop is not supported)
You have the Power BI data model shown in the following exhibit.



The Sales table has the following columns.



The data model must support the following analysis:

-Total sales by product by month in which the order was placed
-Quantities sold by product by day on which the order was placed
-Number of sales transactions by quarter in which the order was placed

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

  1. See Explanation section for answer.

Answer(s): A

Explanation:



You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.
What should you do?

  1. Create a column by example that starts with 2018-12-31 and set the data type of the new column to Date
  2. Create a column by example that starts with 2018-12-31
  3. Apply a transformation to extract the last 11 characters of the Logged column
  4. Add a conditional column that outputs 2018 if the Logged column starts with 2018 and set the data type of the new column to Whole Number

Answer(s): D



Page 24 of 62



Post your Comments and Discuss Microsoft PL-300 exam with other Community members:

Tejaswini commented on December 19, 2024
For my understanding
Anonymous
upvote

Tejaswini commented on December 19, 2024
Going throught questions for practice
Anonymous
upvote

Sheetal commented on November 24, 2024
Just going through the questions for my understanding of Power Bi
Anonymous
upvote

Eb'Oney commented on November 12, 2024
I think the answer here should be B. Split the Logged column by using at as the delimiter
UNITED STATES
upvote

Anouar commented on November 08, 2024
contenu enrichissant
Anonymous
upvote

Anouar commented on November 08, 2024
Salut ! Quelqu'un a-t-il tenté cet examen récemment ? Si c'est le cas, veuillez me faire savoir si ces questions sont toujours pertinentes et apparaissent dans l'examen sous le même
Anonymous
upvote

Luntz commented on November 05, 2024
If you want to just prepare for your exam and then clear it then this is a good source. But not for deep learning.
GERMANY
upvote

Gutsy commented on November 05, 2024
Pretty clear and close to content of real exam.
UNITED STATES
upvote

Jeron commented on October 15, 2024
Family hard exam. Unless you're an expert you cannot pass without using these exams.
UNITED KINGDOM
upvote

Elon commented on September 29, 2024
Hi! Has anyone attempted this exam recently? If so, please let me know if these questions are still relevant and appearing in the exam in the same format.
Anonymous
upvote

lala commented on September 26, 2024
really helping
Anonymous
upvote

Subrata commented on September 19, 2024
Good questions
Anonymous
upvote

Sulaksha commented on September 16, 2024
Good site to practice
Anonymous
upvote

Hatime commented on August 24, 2024
please i neeed more explantation over Question 10: why response C is incorrect??
Anonymous
upvote

Dinona commented on August 20, 2024
Good questions for practicing
Anonymous
upvote

zubair commented on August 05, 2024
Good Site to practice
PAKISTAN
upvote

john commented on August 04, 2024
good website
UNITED STATES
upvote

Pradeep commented on August 02, 2024
This is very informative
UNITED STATES
upvote

Prajwal commented on July 21, 2024
good websit for learning
Anonymous
upvote

Reet commented on July 08, 2024
This site is nyc
Anonymous
upvote

Reet commented on July 08, 2024
This site is very useful
Anonymous
upvote

Pinkey commented on July 08, 2024
Very useful this site
Anonymous
upvote

Rasmita commented on July 08, 2024
This link very helpfull
Anonymous
upvote

Your Guardian Angel commented on July 02, 2024
I have pl 300 certification exam in few days. if this is helpful i will update here (if there is no update from my side then this is waste of time ).
Anonymous
upvote

Adam commented on June 27, 2024
Passed this exam today. Valid dumps.
UNITED KINGDOM
upvote

Alven commented on June 21, 2024
I found this site extremely useful and the PDF is well formed. I had used other sites before where the PDF was full of watermark and typos, grammar mistakes and missing exhibits. This site provides the best one.
EUROPEAN UNION
upvote

Santosh K commented on June 21, 2024
In order to pass this exam you need this exam dumps. You will not be able to pass without knowing the questions. Thanks to sites like this.
UNITED STATES
upvote

Anonymous commented on June 17, 2024
Extremely useful and well formed questions for PL - 300 preparations
Anonymous
upvote

Baboo commented on June 16, 2024
wah bhai wah... Ek Dam Superb!
INDIA
upvote

Damyan commented on June 16, 2024
Very good material. The price is right and the content is well covered. The test engine software needs some improvements as per me opinion which I already shared with support team. Aside for that spot on!
Anonymous
upvote

Lulu commented on June 06, 2024
Good material!
Anonymous
upvote

Anonymous commented on May 01, 2024
good so far
PHILIPPINES
upvote

Janiece commented on April 20, 2024
This is preparation package is very nicely put together. It covers every single topic of the exam.
United States
upvote

Preemjeet commented on April 11, 2024
Questions are valid in India. Get the PDF which has all the questions. Free version does not include all questions and explanations.
INDIA
upvote