Adaface Sample Power BI Questions

Review the following table in Power BI:

Here’s the visualisation generated when Book and ReadingChallenges columns are added to a table visualisation:

Why do we see only 4 rows?

Consider the following two tables in Power BI:

We received the following error when we tried to set many-to-one cardinality between devices to users tables: “The cardinality you selected isn’t valid for this relationship”. What should we do before creating the many-to-one relationship?

Review the following Microsoft SQL Server table:

Complete the following Power Query formula used to create a custom column to replace the numbers present in last 11 characters of ISBN with 11 ‘*’. Example ‘978-0-365-51051-4’ is converted to ‘978-0-***-*****-*’

A: Text.Insert
            B: Text.Replace
            C: Text.Start
            D: Text.End

We want to create a DAX formula in Power BI that automatically calculates the previous month number. If month is May, the formula would return 4. We have already created the DAX formula: 

Today Month = MONTH (Sales[Todays Date])

Which of the DAX formulas below would be the right choice next?

A: Previous Month = Sales[Today Month]-1
            B: Previous Month = PREVIOUSMONTH(Sales[Today Month])
            C: Previous Month = STARTOFMONTH(Sales[Today Month])-1
            D: Previous Month = IF (Sales[Today Month] =1, 12,Sales[Today Month]-1) (correct)

Consider the following Microsoft SQL Server tables:

Which of the following will enable us to import sample data from Sales table in Power BI Desktop?
            
            A: Query Editor → Filter table by Sale Date
            B: Power BI Model → Create a calculated table
            C: Query Editor → Create a custom column using sample function
            D: Query Editor → Add SELECT statement with WHERE clause on Date