Join the discussion
Question 1/240
You have a Power Bl report.
You have the following tables.
You have the following DAX measure.
You have the following tables.
You have the following DAX measure.
Correct Answer:
Add Comments
- Other Question (240q)
- Q1. You have a Power Bl report. You have the following tables. (Exhibit) You have the followin...
- Q2. How should you distribute the reports to the board? To answer, select the appropriate opti...
- Q3. You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The d...
- Q4. You need to create a visualization to meet the reporting requirements of the sales manager...
- Q5. You need to calculate the last day of the month in the balance sheet data to ensure that y...
- Q6. You need to create relationships to meet the reporting requirements of the customer servic...
- Q7. You are creating an analytics report that will consume data from the tables shown in the f...
- Q8. You have a folder of monthly transaction extracts. You plan to create a report to analyze ...
- Q9. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q10. You need to address the data concerns before creating the data model. What should you do i...
- Q11. You need to create a visual as shown in the following exhibit. (Exhibit) The indicator col...
- Q12. You are creating a line chart in a Power Bl report as shown in the following exhibit. Use ...
- Q13. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q14. You have a Microsoft Power Bl dashboard. The report used to create the dashboard uses an i...
- Q15. You have the following table named Location. (Exhibit) The GeoCode column represents the c...
- Q16. You have the tables shown in the following table. (Exhibit) The Impressions table contains...
- Q17. You have a query that returns the data shown in the following exhibit. (Exhibit) You need ...
- Q18. You have a Power BI model that contains a table named Sales. Sales has the following three...
- Q19. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q20. You plan to create the chart shown in the following exhibit. (Exhibit) How should you crea...
- Q21. You have a Power BI workspace named BI Data that contains a dataset named BI Finance. You ...
- Q22. In the Power BI service, you create an app workplace that contains several dashboards. You...
- Q23. You use Power Bi Desktop to create a Power Bl data model and a blank report You need to ad...
- Q24. You have a Power B1 model that contains a table named Date. The table has the following co...
- Q25. You have two Azure SQL databases that contain the same tables and columns. For each databa...
- Q26. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q27. You have a Power BI model that contains a table named Sales. Sales has the following three...
- Q28. You have a Power Bl report named Orders that supports the following analysis: * Total sale...
- Q29. You are enhancing a Power BI model that has DAX calculations. You need to create a measure...
- Q30. You have the Power BI data model shown in the following exhibit. (Exhibit) Use the drop-do...
- Q31. You are creating a Power BI report to analyze consumer purchasing patterns from a table na...
- Q32. You plan to create the chart shown in the following exhibit. (Exhibit) How should you crea...
- Q33. What is the minimum number of datasets and storage modes required to support the reports?...
- Q34. You have an API that returns more than 100 columns. The following is a sample of column na...
- Q35. You have a dataset that contains revenue data from the past year. You need to use anomaly ...
- Q36. You open powerbi.com as shown in the following exhibit. Use the drop-down menus to select ...
- Q37. You have a Power Bl report for the marketing department. The report reports on web traffic...
- Q38. You view a query named Transactions as shown in the following exhibit. (Exhibit) The query...
- Q39. You need to provide a user with the ability to add members to a workspace. The solution mu...
- Q40. You need to create the On-Time Shipping report. The report must include a visualization th...
- Q41. You have a Microsoft SharePoint Online site that contains several document libraries. One ...
- Q42. Your company has affiliates who help the company acquire customers. You build a report for...
- Q43. You have a Power Bl visual that uses indicators to show values that are out of range as sh...
- Q44. You are developing a report page. Some users will navigate the report by using a keyboard,...
- Q45. DRAG DROP You are preparing a financial report in Power BI. You connect to the data stored...
- Q46. You are creating a Power Bi model and report. You have a single table in a data mode) name...
- Q47. You need to create a DAX measure in the data model that only allows users to see projectio...
- Q48. You are creating reports in Power BI Desktop. The model has the following tables. (Exhibit...
- Q49. You need to create the dataset. Which dataset mode should you use?...
- Q50. You have a Power Bl report. You have the following tables. (Exhibit) You have the followin...
- Q51. You are creating a Power Bi model and report. You have a single table in a data mode) name...
- Q52. You have a Microsoft Power BI data model that contains three tables named Orders, Date, an...
- Q53. You need to create a relationship in the dataset for RLS. What should you do? To answer, s...
- Q54. You have five sales regions. Each region is assigned a single salesperson. You have an imp...
- Q55. You are building a financial report by using Power BI. You have a table named financials t...
- Q56. You have a column named UnitslnStock as shown in the following exhibit (Exhibit)...
- Q57. You need to create a visual that enables the adhoc exploration of data as shown in the fol...
- Q58. You need to design the data model and the relationships for the Customer Details worksheet...
- Q59. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q60. You have a Microsoft Exert spreadsheet named Excel1 that contains survey results. You have...
- Q61. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q62. How should you distribute the reports to the board? To answer, select the appropriate opti...
- Q63. HOTSPOT You have a report page that contains the visuals shown in the following exhibit. (...
- Q64. You have a Power BI report that contains four pages. All the pages contain a slicer for a ...
- Q65. You have a folder that contains 100 CSV files. You need to make the file metadata availabl...
- Q66. Your company has training videos that are published to Microsoft Stream. You need to surfa...
- Q67. You have a Power Bl report. You have the following tables. (Exhibit) You have the followin...
- Q68. You have a folder of monthly transaction extracts. You plan to create a report to analyze ...
- Q69. You need to create a visualization to meet the reporting requirements of the sales manager...
- Q70. You need to create a visual as shown in the following exhibit. (Exhibit) The indicator col...
- Q71. Your company plans to completely separate development and production assets such as datase...
- Q72. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q73. You have the visual shown in the exhibit. (Click the Exhibit tab.) (Exhibit) You need to s...
- Q74. How should you distribute the reports to the board? To answer, select the appropriate opti...
- Q75. You need to create a measure that will return the percentage of late orders. How should yo...
- Q76. You are creating a quick measure as shown in the following exhibit. (Exhibit) You need to ...
- Q77. You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. ...
- Q78. You need to design the data model and the relationships for the Customer Details worksheet...
- Q79. Note: This question is part of a series of questions that use the same scenario. For your ...
- Q80. You are creating a Microsoft Power Bl imported data model to perform basket analysis. The ...
- Q81. You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The d...
- Q82. You need to create a solution to meet the notification requirements of the warehouse shipp...
- Q83. You create a data model in Power BI. Report developers and users provide feedback that the...
- Q84. You have two Azure SQL databases that contain the same tables and columns. For each databa...
- Q85. You have a dataset named Pens that contains the following columns: * Unit Price * Quantity...
- Q86. Note: This question is a part of a series of questions that present the same scenario. For...
- Q87. How should you distribute the reports to the board? To answer, select the appropriate opti...
- Q88. You use Power Bi Desktop to create a Power Bl data model and a blank report You need to ad...
- Q89. You have the visual shown in the exhibit. (Click the Exhibit tab.) (Exhibit) You need to s...
- Q90. You have the visual shown in the Original exhibit. {Click the Original tab.) (Exhibit) You...
- Q91. You have a power BI tenant that hosts the datasets shown in the following table. (Exhibit)...
- Q92. You have the visual shown in the exhibit. (Click the Exhibit tab.) (Exhibit) You need to s...
- Q93. You have four sales regions. Each region has multiple sales managers. You implement row-le...
- Q94. You have an API that returns more than 100 columns. The following is a sample of column na...
- Q95. You need to create a visualization that compares revenue and cost over time. Which type of...
- Q96. You have an on-premises Power BI Report Server. You plan to create a report in Power BI De...
- Q97. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q98. You need to create a visualization that compares revenue and cost over time. Which type of...
- Q99. You have a Power B1 report. The report contains visualizations that have interactions. You...
- Q100. You view a query named Transactions as shown in the following exhibit. (Exhibit) The query...
- Q101. You receive revenue data that must be included in Microsoft Power Bl reports. You perform ...
- Q102. From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The d...
- Q103. You plan to create a dashboard in the Power BI service that retrieves data from a Microsof...
- Q104. You need to address the data concerns before creating the data model. What should you do i...
- Q105. You receive revenue data that must be included in Microsoft Power Bl reports. You perform ...
- Q106. You have a Power Bl table named Customer that contains a field named Email Address. You di...
- Q107. What should you do to address the existing environment data concerns?...
- Q108. You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single...
- Q109. You have a folder of monthly transaction extracts. You plan to create a report to analyze ...
- Q110. You have a Microsoft Power BI data model that contains three tables named Orders, Date, an...
- Q111. You are profiling data by using Power Query Editor. You have a table named Reports that co...
- Q112. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q113. You have a report that contains four pages. Each page contains slicers for the same four f...
- Q114. You have a Microsoft Excel workbook that contains two tables. From Power BI, you create a ...
- Q115. You have a report that contains three pages. One of the pages contains a KPI visualization...
- Q116. You are reviewing a query that produces 10,000 rows in the Power Query Editor. You need to...
- Q117. You have a Power Bi report for the procurement department. The report contains data from t...
- Q118. You are profiling data by using Power Query Editor. The AddressLine2 column in a table nam...
- Q119. You have the dataset shown in the following exhibit. (Exhibit) You need to ensure that the...
- Q120. You need to create the Top Customers report. Which type of filter should you use, and at w...
- Q121. Note: This question is a part of a series of questions that present the same scenario. For...
- Q122. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q123. You need to create a DAX measure in the data model that only allows users to see projectio...
- Q124. You use Power Bi Desktop to create a Power Bl data model and a blank report You need to ad...
- Q125. What should you create to meet the reporting requirements of the sales department? (Exhibi...
- Q126. You need to create a measure that will return the percentage of late orders. How should yo...
- Q127. You are building a financial report by using Power BI. You have a table named financials t...
- Q128. You are profiling data by using Power Query Editor. The AddressLine2 column in a table nam...
- Q129. You have a Microsoft Exert spreadsheet named Excel1 that contains survey results. You have...
- Q130. You have a Power BI app named App1. The privacy for the App1 workspace is set to Private. ...
- Q131. You use Power 81 Desktop to load data from a Microsoft SQL Server database. While waiting ...
- Q132. You have the visual shown in the Original exhibit. {Click the Original tab.) (Exhibit) You...
- Q133. You open a query in Power Query Editor. You need to identify the percentage of empty value...
- Q134. You have a query named Customer that imports CSV files from a data lake. The query contain...
- Q135. You have a Power Bl workspace that contains several reports. You need to provide a user wi...
- Q136. DRAG DROP You have the line chart shown in the exhibit. (Click the Exhibit tab.) (Exhibit)...
- Q137. Your company has employees in 10 states. The company recently decided to associate each st...
- Q138. You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two ...
- Q139. You need to design the data model and the relationships for the Customer Details worksheet...
- Q140. HOTSPOT You are creating a Microsoft Power BI data model that has the tables shown in the ...
- Q141. You are creating reports in Power BI Desktop. The model has the following tables. (Exhibit...
- Q142. You are building a Power B1 report to analyze customer segments. You need to identify cust...
- Q143. Which DAX expression should you use to get the ending balances in the balance sheet report...
- Q144. You have a Power Bl workspace that contains a single-page report named Sales. You need to ...
- Q145. You have a column named UnitslnStock as shown in the following exhibit (Exhibit)...
- Q146. You need to create a visual as shown in the following exhibit. (Exhibit) The indicator col...
- Q147. You have a dataset named Pens that contains the following columns: Unit Price Quantity Ord...
- Q148. You have the Power BI data model shown in the following exhibit. (Exhibit) Use the drop-do...
- Q149. You have a Power Bi report. The report contains a visual that snows gross sales by date Th...
- Q150. You are enhancing a Power BI model that has DAX calculations. You need to create a measure...
- Q151. You have a power BI tenant that hosts the datasets shown in the following table. (Exhibit)...
- Q152. You are modifying a Power Bi model by using Power Bl Desktop. You have a table named Sales...
- Q153. You have a report that contains four pages. Each page contains slicers for the same four f...
- Q154. You plan to create a Power Bl dataset to analyze attendance at a school. Data will come fr...
- Q155. You have the Azure SQL databases shown in the following table. (Exhibit) You plan to build...
- Q156. You have a sales system that contains the tables shown in the following table. (Exhibit) T...
- Q157. You have the Power BI data model shown in the following exhibit. (Exhibit) Select the appr...
- Q158. You have a report that includes a card visualization. You need to apply the following cond...
- Q159. You are creating a Power BI model that contains a table named Store. Store contains the fo...
- Q160. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q161. You are building a Power Bl report that uses data from an Azure SQL database named erp1. Y...
- Q162. You have a Power Bl query named Sates that imports the columns shown in the following tabl...
- Q163. You are profiling data by using Power Query Editor. The AddressLine2 column in a table nam...
- Q164. You have a Microsoft Power Bl workspace. You need to grant the user capabilities shown in ...
- Q165. You have a Power BI model that has the following tables: Product (Product_id, Product_Name...
- Q166. You are profiling data by using Power Query Editor. You have a table that contains a colum...
- Q167. You need to create a measure that will return the percentage of late orders. How should yo...
- Q168. You are building a dataset from a JSON file that contains an array of documents. You need ...
- Q169. You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboar...
- Q170. You have a Power Bl report named Orders that supports the following analysis: * Total sale...
- Q171. Once the profit and loss dataset is created, which four actions should you perform in sequ...
- Q172. You need to create a relationship in the dataset for RLS. What should you do? To answer se...
- Q173. You are creating a Power Bl report by using Power Bi Desktop. You need to include a visual...
- Q174. You have a table that contains sales data and approximately 1,000 rows. You need to identi...
- Q175. You publish a report to a workspace named Customer Services. The report identifies custome...
- Q176. The table has the following columns. (Exhibit) You need to add a column that will be used ...
- Q177. Topic 1, Litware, Inc. Case Study This is a case study. Case studies are not timed separat...
- Q178. You have a Microsoft Power BI data model that contains three tables named Sales, Product, ...
- Q179. You have the visual shown in the exhibit. (Click the Exhibit tab.) (Exhibit) You need to s...
- Q180. You have an API that returns more than 100 columns. The following is a sample of column na...
- Q181. You are reviewing a query that produces 10,000 rows in the Power Query Editor. You need to...
- Q182. Note: This question is part of a series of questions that use the same scenario. For your ...
- Q183. You need to create a visualization to meet the reporting requirements of the sales manager...
- Q184. You are creating a Microsoft Power BI data model that has the tables shown in the followin...
- Q185. You have a report in Power BI Desktop as shown in the following exhibit. (Exhibit) Use the...
- Q186. You have a Power Bl query named Sates that imports the columns shown in the following tabl...
- Q187. You have the dashboard shown in the following exhibit. (Exhibit) You need to modify the da...
- Q188. You are creating a dashboard by using the Power Bl service. You have an existing report pa...
- Q189. You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Shee...
- Q190. You are preparing a financial report in Power BI. You connect to the data stored in a Micr...
- Q191. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q192. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q193. You have two CSV files named Products and Categories. The Products file contains the follo...
- Q194. You are creating an analytics report that will consume data from the tables shown in the f...
- Q195. You need to create a solution to meet the notification requirements of the warehouse shipp...
- Q196. You need to create a measure that will return the percentage of late orders. How should yo...
- Q197. You are creating a line chart in a Power Bl report as shown in the following exhibit. Use ...
- Q198. You have a report that contains three pages. One of the pages contains a KPI visualization...
- Q199. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q200. You have a Power Bl report named Orders that supports the following analysis: * Total sale...
- Q201. You have a Power Bl report named Orders that supports the following analysis: * Total sale...
- Q202. You view a query named Transactions as shown in the following exhibit. (Exhibit) The query...
- Q203. You are creating a Microsoft Power BI data model that has the tables shown in the followin...
- Q204. You are creating an analytics report that will consume data from the tables shown in the f...
- Q205. You have a Power Bl table named Customer that contains a field named Email Address. You di...
- Q206. You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.) ...
- Q207. You publish the dataset to powerbi.com. For each of the following statements, select Yes i...
- Q208. You import a Power Bl dataset that contains the following tables: * Date * Product * Produ...
- Q209. You have the Power BI data model shown in the following exhibit. (Exhibit) Select the appr...
- Q210. In Power BI Desktop, you are building a sales report that contains two tables. Both tables...
- Q211. Note: This question is part of a series of questions that use the same scenario. For your ...
- Q212. You have a Power BI dashboard that monitors the quality of manufacturing processes. The da...
- Q213. You are modeling data in table named SalesDetail by using Microsoft Power Bl. You need to ...
- Q214. You have a dataset named Pens that contains the following columns: Unit Price Quantity Ord...
- Q215. You are creating a report in Power BI Desktop. You load a data extract that includes a fre...
- Q216. You have four sales regions. Each region has multiple sales managers. You implement row-le...
- Q217. You plan to create a dashboard in the Power BI service that retrieves data from a Microsof...
- Q218. You have a folder that contains 100 CSV files. You need to make the file metadata availabl...
- Q219. You have a Microsoft Excel workbook that contains two tables. From Power BI, you create a ...
- Q220. support the reports?
- Q221. You have the Power BI data model shown in the following exhibit. (Exhibit) Select the appr...
- Q222. You have the line chart shown in the exhibit. (Click the Exhibit tab.) (Exhibit) You need ...
- Q223. You are creating a line chart in a Power Bl report as shown in the following exhibit. Use ...
- Q224. You have a report page that contains the visuals shown in the following exhibit. (Exhibit)...
- Q225. You have a collection of reports for the HR department of your company. The datasets use r...
- Q226. You receive revenue data that must be included in Microsoft Power Bl reports. You perform ...
- Q227. You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is acces...
- Q228. HOTSPOT You have a power BI tenant that hosts the datasets shown in the following table. (...
- Q229. You are using Power Bi Desktop to connect to an Azure SQL database The connection is confi...
- Q230. You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is acces...
- Q231. You are creating a Microsoft Power Bl imported data model to perform basket analysis. The ...
- Q232. You are creating a line chart in a Power Bl report as shown in the following exhibit. Use ...
- Q233. You have the Power Bl model shown in the following exhibit. (Exhibit) There are four depar...
- Q234. You need to create the dataset. Which dataset mode should you use?...
- Q235. You have a Power BI report. You need to create a calculated table to return the 100 highes...
- Q236. You have a Power BI imported dataset that contains the data model shown in the following e...
- Q237. You maintain a Power Bl workspace that contains a supplier quality dashboard. The dashboar...
- Q238. You have a Power BI report. You need to create a calculated table to return the 100 highes...
- Q239. You need to create the dataset. Which dataset mode should you use?...
- Q240. In Power Bi Desktop, you are creating visualizations in a report based on an imported data...
