[Dec 02, 2023] Microsoft PL-300 Exam Dumps Files, Q1/259: You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains

Join the discussion

Question 1/259

You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. CityData contains only the data shown in the following table.

Sales contains only the data shown in the following table.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Add Comments

Other Question (259q): Q1. You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. ...; Q2. You need to create a solution to meet the notification requirements of the warehouse shipp...; Q3. You have a Power BI report. You need to create a calculated table to return the 100 highes...; Q4. You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an ...; Q5. Note: This question is part of a series of questions that present the same scenario. Each ...; Q6. You have a Power Bl report that contains five pages. Pages 1 to 4 are visible and page 5 i...; Q7. You need to create a visual as shown in the following exhibit. (Exhibit) The indicator col...; Q8. You create a report by using Microsoft Power BI Desktop. The report uses data from a Micro...; Q9. You are configuring a Microsoft Power Bl data model to enable users to ask natural languag...; Q10. You manage a Power BI model has a table named Sales and product. You need to ensure that a...; Q11. You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The d...; Q12. You have a Microsoft Power Bl workspace. You need to grant the user capabilities shown in ...; Q13. You are building a financial report by using Power BI. You have a table named financials t...; Q14. You have a prospective customer list that contains 1,500 rows of data. The list contains t...; Q15. You have a Q&A visual that displays information from a table named Carriers as shown i...; Q16. You have a Power Bl report for the marketing department. The report reports on web traffic...; Q17. You have a report that contains a donut chart and a clustered column chart. Interactions b...; Q18. You need to design the data model and the relationships for the Customer Details worksheet...; Q19. Your company has training videos that are published to Microsoft Stream. You need to surfa...; Q20. Topic 1, Litware, Inc. Case Study This is a case study. Case studies are not timed separat...; Q21. You are creating a column chart visualization. You configure groups as shown in the Groups...; Q22. You have a query that returns the data shown in the following exhibit. (Exhibit) You need ...; Q23. You have a Power Bl visual that uses indicators to show values that are out of range as sh...; Q24. You have a dataset that has the permissions shown in the following exhibit. (Exhibit)...; Q25. Your company plans to use Power BI for 20 users in the sales department. The users will pe...; Q26. You have the Power BI data model shown in the following exhibit. (Exhibit) Select the appr...; Q27. You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. ...; Q28. You are building a dataset from a JSON file that contains an array of documents. You need ...; Q29. HOTSPOT Your company has affiliates who help the company acquire customers. You build a re...; Q30. You have a power BI tenant that hosts the datasets shown in the following table. (Exhibit)...; Q31. You are profiling data by using Power Query Editor. You have a table named Reports that co...; Q32. Note: This question is part of a series of questions that present the same scenario. Each ...; Q33. You have a report that contains four pages. Each page contains slicers for the same four f...; Q34. What should you create to meet the reporting requirements of the sales department?...; Q35. You have five sales regions. Each region is assigned a single salesperson. You have an imp...; Q36. You plan to create the Power Bl model shown in the exhibit. (Click the Exhibit tab.) The d...; Q37. You have a Power BI report that contains four pages. All the pages contain a slicer for a ...; Q38. Exhibit: (Exhibit) You need to create a report that meets the requirements: * Visualizes t...; Q39. You create a data model in Power BI. Report developers and users provide feedback that the...; Q40. You have a dataset that contains revenue data from the past year. You need to use anomaly ...; Q41. You need to design the data model and the relationships for the Customer Details worksheet...; Q42. You have a report that contains four pages. Each page contains slicers for the same four f...; Q43. You build a report about warehouse inventory data. The dataset has more than 10 million pr...; Q44. You have two CSV files named Products and Categories. The Products file contains the follo...; Q45. Note: This question is part of a series of questions that present the same scenario. Each ...; Q46. You view a query named Transactions as shown in the following exhibit. (Exhibit) The query...; Q47. You are creating a column chart visualization. You configure groups as shown in the Groups...; Q48. You have a Power BI model that has the following tables: Product (Product_id, Product_Name...; Q49. You need to create a measure that will return the percentage of late orders. How should yo...; Q50. You have the Power BI data model shown in the following exhibit. (Exhibit) Select the appr...; Q51. You publish a report to a workspace named Customer Services. The report identifies custome...; Q52. You have a Power BI report. The report contains visualizations that have interactions. You...; Q53. A business intelligence (Bl) developer creates a dataflow in Power Bl that uses DirectQuer...; Q54. You have the Power BI data model shown in the following exhibit. (Exhibit)...; Q55. You need to create a DAX measure in the data model that only allows users to see projectio...; Q56. You are enhancing a Power BI model that has DAX calculations. You need to create a measure...; Q57. You have a Microsoft Excel workbook that contains two tables. From Power BI, you create a ...; Q58. You are creating a Microsoft Power Bl imported data model to perform basket analysis. The ...; Q59. Note: This question is part of a series of questions that present the same scenario. Each ...; Q60. You need to create a relationship in the dataset for RLS. What should you do? To answer, s...; Q61. You are modeling data in table named SalesDetail by using Microsoft Power Bl. You need to ...; Q62. You plan to embed multiple visualization in a public website. Your Power BI infrastructure...; Q63. You have four sales regions. Each region has multiple sales managers. You implement row-le...; Q64. You need to create the dataset. Which dataset mode should you use?...; Q65. You have a Power Bl report. You have the following tables. (Exhibit) You have the followin...; Q66. You are creating reports in Power BI Desktop. The model has the following tables. (Exhibit...; Q67. You need to create a solution to meet the notification requirements of the warehouse shipp...; Q68. You have a query named Customer that imports CSV files from a data lake. The query contain...; Q69. Your company has affiliates who help the company acquire customers. You build a report for...; Q70. You have a column named UnitslnStock as shown in the following exhibit (Exhibit) UnitsInSt...; Q71. You need to create a measure that will return the percentage of late orders. How should yo...; Q72. You have a CSV file that contains user complaints. The file contains a column named Logged...; Q73. Note: This question is part of a series of questions that present the same scenario. Each ...; Q74. Note: This question is a part of a series of questions that present the same scenario. For...; Q75. You have two CSV files named Products and Categories. The Products file contains the follo...; Q76. You have a CSV file that contains user complaints. The file contains a column named Logged...; Q77. You need to create the dataset. Which dataset mode should you use?...; Q78. Note: This question is a part of a series of questions that present the same scenario. For...; Q79. You receive revenue data that must be included in Microsoft Power Bl reports. You perform ...; Q80. DRAG DROP You are modeling data in table named SalesDetail by using Microsoft Power Bl. Yo...; Q81. Note: This question is part of a series of questions that present the same scenario. Each ...; Q82. Your company has affiliates who help the company acquire customers. You build a report for...; Q83. You are using existing reports to build a dashboard that will be viewed frequently in port...; Q84. You have a report that contains three pages. One of the pages contains a KPI visualization...; Q85. You use an R visual to produce a map of 500,000 customers. You include the values of Custo...; Q86. You are profiling data by using Power Query Editor. You have a table named Reports that co...; Q87. You create the following step by using Power Query Editor. = Table.ReplaceValue(SalesLT_Ad...; Q88. You have a Power BI report. You need to create a calculated table to return the 100 highes...; Q89. You have a Power Bl visual that uses indicators to show values that are out of range as sh...; Q90. You are creating a quick measure as shown in the following exhibit. (Exhibit) You need to ...; Q91. You have two Power Bl reports named ReportA and ReportB that each uses a distinct color pa...; Q92. Your company plans to use Power BI for 20 users in the sales department. The users will pe...; Q93. You open powerbi.com as shown in the following exhibit. Use the drop-down menus to select ...; Q94. You are creating an analytics report that will consume data from the tables shown in the f...; Q95. You have a Power Bl workspace that contains several reports. You need to provide a user wi...; Q96. Once the profit and loss dataset is created, which four actions should you perform in sequ...; Q97. You have a Power Bi report that contains five bookmarks. You need to add an object to the ...; Q98. Note: This question is part of a series of questions that use the same scenario. For your ...; Q99. Your company plans to completely separate development and production assets such as datase...; Q100. Note: This question is part of a series of questions that present the same scenario. Each ...; Q101. In Power Bi Desktop, you are creating visualizations in a report based on an imported data...; Q102. Note: This question is a part of a series of questions that present the same scenario. For...; Q103. You have a Power Bl table named Customer that contains a field named Email Address. You di...; Q104. You are building a financial report by using Power BI. You have a table named financials t...; Q105. You need to create a visual as shown in the following exhibit. (Exhibit) The indicator col...; Q106. You have a Power BI tenant. You have reports that use financial datasets and are exported ...; Q107. You need to create relationships to meet the reporting requirements of the customer servic...; Q108. HOTSPOT You have the Power BI data model shown in the following exhibit. (Exhibit) Use the...; Q109. Note: This question is a part of a series of questions that present the same scenario. For...; Q110. You have two Power Bl workspaces named WorkspaceA and Workspaces. WorkspaceA contains two ...; Q111. You have a Power Bi report that contains five bookmarks. You need to add an object to the ...; Q112. You are creating an analytics report that will consume data from the tables shown in the f...; Q113. Note: This question is part of a series of questions that present the same scenario. Each ...; Q114. You have a folder of monthly transaction extracts. You plan to create a report to analyze ...; Q115. You open powerbi.com as shown in the following exhibit. (Exhibit) Use the drop-down menus ...; Q116. You open powerbi.com as shown in the following exhibit. (Exhibit) Use the drop-down menus ...; Q117. HOTSPOT You are creating an analytics report that will consume data from the tables shown ...; Q118. You need to calculate the last day of the month in the balance sheet data to ensure that y...; Q119. Note: This question is part of a series of questions that present the same scenario. Each ...; Q120. You are creating a line chart in a Power Bl report as shown in the following exhibit. Use ...; Q121. You need to create a DAX measure in the data model that only allows users to see projectio...; Q122. Note: This question is part of a series of questions that present the same scenario. Each ...; Q123. You need to create the On-Time Shipping report. The report must include a visualization th...; Q124. The Sales table contains records of sales by day from the last five years up until today's...; Q125. You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a rep...; Q126. Your company has affiliates who help the company acquire customers. You build a report for...; Q127. You have a Power Bl workspace that contains a single-page report named Sales. You need to ...; Q128. You have sales data in a star schema that contains four tables named Sales, Customer, Date...; Q129. Your company has affiliates who help the company acquire customers. You build a report for...; Q130. You need to create the dataset. Which dataset mode should you use?...; Q131. Your company has training videos that are published to Microsoft Stream. You need to surfa...; Q132. Note: This question is a part of a series of questions that present the same scenario. For...; Q133. You are building a financial report by using Power BI. You have a table named financials t...; Q134. You are modeling data in table named SalesDetail by using Microsoft Power Bl. You need to ...; Q135. You have a report that contains a bar chart and a column chart. The bar chart shows custom...; Q136. You need to create a visualization that compares revenue and cost over time. Which type of...; Q137. You have the dataset shown in the following exhibit. (Exhibit) You need to ensure that the...; Q138. The table has the following columns. (Exhibit) You need to add a column that will be used ...; Q139. You have a Power BI model that contains a table named Sales. Sales has the following three...; Q140. You have a Power BI model that has the following tables: Product (Product_id, Product_Name...; Q141. You need to create a measure that will return the percentage of late orders. How should yo...; Q142. You need to create the Top Customers report. Which type of filter should you use, and at w...; Q143. You have a query that returns the data shown in the following exhibit. (Exhibit) You need ...; Q144. You are building a financial report by using Power BI. You have a table named financials t...; Q145. You have a Microsoft Power BI report. The size of PBIX file is 550 MB. The report is acces...; Q146. You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. ...; Q147. A manager can represent only a single country. You need to use row-level security (RLS) to...; Q148. You have a query named Customer that imports CSV files from a data lake. The query contain...; Q149. You have the visual shown in the exhibit. (Click the Exhibit tab.) (Exhibit) You need to s...; Q150. You have a Power BI report. You need to create a calculated table to return the 100 highes...; Q151. Your company has affiliates who help the company acquire customers. You build a report for...; Q152. Note: This question is part of a series of questions that present the same scenario. Each ...; Q153. You are enhancing a Power BI model that has DAX calculations. You need to create a measure...; Q154. Your company plans to use Power BI for 20 users in the sales department. The users will pe...; Q155. You have a large dataset that contains more than 1 million rows. The table has a datetime ...; Q156. You have more than 100 published datasets. Ten of the datasets were verified to meet your ...; Q157. Note: This question is part of a series of questions that present the same scenario. Each ...; Q158. You are creating a Power Bi model in Power BI Desktop You need to create a calculated tabl...; Q159. You have a report in Power BI Desktop as shown in the following exhibit. (Exhibit) Use the...; Q160. You have a Power BI model that contains a table named Sales and a related date table. Sale...; Q161. You need to provide a solution to provide the sales managers with the required access. Wha...; Q162. Remove unused columns from tables in the data model. This will reduce the size of your PBI...; Q163. You need to grant access to the business unit analysts. What should you configure? To answ...; Q164. You have a folder that contains 100 CSV files. You need to make the file metadata availabl...; Q165. You need to create a relationship in the dataset for RLS. What should you do? To answer, s...; Q166. You have a Microsoft Excel workbook that contains two sheets named Sheet1 and Sheet2. Shee...; Q167. You open powerbi.com as shown in the following exhibit. (Exhibit) Use the drop-down menus ...; Q168. You have a Power Bi report for the procurement department. The report contains data from t...; Q169. You have the Azure SQL databases shown in the following table. (Exhibit) You plan to build...; Q170. (Exhibit) Each employee has one manager as shown in the ParentEmployeelD column, All repor...; Q171. You have a Power Bl table named Customer that contains a field named Email Address. You di...; Q172. You have a folder of monthly transaction extracts. You plan to create a report to analyze ...; Q173. You have a Power 31 data model that contains a table named Stores. The table has the follo...; Q174. You have a Power Bl report hosted on powerbi.com that displays expenses by department for ...; Q175. You have a table that contains the following three columns: City Total Sales Occupation Yo...; Q176. You have a Power B1 model that contains a table named Date. The table has the following co...; Q177. You have a folder that contains 100 CSV files. You need to make the file metadata availabl...; Q178. You have a report that contains a bar chart and a column chart. The bar chart shows custom...; Q179. You have a CSV file that contains user complaints. The file contains a column named Logged...; Q180. What is the minimum number of datasets and storage modes required to support the reports?...; Q181. You have a collection of reports for the HR department of your company. You need to create...; Q182. You have the line chart shown in the exhibit. (Click the Exhibit tab.) (Exhibit) You need ...; Q183. Note: This question is part of a series of questions that present the same scenario. Each ...; Q184. You plan to create a dashboard in the Power BI service that retrieves data from a Microsof...; Q185. Note: This question is part of a series of questions that present the same scenario. Each ...; Q186. You have a Power Bl report You have a table named Dalai that contains 10 million rows. Dat...; Q187. Note: This question is part of a series of questions that present the same scenario. Each ...; Q188. You need to create the Top Customers report. Which type of filter should you use, and at w...; Q189. You have the tables shown in the following table. (Exhibit) The Impressions table contains...; Q190. You are preparing a financial report in Power BI. You connect to the data stored in a Micr...; Q191. You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. ...; Q192. You are creating an analytics report that will consume data from the tables shown in the f...; Q193. You create a data model in Power BI. Report developers and users provide feedback that the...; Q194. You have a Microsoft Excel workbook that contains two tables. From Power BI, you create a ...; Q195. Once the profit and loss dataset is created, which four actions should you perform in sequ...; Q196. Note: This question is part of a series of questions that present the same scenario. Each ...; Q197. You plan to create a report that will display sales data from the last year for multiple r...; Q198. You have the data lineage shown in the following exhibit. (Exhibit) Use the drop-down menu...; Q199. You are profiling data by using Power Query Editor. The AddressLine2 column in a table nam...; Q200. You have a table that contains a column named Phone. The following is a sample of the data...; Q201. You have a Power Bl report for the marketing department. The report reports on web traffic...; Q202. You are creating a quick measure as shown in the following exhibit. (Exhibit) You need to ...; Q203. You have a table that contains a column named Phone. The following is a sample of the data...; Q204. You plan to develop a Power BI report that has a bar chart to display the number of custom...; Q205. You have the Power BI data model shown in the following exhibit. (Exhibit)...; Q206. Your organization has a team of power users who recently created 20 Power BI dashboards. T...; Q207. Which two types of visualizations can be used in the balance sheet reports to meet the rep...; Q208. You are using existing reports to build a dashboard that will be viewed frequently in port...; Q209. Once the profit and loss dataset is created, which four actions should you perform in sequ...; Q210. You are creating a sales report in Power Bl for the NorthWest region sales territory of yo...; Q211. You need to create a Power Bl report. The first page or the report must contain the follow...; Q212. You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single...; Q213. From Power 61 Desktop, you publish a new dataset and report lo a Power Bl workspace. The d...; Q214. You have the following table named Location. (Exhibit) The GeoCode column represents the c...; Q215. You have a Power Bl table named Customer that contains a field named Email Address. You di...; Q216. You view a query named Transactions as shown in the following exhibit. (Exhibit) The query...; Q217. You have sales data in a star schema that contains four tables named Sales, Customer, Date...; Q218. Exhibit: (Exhibit) You need to create a report that meets the requirements: * Visualizes t...; Q219. You are creating a quick measure as shown in the following exhibit. (Exhibit) You need to ...; Q220. The table has the following columns. (Exhibit) You need to add a column that will be used ...; Q221. You need to create a visual that enables the adhoc exploration of data as shown in the fol...; Q222. You have a Power Bl workspace named Workspace1 that contains a dataset named DS1 and a rep...; Q223. You have a Power Bl visual that uses indicators to show values that are out of range as sh...; Q224. Note: This question is part of a series of questions that present the same scenario. Each ...; Q225. You have the data lineage shown in the following exhibit. (Exhibit) Use the drop-down menu...; Q226. You have a power BI tenant that hosts the datasets shown in the following table. (Exhibit)...; Q227. You have two tables named Customers and Invoice in a Power BI model. The Customers table c...; Q228. You plan to develop a Power BI report that has a bar chart to display the number of custom...; Q229. You have the following table named Location. (Exhibit) The GeoCode column represents the c...; Q230. You are creating a Microsoft Power Bl model that has two tables named CityData and Sales. ...; Q231. You have a Power Bl visual that uses indicators to show values that are out of range as sh...; Q232. You have a prospective customer list that contains 1,500 rows of data. The list contains t...; Q233. You are building a financial report by using Power BI. You have a table named financials t...; Q234. You are preparing a financial report in Power BI. You connect to the data stored in a Micr...; Q235. The table has the following columns. (Exhibit) You need to add a column that will be used ...; Q236. DRAG DROP Once the profit and loss dataset is created, which four actions should you perfo...; Q237. You have a column named UnitslnStock as shown in the following exhibit (Exhibit)...; Q238. You have a data model that contains many complex DAX expressions. The expressions contain ...; Q239. You have the data lineage shown in the following exhibit. (Exhibit) Use the drop-down menu...; Q240. You have the dataset shown in the following exhibit. (Exhibit) You need to ensure that the...; Q241. You are building a data model for a Power Bl report. You have data formatted as shown in t...; Q242. You have a Power BI report. You need to create a calculated table to return the 100 highes...; Q243. You have a Microsoft Power BI data model that contains three tables named Orders, Date, an...; Q244. You need to create the Top Customers report. Which type of filter should you use, and at w...; Q245. You need to grant access to the business unit analysts. What should you configure? To answ...; Q246. Your company plans to completely separate development and production assets such as datase...; Q247. You have a Microsoft Power BI data model that contains three tables named Sales, Product, ...; Q248. You have a Power Bl report that contains a measure named Total Sales. You need to create a...; Q249. You have the Power BI data model shown in the following exhibit. (Exhibit) Use the drop-do...; Q250. You need to create the required relationship for the executive's visual. What should you d...; Q251. Note: This question is part of a series of questions that present the same scenario. Each ...; Q252. You have a data model that contains many complex DAX expressions. The expressions contain ...; Q253. You have the Power Bi dashboard shown in the Dashboard exhibit (Click the Dashboard tab.) ...; Q254. The Sales table contains records of sales by day from the last five years up until today's...; Q255. You have a report in Power BI Desktop as shown in the following exhibit. (Exhibit) Use the...; Q256. You are modifying a Power Bi model by using Power Bl Desktop. You have a table named Sales...; Q257. You have a Power B1 model that contains a table named Date. The table has the following co...; Q258. DRAG DROP You are using existing reports to build a dashboard that will be viewed frequent...; Q259. You are enhancing a Power BI model that has DAX calculations. You need to create a measure...

Join the discussion

Question 1/259

Add Comments

Download PDF File