Discuss Microsoft PL-300 Exam Topic 1 Question 19

The table has the following columns.

You need to add a column that will be used to sort the Year Month column chronologically.

AOption A

BOption B

COption C

DOption D

Suggested Answer: A, D

Answer as.

You publish a dataset lhat contains data from an on-premises Microsoft SQL Server database.

The dataset must be refreshed daily.

You need to ensure that the Power BI service can connect to the database and refresh the dataset.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct

You have a Power BI data model that analyzes product sales ever time. The data model contains the following tables.

A one-to-many relationship exists between the tables.

The auto date/time option for the data model enabled.

You need to reduce the size of the data model while maintaining the ability to analyze product sales by month and quarter.

Which two actions should you perform?

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Catalina 11 months ago

Year Month should be in YYYY-MM format for proper sorting.

Felix 11 months ago

Wait, are we sure this is the best approach?

Crista 12 months ago

I think Option C makes the most sense.

Mickie 12 months ago

Totally agree, sorting is key!

Kassandra 1 year ago

You need a new column for sorting by date.

Beckie 1 year ago

If I remember correctly, we might need to extract the year and month separately to create a sortable date. I hope that’s what they’re looking for!

Zita 1 year ago

I’m a bit confused about which option to choose. I feel like I’ve seen this format before, but I can’t recall the exact steps.

Ashley 1 year ago

I remember practicing a similar question where we had to sort dates, and I think using a date function might be the key here.

Claudio 1 year ago

I think we need to create a new column that converts the Year Month into a date format for sorting, but I'm not entirely sure how to do that.

Lewis 1 year ago

Fractional factorial designs can be tricky, but I remember the key points from class. I think I can eliminate a few of these options pretty quickly.

Stephanie 1 year ago

Hmm, I'm not totally sure about this one. I know Enterprise Security uses a lot of different data sources, so I'm not confident it's just one type of knowledge object. I'll have to think this through carefully.

Loren 1 year ago

I feel pretty confident about this one. The steps outlined seem like a solid approach to meet all the stated goals.

Microsoft PL-300 Exam - Topic 1 Question 19 Discussion