Join the discussion
Question 1/156
You have a dataset that is populated from a list of business categories in a source database. The list of categories changes over time.
You use Power Bl Report Builder to create a paginated report. The report has a report parameter named BusinessCategory.
You need to modify BusinessCategory to ensure that when the report opens, a drop-down list displays all the business categories, and all the business categories are selected.
How should you configure BusinessCategory? To answer, drag the appropriate options to the correct settings.
Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

You use Power Bl Report Builder to create a paginated report. The report has a report parameter named BusinessCategory.
You need to modify BusinessCategory to ensure that when the report opens, a drop-down list displays all the business categories, and all the business categories are selected.
How should you configure BusinessCategory? To answer, drag the appropriate options to the correct settings.
Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation

Add Comments
- Other Question (156q)
- Q1. You have a dataset that is populated from a list of business categories in a source databa...
- Q2. You have an Azure Synapse Analytics dataset that contains data about jet engine performanc...
- Q3. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q4. You are configuring a Power Bl report for accessibility as shown in the following table. (...
- Q5. You are creating an external table by using an Apache Spark pool in Azure Synapse Analytic...
- Q6. You need to build a Transact-SQL query to implement the planned changes for the internal u...
- Q7. You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You ne...
- Q8. You need to implement object-level security (OLS) in the Power Bl dataset for the sales as...
- Q9. You have a Power Bl dataset that contains the following measure. (Exhibit) You need to imp...
- Q10. You have an Azure Synapse notebook. You need to create the visual shown in the following e...
- Q11. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q12. You are configuring a Power Bl report for accessibility as shown in the following table. (...
- Q13. You have a Power Bl dataset. The dataset contains data that is updated frequently. You nee...
- Q14. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q15. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q16. You are using DAX Studio to analyze a slow-running report query. You need to identify inef...
- Q17. You have a deployment pipeline for a Power BI workspace. The workspace contains two datase...
- Q18. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q19. You need to integrate the external data source to support the planned changes. Which three...
- Q20. You have a file named File1.txt that has the following characteristics: * A header row * T...
- Q21. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q22. You have a shared dataset in Power Bl named Dataset1. You have an on-premises Microsoft SQ...
- Q23. You are optimizing a dataflow in a Power Bl Premium capacity. The dataflow performs multip...
- Q24. You have the following Python code in an Apache Spark notebook. (Exhibit) Which type of ch...
- Q25. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q26. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q27. You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibi...
- Q28. You need to configure a source control solution for Azure Synapse Analytics. The solution ...
- Q29. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q30. You have a sales report as shown in the following exhibit. (Exhibit) The sales report has ...
- Q31. What should you configure in the deployment pipeline?...
- Q32. You have a sales report as shown in the following exhibit. (Exhibit) The sales report has ...
- Q33. You have a Power Bl workspace that contains one dataset and four reports that connect to t...
- Q34. You need to create Power BI reports that will display data based on the customers' subscri...
- Q35. You need to build a Transact-SQL query to implement the planned changes for the internal u...
- Q36. You have a team of business analysts that uses Power Bl for departmental analytics. The te...
- Q37. You develop a solution that uses a Power Bl Premium capacity. The capacity contains a data...
- Q38. You need to populate the CustomersWithProductScore table. How should you complete the stor...
- Q39. You have the following Power Bl query. (Exhibit) For each of the following statements, sel...
- Q40. You need to create Power Bl reports that will display data based on the customers' subscri...
- Q41. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q42. You have an Azure Synapse workspace named Workspace1. You need to use PySpark in a noteboo...
- Q43. You have a Power Bi workspace named Workspacel in a Premium capacity. Workspacel contains ...
- Q44. You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL data...
- Q45. You need to recommend a solution for the analysts in the Finance and Accounting business u...
- Q46. You manage a dataset that contains the two data sources as shown in the following table. (...
- Q47. You have an Azure Synapse Analytics serverless SQL pool. You need to catalog the serverles...
- Q48. You have a Power Bl tenant that contains 10 workspaces. You need to create dataflows in th...
- Q49. You have the Power BI workspaces shown in the following exhibit. (Exhibit) Use the drop-do...
- Q50. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q51. You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs...
- Q52. Note: This question is part of a scries of questions that present the same scenario. Each ...
- Q53. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q54. You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses...
- Q55. You are running a diagnostic against a query as shown in the following exhibit. (Exhibit) ...
- Q56. You have a group of data scientists who must create machine learning models and run period...
- Q57. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q58. You need to configure a source control solution for Azure Synapse Analytics. The solution ...
- Q59. You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses...
- Q60. You have a file named File1.txt that has the following characteristics: * A header row * T...
- Q61. You need to save Power Bl dataflows in an Azure Storage account. Which two prerequisites a...
- Q62. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q63. You have a Power Bl dataset that contains the following measures: * Budget * Actuals * For...
- Q64. The enterprise analytics team needs to resolve the DAX measure performance issues. What sh...
- Q65. You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibi...
- Q66. You need to provide users with a reproducible method to connect to a data source and trans...
- Q67. You need to recommend an automated solution to monitor Power Bl user activity. The solutio...
- Q68. You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails c...
- Q69. You use Advanced Editor in Power Query Editor to edit a query that references two tables n...
- Q70. You need to populate the CustomersWithProductScore table. How should you complete the stor...
- Q71. You are building a Power Bl dataset that will use two data sources. The dataset has a quer...
- Q72. You need to identify the root cause of the data refresh issue. What should you use?...
- Q73. You manage a dataset that contains the two data sources as shown in the following table. (...
- Q74. You have a Power Bl dataset that contains the following measures: * Budget * Actuals * For...
- Q75. You have a Power Bl dataset that contains the following measure. (Exhibit) You need to imp...
- Q76. You are using Azure Synapse Studio to explore a dataset that contains data about taxi trip...
- Q77. You are building a Power Bl dataset that contains a table named Calendar. Calendar contain...
- Q78. You need to recommend a solution to add new fields to the financial data Power Bl dataset ...
- Q79. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q80. You have an Azure Synapse Analytics dedicated SQL pool that contains a table named dbo. Di...
- Q81. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q82. You plan to create a Power Bl report that will use an OData feed as the data source. You w...
- Q83. You have an Azure Synapse Analytics dedicated SQL pool. You need to ensure that the SQL po...
- Q84. You have a Power Bl report that contains the table shown in the following exhibit. (Exhibi...
- Q85. You have a Power Bl dataset that contains the following measures: * Budget * Actuals * For...
- Q86. You have a Power Bl data model. You need to refresh the data from the source every 15 minu...
- Q87. You plan to create a Power Bl report that will use an OData feed as the data source. You w...
- Q88. You have a Power Bl data model. You need to refresh the data from the source every 15 minu...
- Q89. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q90. You have a Power Bl tenant You invite an external consultant to work in the tenant. You ne...
- Q91. You are running a diagnostic against a query as shown in the following exhibit. (Exhibit) ...
- Q92. You are configuring Azure Synapse Analytics pools to support the Azure Active Directory gr...
- Q93. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q94. Which two possible tools can you use to identify what causes the report to render slowly? ...
- Q95. You plan to modify a Power Bl dataset. You open the Impact analysis panel for the dataset ...
- Q96. You open a Power Bl Desktop report that contains an imported data model and a single repor...
- Q97. How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?...
- Q98. You are creating a Python visual in Power Bl Desktop. You need to retrieve the value of a ...
- Q99. You plan to create a Power Bl report that will use an OData feed as the data source. You w...
- Q100. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q101. You need to implement object-level security (OLS) in the Power Bl dataset for the sales as...
- Q102. You have a Power Bl dataset. The dataset contains data that is updated frequently. You nee...
- Q103. You have the following Python code in an Apache Spark notebook. (Exhibit) Which type of ch...
- Q104. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q105. You have a Power Bl data model. You need to refresh the data from the source every 15 minu...
- Q106. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q107. You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses...
- Q108. You have a Power Bl report that contains one visual. You need to provide users with the ab...
- Q109. You need to integrate the external data source to support the planned changes. Which three...
- Q110. You have the following Python code in an Apache Spark notebook. (Exhibit) Which type of ch...
- Q111. You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You ne...
- Q112. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q113. You have an Azure Synapse notebook. You need to create the visual shown in the following e...
- Q114. You have a Power Bl dataset. The dataset contains data that is updated frequently. You nee...
- Q115. You develop a solution that uses a Power Bl Premium capacity. The capacity contains a data...
- Q116. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q117. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q118. Note: This question is part of a scries of questions that present the same scenario. Each ...
- Q119. You need to create Power BI reports that will display data based on the customers' subscri...
- Q120. You need to recommend an automated solution to monitor Power Bl user activity. The solutio...
- Q121. You have an Azure Synapse notebook. You need to create the visual shown in the following e...
- Q122. You are planning a Power Bl solution for a customer. The customer will have 200 Power Bl u...
- Q123. You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files re...
- Q124. You need to create the customized Power Bl usage reporting. The Usage Metrics Report datas...
- Q125. You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs...
- Q126. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q127. You need to implement object-level security (OLS) in the Power Bl dataset for the sales as...
- Q128. You deploy a tabular model to the Power Bl service. The model is developed and maintained ...
- Q129. You have a group of data scientists who must create machine learning models and run period...
- Q130. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q131. You have a Power Bl dataset. The dataset contains data that is updated frequently. You nee...
- Q132. You have a Power Bl report that contains the visual shown in the following exhibit. (Exhib...
- Q133. You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen...
- Q134. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q135. You have a group of data scientists who must create machine learning models and run period...
- Q136. You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of file...
- Q137. You need to recommend an automated solution to monitor Power Bl user activity. The solutio...
- Q138. You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset ...
- Q139. You have a Power Bl report that contains the table shown in the following exhibit. (Exhibi...
- Q140. You need to populate the CustomersWithProductScore table. How should you complete the stor...
- Q141. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q142. You have a shared dataset in Power Bl named Dataset1. You have an on-premises Microsoft SQ...
- Q143. You use Vertipaq Analyzer to analyze a model. The Relationships tab contains the results s...
- Q144. You need to recommend a solution to ensure that sensitivity labels are applied. The soluti...
- Q145. You have a Power Bl data model. You need to refresh the data from the source every 15 minu...
- Q146. You use Vertipaq Analyzer to analyze a model. The Relationships tab contains the results s...
- Q147. You need to recommend a solution for the customer workspaces to support the planned change...
- Q148. You have the Power BI workspaces shown in the following exhibit. (Exhibit) Use the drop-do...
- Q149. You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails c...
- Q150. You have a Power BI Premium capacity. You need to increase the number of virtual cores ass...
- Q151. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q152. You have a Power Bl tenant and an Azure subscription named Sub1. The Power Bl tenant and S...
- Q153. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q154. You have a Power Bl dataset that contains the following measure. (Exhibit) You need to imp...
- Q155. What should you configure in the deployment pipeline?...
- Q156. You are building a Power Bl dataset that contains a table named Calendar. Calendar contain...
