1-43 of 43
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in the query.
You need to analyze IoT events by the hour and day of the year. The solution must
improve dataset performance.
Solution: You remove the IoT GUID column and retain the IoT ID column.
Does this meet the goal?
,A. Yes
B. No
Give this one a try later!
A. Yes
Retain uniquness in IoT ID column after removing IoT GUID column.
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?
A. Apply a transformation to extract the first 11 characters of the logged column.
B. 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.
C. Create a column by example that starts with 2018-12-31 and set the data type of the new column
to Date.
D. Apply a transformation to extract the last 11 characters of the Logged column and set the data
type of the new column to Date.
,Give this one a try later!
C. Create a column by example that starts with 2018-12-31 and set the data type of
the new column to Date.
'Column From Examples' under 'Add Column' using the 2018-12-31 as the example.
You have a Power BI report that imports a date table and a sales table from an Azure SQL
database data source. The sales table has the following date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression
to create Order Date and Delivery Date as calculated tables. Does this meet the goal?
A. Yes
B. No
Give this one a try later!
, A. Yes
Here's a methodology to refactor a model from a single role-playing dimension-type
table, to a design with one table per role.
You have the Power BI data model shown in the following exhibit (first image).
The Sales table contains records of sales by day from the last five years up until
today's date.
You plan to create a measure to return the total sales of March 2021 when March
2022 is selected.
Which DAX expression should you use?
A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
D. SUM(Sales[Sales])
Give this one a try later!
C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
From Power Query Editor, you profile the data shown in the following exhibit.
The IoT GUID and IoT ID columns are unique to each row in the query.
You need to analyze IoT events by the hour and day of the year. The solution must
improve dataset performance.
Solution: You remove the IoT GUID column and retain the IoT ID column.
Does this meet the goal?
,A. Yes
B. No
Give this one a try later!
A. Yes
Retain uniquness in IoT ID column after removing IoT GUID column.
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?
A. Apply a transformation to extract the first 11 characters of the logged column.
B. 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.
C. Create a column by example that starts with 2018-12-31 and set the data type of the new column
to Date.
D. Apply a transformation to extract the last 11 characters of the Logged column and set the data
type of the new column to Date.
,Give this one a try later!
C. Create a column by example that starts with 2018-12-31 and set the data type of
the new column to Date.
'Column From Examples' under 'Add Column' using the 2018-12-31 as the example.
You have a Power BI report that imports a date table and a sales table from an Azure SQL
database data source. The sales table has the following date foreign keys:
✑ Due Date
✑ Order Date
✑ Delivery Date
You need to support the analysis of sales over time based on all the date foreign keys.
Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression
to create Order Date and Delivery Date as calculated tables. Does this meet the goal?
A. Yes
B. No
Give this one a try later!
, A. Yes
Here's a methodology to refactor a model from a single role-playing dimension-type
table, to a design with one table per role.
You have the Power BI data model shown in the following exhibit (first image).
The Sales table contains records of sales by day from the last five years up until
today's date.
You plan to create a measure to return the total sales of March 2021 when March
2022 is selected.
Which DAX expression should you use?
A. Calculate (Sum(Sales[Sales]), PREVIOUSYEAR( dimDate[Date])
B. TOTALYTD (SUM(Sales[Sales]), dimDate[Date] )
C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
D. SUM(Sales[Sales])
Give this one a try later!
C. Calculate (SUM(Sales[Sales]), SAMEPERIODLASTYEAR(dimDate[Date] ))
