nerdexam
Microsoft

DP-500 · Question #151

Based on the provided Power BI M query in Hotspot Question 201 (Source = Sql.Databases("contoso.database.windows.net"); PopulateRows = Source{[Data="AdventureWorksLT"]}[Data]; #"Filtered Rows" =…

The correct answer is B. No. The provided M query is syntactically incomplete and truncated, making it impossible to determine if it meets any specific requirement.

Query and transform data

Question

Based on the provided Power BI M query in Hotspot Question 201 (Source = Sql.Databases("contoso.database.windows.net"); PopulateRows = Source{[Data="AdventureWorksLT"]}[Data]; #"Filtered Rows" = Table.SelectRows(dbo_C1nemas, each [Cityname] = Cityname); #"Renamed Columns" = Table.RenameColumns(#"Filtered Rows",{{Table.ColumnNames(dbo_C1nemas){0},"Cityname"}}), #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"C1nemaID", "PhoneNumber", "FaxNumber", "EmailAddress", "StreetAddress1", "SalesTerritoryID", "C1nemaGroup", "ExternalC1nemaCode", "TotalSales", "CreditRatingID", "Promotions", "DateCreated", "LastModification", "C1nemaGroups", "CreditRatings", "Orders", "SalesTerritories", "StreetAddress3", "Statename"}); #"Renamed Columns1" = Table.RenameColumns(#"Removed Columns",{{"Cityname","City"}}), #"Sorted Rows" = Table.Sort(#"Renamed Columns1",{{"City", Order.Ascending}}), #"Renamed Columns2" = Table.RenameColumns(#"Sorted Rows",{{"StreetAddress3", "Suburb"}, {"Cityname", "City"}})), is the following statement true: 'contoso is the name of an Azure SQL database.'?

Options

  • AYes
  • BNo

How the community answered

(18 responses)
  • A
    6% (1)
  • B
    94% (17)

Why each option

The provided M query is syntactically incomplete and truncated, making it impossible to determine if it meets any specific requirement.

AYes

The M query is malformed and incomplete due to truncation, which prevents it from being a valid and executable query.

BNoCorrect

The M query provided is clearly truncated and incomplete, ending mid-statement with "City" at the end of the last Table.RenameColumns function. This syntactic incompleteness means it cannot be executed or properly evaluated against any requirement.

Concept tested: Power Query M language syntax validity

Source: https://learn.microsoft.com/en-us/powerquery-m/power-query-m-reference

Topics

#Power Query M#Azure SQL Database#Data Source Connection#M language functions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-500 Practice