nerdexam
Microsoft

DP-500 · Question #148

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might…

The correct answer is B. No. Converting a time column to the Text data type is unlikely to resolve processing issues for a time series machine learning model, as these models typically require numerical or specific datetime formats.

Query and transform data

Question

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power Query query in a Power BI report. The query maps source database columns to the input columns of a time series machine learning model. You discover that the model fails to process a source time field. You need to ensure that the model processes the field. Solution: You convert the time column into the Text data type. Does this meet the requirement?

Exhibit

DP-500 question #148 exhibit

Options

  • AYes
  • BNo

How the community answered

(26 responses)
  • A
    31% (8)
  • B
    69% (18)

Why each option

Converting a time column to the Text data type is unlikely to resolve processing issues for a time series machine learning model, as these models typically require numerical or specific datetime formats.

AYes

Converting a time column to a Text data type would render it unsuitable for a time series machine learning model, which needs to interpret the temporal nature of the data.

BNoCorrect

Time series machine learning models specifically rely on numerical or datetime data types to identify temporal patterns and sequences. Converting a time column to Text would prevent the model from interpreting it as a time-based feature, leading to processing failure.

Concept tested: Data type requirements for time series ML models

Source: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-timeseries-forecasting

Topics

#Data types#Power Query#Data transformation#Time Series Models

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-500 Practice