Join the discussion
Question 1/104
You manage a dataset that contains the two data sources as shown in the following table.

When you attempt to refresh the dataset in powerbi.com, you receive the following error message: "[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination." You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.
You need to resolve the error. The solution must provide the highest privacy possible.
Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.


When you attempt to refresh the dataset in powerbi.com, you receive the following error message: "[Unable to combine data] Add Columns is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination." You discover that the dataset contains queries that fold data from the SharePoint folder to the Azure SQL database.
You need to resolve the error. The solution must provide the highest privacy possible.
Which privacy level should you select for each data source? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Add Comments
- Other Question (104q)
- Q1. You manage a dataset that contains the two data sources as shown in the following table. (...
- Q2. You have a Power Bl report that contains one visual. You need to provide users with the ab...
- Q3. You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset ...
- Q4. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q5. You are planning a Power Bl solution for a customer. The customer will have 200 Power Bl u...
- Q6. You have a Power Bl report hosted on the Power Bl service. The report displays expenses by...
- Q7. You have five Power Bl reports that contain R script data sources and R visuals. You need ...
- Q8. You have an app named App1 that processes loan applications. App1 is connected to an Azure...
- Q9. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q10. You need to identify the root cause of the data refresh issue. What should you use?...
- Q11. You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You ne...
- Q12. You have the Power BI workspaces shown in the following exhibit. (Exhibit) Use the drop-do...
- Q13. You need to configure the Sales Analytics workspace to meet the ad hoc reporting requireme...
- Q14. You have an Azure Synapse Analytics notebook. You run the xxsq1 magic command to render da...
- Q15. You have a Power Bl workspace that contains one dataset and four reports that connect to t...
- Q16. How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?...
- Q17. The enterprise analytics team needs to create a view for the survey response dat a. The so...
- Q18. You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of file...
- Q19. You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data. ...
- Q20. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q21. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q22. What should you configure in the deployment pipeline?...
- Q23. You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs...
- Q24. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q25. You have a Power Bl dataset. The dataset contains data that is updated frequently. You nee...
- Q26. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q27. You have a shared dataset in Power Bl named Dataset1. You have an on-premises Microsoft SQ...
- Q28. You have an Azure Synapse Analytics serverless SQL pool. You need to catalog the serverles...
- Q29. You need to create Power BI reports that will display data based on the customers' subscri...
- Q30. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q31. You need to configure a source control solution for Azure Synapse Analytics. The solution ...
- Q32. You have a 2-GB Power Bl dataset. You need to ensure that you can redeploy the dataset by ...
- Q33. Note: This question is part of a scries of questions that present the same scenario. Each ...
- Q34. You have a Power BI Premium capacity. You need to increase the number of virtual cores ass...
- Q35. You need to recommend a solution for the customer workspaces to support the planned change...
- Q36. You plan to generate a line chart to visualize and compare the last six months of sales da...
- Q37. You have a dataset that contains a table named UserPermissions. UserPermissions contains t...
- Q38. You are optimizing a Power Bl data model by using DAX Studio. You need to capture the quer...
- Q39. You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of file...
- Q40. You have an Azure Synapse workspace named Workspace1. You need to use PySpark in a noteboo...
- Q41. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q42. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q43. Your company is migrating its current, custom-built reporting solution to Power BI. The Po...
- Q44. You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibi...
- Q45. You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of file...
- Q46. You have a group of data scientists who must create machine learning models and run period...
- Q47. You are using an Azure Synapse notebook to create a Python visual. You run the following c...
- Q48. You have a deployment pipeline for a Power BI workspace. The workspace contains two datase...
- Q49. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q50. You have an Azure Synapse workspace named Workspace1. You need to use PySpark in a noteboo...
- Q51. You need to populate the CustomersWithProductScore table. How should you complete the stor...
- Q52. You are running a diagnostic against a query as shown in the following exhibit. (Exhibit) ...
- Q53. You need to integrate the external data source to support the planned changes. Which three...
- Q54. You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails c...
- Q55. You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of file...
- Q56. Which two possible tools can you use to identify what causes the report to render slowly? ...
- Q57. You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You ne...
- Q58. You are using Azure Synapse Studio to explore a dataset that contains data about taxi trip...
- Q59. You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibi...
- Q60. You have the Power BI workspaces shown in the following exhibit. (Exhibit) Use the drop-do...
- Q61. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q62. You need to implement object-level security (OLS) in the Power Bl dataset for the sales as...
- Q63. You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files re...
- Q64. What should you configure in the deployment pipeline?...
- Q65. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q66. You have an Azure Synapse Analytics notebook. You run the xxsq1 magic command to render da...
- Q67. You have an Azure Data Lake Storage Gen 2 container that stores more than 300,000 files re...
- Q68. You have a team of business analysts that uses Power Bl for departmental analytics. The te...
- Q69. You are building a Power Bl dataset that contains a table named Calendar. Calendar contain...
- Q70. You need to recommend a solution for the customer workspaces to support the planned change...
- Q71. You need to identify the root cause of the data refresh issue. What should you use?...
- Q72. How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?...
- Q73. You are planning a Power Bl solution for a customer. The customer will have 200 Power Bl u...
- Q74. You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses...
- Q75. You are planning a Power Bl solution for a customer. The customer will have 200 Power Bl u...
- Q76. You have a Power Bl dataset that contains the following measure. (Exhibit) You need to imp...
- Q77. You have a deployment pipeline for a Power BI workspace. The workspace contains two datase...
- Q78. You have a Power Bl report that contains the table shown in the following exhibit. (Exhibi...
- Q79. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q80. You have a sales report as shown in the following exhibit. (Exhibit) The sales report has ...
- Q81. You are using GitHub as a source control solution for an Azure Synapse Studio workspace. Y...
- Q82. You discover a poorly performing measure in a Power Bl data model. You need to review the ...
- Q83. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q84. You plan to create a Power Bl report that will use an OData feed as the data source. You w...
- Q85. You have a Power Bl tenant that is configured as shown in the following exhibit. (Exhibit)...
- Q86. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q87. You have a Power BI tenant. You plan to register the tenant in an Azure Purview account. Y...
- Q88. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q89. You have a kiosk that displays a Power Bl report page. The report uses a dataset that uses...
- Q90. You are building a Power Bl dataset that contains a table named Calendar. Calendar contain...
- Q91. You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs...
- Q92. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q93. You have an Azure Synapse Analytics dataset that contains data about jet engine performanc...
- Q94. The enterprise analytics team needs to resolve the DAX measure performance issues. What sh...
- Q95. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q96. You need to populate the CustomersWithProductScore table. How should you complete the stor...
- Q97. You are using an Azure Synapse notebook to create a Python visual. You run the following c...
- Q98. You are creating a Power Bl Desktop report. You add a Python visual to the report page. Yo...
- Q99. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q100. You are configuring Azure Synapse Analytics pools to support the Azure Active Directory gr...
- Q101. You have a Power Bl dataset named Dataset1 that uses DirectQuery against an Azure SQL data...
- Q102. You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You ne...
- Q103. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q104. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
