QUESTION NO: 2You are creating a Microsoft Power BI data model that has the tables shown in the following table. The Products table is related to the ProductCategory table through the ProductCategoryID column.You need to ensure that you can analyze sales by product category.How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
This PL-300(earlier named as DA-100) Certification Exam: Microsoft Power BI Data Analyst certification is for data analysts. This certificate is crucial for you if you use Power BI to create data visualizations. The DA-100 course teaches you to design scalable data models, clean and transform data and present analytic insights. This set of 25 DA 100 exam questions will cover the important skills measured in the DA-100 Exam such as:
These DA 100 exam questions will give you a very good idea of how the actual exam would look like; you can practice more with our DA-100 practice exam. Latest Update 2022: The Exam DA-100 Analyzing Data with Microsoft Power BI has been expired on March 31, 2022 and the name changed to PL-300 Microsoft Power BI Data Analyst. Microsoft Power BI – DA 100 Exam QuestionsModel the dataQ 1. You are interested in creating a measure that will always calculate the total sales for 2020, irrespective of the year selected in any other visual in Power BI. Which of the following is the right way to create such a measure?A. Total Sales for 2020= CALCULATE(SUM(‘Sales OrderDetails'[Total Price]), YEAR(‘Sales OrderDetails'[orderdate]) = 2020) B. Total Sales for 2020= SUM(CALCULATE(‘Sales OrderDetails'[Total Price]), YEAR(‘Sales OrderDetails'[orderdate]) = 2020) C. Total Sales for 2020= TOTAL(SUM(‘Sales OrderDetails'[Total Price]), YEAR(‘Sales OrderDetails'[orderdate]) = 2020) D. It is not possible to create such a measure. Correct Answer: A The CALCULATE function in DAX helps in creating a measure that will override the specific portions of the context that are being utilized to express the correct result. The syntax to use the calculate function is: CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]]) Where expression represents the expression that is to be evaluated and Filter1, Filter2 are optional and represent the table or Boolean expressions that define filters, or filter modifier functions. As an example, the following measure can be created for the SALES table that will calculate the revenue for the only products that have a blue color. Blue Revenue = CALCULATE( SUM(Sales[Sales Amount]), ‘Product'[Color] = “Blue” )
Q 2. Consider the below-given sample data:
You need to create a calculated column to show the date in a format like this February 01, 2021. Which of the following DAX expression would you use?A. FORMAT([Date],”M”)|| FORMAT([Date],”D”)|| FORMAT([Date],”Y”) B. FORMAT([Date],”MMMM DD, YYYY”) C. FORMAT([Date],”MMM”)|| FORMAT([Date],”DD”)|| FORMAT([Date],”YYYY”) D. FORMAT(‘Date_Table’ [Date],”MMM”)|| FORMAT(‘Date_Table’ [Date],”DD”)|| FORMAT(‘Date_Table’ [Date],”YYYY”) Correct Answer: B
Q 3. The data model has an impact on the time consumed in the refreshing of a model but once the model is loaded in the memory, it has no impact on the performance of the reports. Select whether the statement is True/False.A. True Correct Answer: B Q 4. What will be the result of the following DAX formula if the year 2020 is chosen on a slicer of a report?
|