DP-500 · Question #151
DP-500 Question #151: Real Exam Question with Answer & Explanation
Sign in or unlock DP-500 to reveal the answer and full explanation for question #151. The question stem and answer options stay visible for context.
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
Unlock DP-500 to see the answer
You've previewed enough free DP-500 questions. Unlock DP-500 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.