Join the discussion
Question 1/127
You are implementing a reporting solution that has the following requirements:
* Reports for external customers must support 500 concurrent requests. The data for these reports is approximately 7 GB and is stored in Azure Synapse Analytics.
* Reports for the security team use data that must have local security rules applied at the database level to restrict access. The data being reviewed is 2 GB.
Which storage mode provides the best response time for each group of users?
* Reports for external customers must support 500 concurrent requests. The data for these reports is approximately 7 GB and is stored in Azure Synapse Analytics.
* Reports for the security team use data that must have local security rules applied at the database level to restrict access. The data being reviewed is 2 GB.
Which storage mode provides the best response time for each group of users?
Correct Answer: A
With DirectQuery, queries are sent back to your Azure Synapse Analytics in real time as you explore the data. Real-time queries, combined with the scale of Synapse Analytics enables users to create dynamic reports in minutes against terabytes of data.
Need import for the security team for local security rules.
Need import for the security team for local security rules.
Add Comments
- Other Question (127q)
- Q1. You are implementing a reporting solution that has the following requirements: * Reports f...
- Q2. You are using DAX Studio to analyze a slow-running report query. You need to identify inef...
- Q3. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q4. You have an Azure Synapse workspace named Workspace1. You need to use PySpark in a noteboo...
- Q5. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q6. You have a dataset that contains a table named UserPermissions. UserPermissions contains t...
- Q7. You need to use Power Bl to ingest data from an API. The API requires that an API key be p...
- Q8. You have a group of data scientists who must create machine learning models and run period...
- Q9. Note: This question is part of a scries of questions that present the same scenario. Each ...
- Q10. You are planning a Power Bl solution for a customer. The customer will have 200 Power Bl u...
- Q11. You have a sales report as shown in the following exhibit. (Exhibit) The sales report has ...
- Q12. You have a Power Bl dataset that contains the following measure. (Exhibit) You need to imp...
- Q13. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q14. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q15. You are running a diagnostic against a query as shown in the following exhibit. (Exhibit) ...
- Q16. You have a Power Bl dataset. The dataset contains data that is updated frequently. You nee...
- Q17. You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset ...
- Q18. You have an Azure Synapse notebook. You need to create the visual shown in the following e...
- Q19. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q20. You plan to generate a line chart to visualize and compare the last six months of sales da...
- Q21. You have the following Python code in an Apache Spark notebook. (Exhibit) Which type of ch...
- Q22. You have a group of data scientists who must create machine learning models and run period...
- Q23. You develop a solution that uses a Power Bl Premium capacity. The capacity contains a data...
- Q24. You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You ne...
- Q25. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q26. You discover a poorly performing measure in a Power Bl data model. You need to review the ...
- Q27. You have a Power Bl dataset that contains two tables named Table1 and Table2. The dataset ...
- Q28. How should you configure the Power BI dataset refresh for the dbo.SalesTransactions table?...
- Q29. You develop a solution that uses a Power Bl Premium capacity. The capacity contains a data...
- Q30. You are building a Power Bl dataset that will use two data sources. The dataset has a quer...
- Q31. You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen...
- Q32. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q33. You have a Power Bl report that contains the table shown in the following exhibit. (Exhibi...
- Q34. You are creating a Power Bl Desktop report. You add a Python visual to the report page. Yo...
- Q35. You open a Power Bl Desktop report that contains an imported data model and a single repor...
- Q36. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q37. You use the Vertipaq Analyzer to analyze tables in a dataset as shown in the Tables exhibi...
- Q38. You have a Power BI workspace named Workspace1 that contains five dataflows. You need to c...
- Q39. You discover a poorly performing measure in a Power Bl data model. You need to review the ...
- Q40. Note: This question is part of a scries of questions that present the same scenario. Each ...
- Q41. You have the Power BI workspaces shown in the following exhibit. (Exhibit) Use the drop-do...
- Q42. You are creating a Power B1 single-page report. Some users will navigate the report by usi...
- Q43. You have two Power BI reports named Report1 and Report2. Report1 connects to a shared data...
- Q44. You are using Azure Synapse Studio to explore a dataset that contains data about taxi trip...
- Q45. You are using DAX Studio to analyze a slow-running report query. You need to identify inef...
- Q46. You need to recommend a solution to resolve the query issue of the serverless SQL pool. Th...
- Q47. You are optimizing a Power Bl data model by using DAX Studio. You need to capture the quer...
- Q48. You deploy a tabular model named DM! to a Power Bl Premium capacity. DM1 was created as an...
- Q49. You are building a Power Bl dataset that contains a table named Calendar. Calendar contain...
- Q50. Your company is migrating its current, custom-built reporting solution to Power BI. The Po...
- Q51. You need to provide users with a reproducible method to connect to a data source and trans...
- Q52. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q53. You need to identify the root cause of the data refresh issue. What should you use?...
- Q54. You have a Power BI tenant. You plan to register the tenant in an Azure Purview account. Y...
- Q55. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q56. You need to populate the CustomersWithProductScore table. How should you complete the stor...
- Q57. You have an Azure subscription that contains an Azure Synapse Analytics workspace. You cre...
- Q58. You are implementing a reporting solution that has the following requirements: * Reports f...
- Q59. You need to configure a source control solution for Azure Synapse Analytics. The solution ...
- Q60. You are building a Power Bl dataset that contains a table named Calendar. Calendar contain...
- Q61. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q62. You need to provide users with a reproducible method to connect to a data source and trans...
- Q63. You are enhancing a Power Bl model that has DAX calculations. You need to create a DAX mea...
- Q64. You need to configure a source control solution for Azure Synapse Analytics. The solution ...
- Q65. You are configuring a Power Bl report for accessibility as shown in the following table. (...
- Q66. You use Advanced Editor in Power Query Editor to edit a query that references two tables n...
- Q67. You are using an Azure Synapse notebook to create a Python visual. You run the following c...
- Q68. You are configuring an aggregation table as shown in the following exhibit. (Exhibit) The ...
- Q69. You need to integrate the external data source to support the planned changes. Which three...
- Q70. You are using an Azure Synapse Analytics serverless SQL pool to query network traffic logs...
- Q71. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q72. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q73. You use Advanced Editor in Power Query Editor to edit a query that references two tables n...
- Q74. You have a Power Bl tenant You invite an external consultant to work in the tenant. You ne...
- Q75. You are creating a Power Bl Desktop report. You add a Python visual to the report page. Yo...
- Q76. You are configuring Azure Synapse Analytics pools to support the Azure Active Directory gr...
- Q77. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q78. You are creating a Python visual in Power Bl Desktop. You need to retrieve the value of a ...
- Q79. You plan to a Power Bl dataset. You open the Impact analysis panel for the dataset and sel...
- Q80. You manage a Power BI dataset that queries a fact table named SalesDetails. SalesDetails c...
- Q81. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q82. You need to build a Transact-SQL query to implement the planned changes for the internal u...
- Q83. You have a Power Bl report that contains the visual shown in the following exhibit. (Exhib...
- Q84. You have a Power Bl dataset that uses DirectQuery against an Azure SQL database. Multiple ...
- Q85. You use Advanced Editor in Power Query Editor to edit a query that references two tables n...
- Q86. You are attempting to configure certification for a Power BI dataset and discover that the...
- Q87. You have a Power BI workspace named Workspace1 that contains five dataflows. You need to c...
- Q88. You have a Power Bl report hosted on the Power Bl service. The report displays expenses by...
- Q89. You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data. ...
- Q90. You have a Power Bl tenant that contains 10 workspaces. You need to create dataflows in th...
- Q91. You have an Azure Synapse workspace named Workspace1. You need to use PySpark in a noteboo...
- Q92. You need to recommend an automated solution to monitor Power Bl user activity. The solutio...
- Q93. You need to configure the Sales Analytics workspace to meet the ad hoc reporting requireme...
- Q94. You have a Power Bl dataset that contains the following measures: * Budget * Actuals * For...
- Q95. You are using a Python notebook in an Apache Spark pool in Azure Synapse Analytics. You ne...
- Q96. You have a Power Bl report that contains the table shown in the following exhibit. (Exhibi...
- Q97. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q98. You use an Apache Spark notebook in Azure Synapse Analytics to filter and transform data. ...
- Q99. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q100. You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen...
- Q101. You need to build a Transact-SQL query to implement the planned changes for the internal u...
- Q102. You are planning a Power Bl solution for a customer. The customer will have 200 Power Bl u...
- Q103. You need to create Power BI reports that will display data based on the customers' subscri...
- 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 dataset that contains the following measures: * Budget * Actuals * For...
- Q106. You have the following Python code in an Apache Spark notebook. (Exhibit) Which type of ch...
- Q107. You have a Power BI Premium capacity. You need to increase the number of virtual cores ass...
- Q108. You have the Power BI workspaces shown in the following exhibit. (Exhibit) Use the drop-do...
- Q109. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q110. You have five Power Bl reports that contain R script data sources and R visuals. You need ...
- Q111. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q112. You have the following code in an Azure Synapse notebook. (Exhibit) Use the drop-down menu...
- Q113. You need to populate the CustomersWithProductScore table. How should you complete the stor...
- Q114. You are attempting to configure certification for a Power BI dataset and discover that the...
- Q115. You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen...
- Q116. Note: This question is part of a series of questions that present the same scenario. Each ...
- Q117. You have a Power Bl dataset that has the query dependencies shown in the following exhibit...
- Q118. You have a Power Bl dataset that contains the following measure. (Exhibit) You need to imp...
- Q119. You have an Azure Synapse Analytics serverless SQL pool. You need to return a list of file...
- Q120. You have a Power Bl tenant. You need to ensure that all reports use a consistent set of co...
- Q121. You have an Azure Synapse Analytics serverless SQL pool and an Azure Data Lake Storage Gen...
- Q122. You have an Azure subscription that contains an Azure Synapse Analytics workspace. You cre...
- Q123. You are using DAX Studio to analyze a slow-running report query. You need to identify inef...
- Q124. After you answer a question in this section, you will NOT be able to return to it. As a re...
- Q125. You are configuring a Power Bl report for accessibility as shown in the following table. (...
- Q126. You have a Power Bl report that contains the visual shown in the following exhibit. (Exhib...
- Q127. You plan to create a Power Bl report that will use an OData feed as the data source. You w...
