<< Prev Question Next Question >>

Question 72/98

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 (98q)
Question 1: You have a CSV file that contains user complaints. The file ...
Question 2: You have a Power Bl workspace that contains a single-page re...
Question 3: You build a report to help the sales team understand its per...
Question 4: You need to create a measure that will return the percentage...
Question 5: Your company plans to use Power BI for 20 users in the sales...
Question 6: You have a report in Power Bl named report1 that is based on...
Question 7: You have the following table named Location. (Exhibit) The G...
1 commentQuestion 8: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 9: You are enhancing a Power BI model that has DAX calculations...
Question 10: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 11: You are creating a Power BI report to analyze consumer purch...
Question 12: You have a Microsoft Power Bl dashboard. The report used to ...
Question 13: You have a Power Bl query named Sates that imports the colum...
Question 14: You have a Power BI model that contains a table named Sales....
Question 15: You import a large dataset to Power Query Editor. You need t...
Question 16: You are building a Power Bl report that uses data from an Az...
Question 17: You need to create the dataset. Which dataset mode should yo...
Question 18: You need to create a visualization to meet the reporting req...
Question 19: Your company plans to completely separate development and pr...
Question 20: Note: This question is part of a series of questions that pr...
Question 21: Note: This question is part of a series of questions that pr...
Question 22: You need to create the Top Customers report. Which type of f...
Question 23: You have a Microsoft Excel file in a Microsoft OneDrive fold...
Question 24: You have two Power Bl workspaces named WorkspaceA and Worksp...
Question 25: You open a query in Power Query Editor. You need to identify...
Question 26: You have a dataset named Pens that contains the following co...
Question 27: You are using Power Bi Desktop to connect to an Azure SQL da...
Question 28: You build a report about warehouse inventory dat a. The data...
Question 29: You have a Power 31 data model that contains a table named S...
Question 30: You are configuring a Microsoft Power Bl data model to enabl...
Question 31: You need to create a visualization that compares revenue and...
Question 32: Your organization has a team of power users who recently cre...
Question 33: You need to create the Top Customers report. Which type of f...
Question 34: You plan to create a dashboard in the Power BI service that ...
Question 35: You build a report to analyze customer transactions from a d...
Question 36: You have a table that contains the following three columns: ...
Question 37: You have an API that returns more than 100 columns. The foll...
Question 38: In Power Bi Desktop, you are creating visualizations in a re...
Question 39: You need to calculate the last day of the month in the balan...
Question 40: Note: This question is part of a series of questions that pr...
Question 41: The Sales table contains records of sales by day from the la...
Question 42: You plan to use Power BI Desktop optimized for Power BI Repo...
Question 43: You have the line chart shown in the exhibit. (Click the Exh...
Question 44: A business intelligence (Bl) developer creates a dataflow in...
Question 45: You need to create relationships to meet the reporting requi...
Question 46: You have sales data in a star schema that contains four tabl...
Question 47: You are creating a Microsoft Power BI data model that has th...
Question 48: Note: This question is part of a series of questions that us...
Question 49: You have a Power Bl report for the marketing department. The...
Question 50: You have four sales regions. Each region has multiple sales ...
Question 51: You are building a Power BI report to analyze customer segme...
Question 52: You have the Power BI data model shown in the following exhi...
Question 53: Note: This question is part of a series of questions that pr...
Question 54: You need to create the On-Time Shipping report. The report m...
Question 55: You have a prospective customer list that contains 1,500 row...
Question 56: You are creating a Power BI model that contains a table name...
Question 57: You have a Microsoft Power BI data model that contains three...
Question 58: You have a Power Bl report that uses row-level security (RLS...
Question 59: You plan to create a report that will display sales data fro...
Question 60: You have a Power Bl report. You have the following tables. (...
Question 61: Exhibit: (Exhibit) You need to create a report that meets th...
Question 62: You are building a financial report by using Power BI. You h...
Question 63: You plan to create a Power Bl dataset to analyze attendance ...
Question 64: Note: This question is a part of a series of questions that ...
Question 65: You have a Power Bl report that contains a measure named Tot...
Question 66: For the sales department at your company, you publish a Powe...
Question 67: You have a table that contains a column named Phone. The fol...
Question 68: From Power 61 Desktop, you publish a new dataset and report ...
Question 69: What should you create to meet the reporting requirements of...
Question 70: You have the Power BI data model shown in the following exhi...
Question 71: You have a report that contains a donut chart and a clustere...
Question 72: You have an Azure SQL database that contains sales transacti...
Question 73: You have a report that contains four pages. Each page contai...
Question 74: You have an on-premises Power BI Report Server. You plan to ...
Question 75: You are creating reports in Power BI Desktop. The model has ...
Question 76: You have a Power BI dashboard that displays different visual...
Question 77: You have a Power BI dashboard that monitors the quality of m...
Question 78: You use Power Bi Desktop to create a Power Bl data model and...
Question 79: You have a Power Bl report You have a table named Dalai that...
Question 80: What should you create to meet the reporting requirements of...
Question 81: You are profiling data by using Power Query Editor. You have...
Question 82: You have a Microsoft Exert spreadsheet named Excel1 that con...
Question 83: You have the dashboard shown in the following exhibit. (Exhi...
Question 84: You import two Microsoft Excel tables named Customer and Add...
Question 85: Note: This question is part of a series of questions that pr...
Question 86: You have a Power BI app named App1. The privacy for the App1...
Question 87: You have a Power Bl table named Customer that contains a fie...
Question 88: Note: This question is part of a series of questions that pr...
Question 89: Note: This question is part of a series of questions that pr...
Question 90: You need to provide a user with the ability to add members t...
Question 91: You have a Power BI report that contains one page. The page ...
Question 92: You need to design the data model to meet the report require...
Question 93: You need to create the required relationship for the executi...
Question 94: You need to recommend a strategy to consistently define the ...
Question 95: You are developing a sales report that will have multiple pa...
Question 96: You build a Power Bi report that displays loT temperature da...
Question 97: Note: This question is part of a series of questions that pr...
Question 98: You publish a Microsoft Power BI dataset to powerbi.com. The...