Coursera Microsoft Power BI Data Analyst • STUDY MODE
Practice Quiz
QUESTION 1 OF 5
When optimizing the data types in the Customers table, how did you ensure that the Customer ID is correctly recognized?
A
By setting Customer ID as a Decimal Number to account for varying values.
B
By setting Customer ID as a numeric identifier as a Whole Number.Correct Answer
C
By marking Customer ID as a Text data type to ensure clarity.
QUESTION 2 OF 5
Based on observation of the first 10 records in the Orders table, which payment method was used the most by Adventure Works’ customers?
A
Cash
B
Credit CardCorrect Answer
C
Debit Card
QUESTION 3 OF 5
In the context of Adventure Works, what type of relationship did you create between the Customers and Orders tables based on their shared Customer ID columns?
A
Many-to-many.
B
Many-to-one.
C
One-to-many.Correct Answer
QUESTION 4 OF 5
What action did you take to optimize the Order total column in the Orders table?
A
It was adjusted to Decimal number.Correct Answer
B
It was adjusted to Whole number.
C
It was adjusted to Text.
QUESTION 5 OF 5
What action did you take to disable the Auto Date/Time feature in Power BI?
A
Uncheck the Auto Date/Time checkbox in Data Load options.Correct Answer
B
Access the File tab and select Data Preferences.
C
Modify date properties in the Options window.
Ready to test your recall?
When optimizing the data types in the Customers table, how did you ensure that the Customer ID is correctly recognized?
A
By setting Customer ID as a Decimal Number to account for varying values.
B
By setting Customer ID as a numeric identifier as a Whole Number.
C
By marking Customer ID as a Text data type to ensure clarity.