<< Prev Question Next Question >>

Question 20/63

You have an Azure SQL database that contains sales transactions. The database is updated frequently.
You need to generate reports from the data to detect fraudulent transactions. The data must be visible within five minutes of an update.
How should you configure the data connection?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (63q)
1 commentQuestion 1: You have a collection of reports for the HR department of yo...
Question 2: You build a report about warehouse inventory dat a. The data...
Question 3: You have a Power BI report that uses a dataset based on an A...
Question 4: You have a report in Power BI Desktop as shown in the follow...
Question 5: You have a Microsoft Excel workbook that contains two tables...
Question 6: Note: This question is part of a series of questions that pr...
Question 7: You have five sales regions. Each region is assigned a singl...
Question 8: Note: This question is part of a series of questions that pr...
Question 9: ion have a Power BI dataset that contains a table named Temp...
Question 10: You need to create the Top Customers report. Which type of f...
Question 11: You are using existing reports to build a dashboard that wil...
Question 12: Note: This question is part of a series of questions that pr...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: Note: This question is part of a series of questions that pr...
Question 15: You need to create a visual as shown in the following exhibi...
Question 16: Your company has employees in 10 states. The company recentl...
Question 17: You have a large dataset that contains more than 1 million r...
Question 18: You need to create a measure that will return the percentage...
Question 19: You have a report page that contains the visuals shown in th...
Question 20: You have an Azure SQL database that contains sales transacti...
Question 21: You are creating an analytics report that will consume data ...
Question 22: You need to configure access for the sales department users....
Question 23: You have a prospective customer list that contains 1,500 row...
Question 24: You have a table that contains the following three columns: ...
Question 25: You are enhancing a Power BI model that has DAX calculations...
Question 26: How should you distribute the reports to the board? To answe...
Question 27: Your company plans to use Power BI for 20 users in the sales...
Question 28: You embed a Power BI report in a Microsoft SharePoint Online...
Question 29: You need to create a relationship between the Weekly_Returns...
Question 30: You need to create a relationship in the dataset for RLS. Wh...
Question 31: You have the tables shown in the following table. (Exhibit) ...
Question 32: You create a dataset sourced from dozens of flat files in Az...
Question 33: You have an on-premises Power BI Report Server. You plan to ...
Question 34: You have a Microsoft SharePoint Online site that contains se...
Question 35: You are reviewing a query that produces 10,000 rows in the P...
Question 36: You have a Power BI dashboard that monitors the quality of m...
Question 37: You need to create relationships to meet the reporting requi...
Question 38: You have a Power BI tenant. You have reports that use financ...
Question 39: Your organization has a team of power users who recently cre...
Question 40: Note: This question is part of a series of questions that pr...
Question 41: Your company has affiliates who help the company acquire cus...
Question 42: Note: This question is part of a series of questions that pr...
Question 43: You publish a report to a workspace named Customer Services....
Question 44: You need to calculate the last day of the month in the balan...
Question 45: You need to address the data concerns before creating the da...
Question 46: Note: This question is part of a series of questions that pr...
Question 47: You have the tables shown in the following table. (Exhibit) ...
Question 48: You have a table that contains a column named Phone. The fol...
Question 49: Note: This question is part of a series of questions that pr...
Question 50: You have multiple dashboards. You need to ensure that when u...
Question 51: You have a Microsoft Power BI data model that contains three...
Question 52: You import a large dataset to Power Query Editor. You need t...
Question 53: You have sales data in a star schema that contains four tabl...
Question 54: You plan to develop a Power BI report that has a bar chart t...
Question 55: You have multiple dashboards. You need to ensure that when u...
Question 56: You are profiling data by using Power Query Editor. The Addr...
Question 57: You have a Power BI report. You need to create a calculated ...
Question 58: You need to create a visualization to meet the reporting req...
Question 59: You have a folder of monthly transaction extracts. You plan ...
Question 60: You have an API that returns more than 100 columns. The foll...
Question 61: You have the following three versions of an Azure SQL databa...
Question 62: Your company has training videos that are published to Micro...
Question 63: You need to provide a user with the ability to add members t...