<< Prev Question Next Question >>

Question 53/138

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 (138q)
Question 1: A one-to-many relationship exists between the tables. The au...
Question 2: You build a report about warehouse inventory data. The datas...
Question 3: You create a dashboard by using the Microsoft Power Bl Servi...
Question 4: You have multiple dashboards. You need to ensure that when u...
Question 5: You need to create a measure that will return the percentage...
Question 6: Note: This question is part of a series of questions that pr...
Question 7: You have a Microsoft Power Bl dashboard. The report used to ...
Question 8: You need to create a Power Bl report. The first page or the ...
Question 9: In Power Bi Desktop, you are creating visualizations in a re...
Question 10: You embed a Power BI report in a Microsoft SharePoint Online...
Question 11: You have a PBiX file that imports several tables from an Azu...
Question 12: You have a Power Bl report that contains a measure named Tot...
Question 13: Note: This question is part of a series of questions that pr...
Question 14: You have the Power BI data model shown in the following exhi...
Question 15: Your company plans to completely separate development and pr...
Question 16: You need to create a relationship between the Weekly_Returns...
Question 17: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 18: You view a query named Transactions as shown in the followin...
Question 19: You are creating a report in Power BI Desktop. You load a da...
Question 20: You maintain a Power Bl workspace that contains a supplier q...
Question 21: You are building a Power Bl report that uses data from an Az...
Question 22: You publish a report to a workspace named Customer Services....
Question 23: You have a power BI tenant that hosts the datasets shown in ...
Question 24: You need to create relationships to meet the reporting requi...
Question 25: You have the dashboard shown in the following exhibit. (Exhi...
Question 26: You have a Power BI dashboard that displays different visual...
Question 27: You need to get data from the Microsoft SQL Server tables. W...
Question 28: You have a report that contains four pages. Each page contai...
Question 29: You use Power Query Editor to preview customer feedback data...
Question 30: You have a Power BI report named Report' and a dashboard nam...
Question 31: You are creating a Power BI model that contains a table name...
Question 32: Note: This question is part of a series of questions that pr...
Question 33: You create the following step by using Power Query Editor. =...
Question 34: You need to create a DAX measure in the data model that only...
Question 35: You have the data lineage shown in the following exhibit. (E...
Question 36: In Power BI Desktop, you are creating a report that will con...
Question 37: You need to provide a user with the ability to add members t...
Question 38: You are developing a report page. Some users will navigate t...
Question 39: You have a prospective customer list that contains 1,500 row...
Question 40: You have a Power Bl workspace named Inventory that contains ...
Question 41: You publish the dataset to powerbi.com. For each of the foll...
Question 42: You import a large dataset to Power Query Editor. You need t...
Question 43: You have a Power BI report that contains one page. The page ...
Question 44: You have a Power Bl report that contains three pages. The pa...
Question 45: You plan to create the chart shown in the following exhibit....
Question 46: Your organization has a team of power users who recently cre...
Question 47: You need to design the data model to meet the report require...
Question 48: You have a CSV file that contains user complaints. The file ...
Question 49: You have a collection of reports for the HR department of yo...
Question 50: You open a query in Power Query Editor. You need to identify...
Question 51: You need to design the data model and the relationships for ...
Question 52: You need to configure access for the sales department users....
Question 53: You have an Azure SQL database that contains sales transacti...
Question 54: You have a line chart that shows the number of employees in ...
Question 55: You have a Power BI dashboard that monitors the quality of m...
Question 56: You have the Azure SQL databases shown in the following tabl...
Question 57: You have a Power Bi report. The report contains a visual tha...
Question 58: You need to calculate the last day of the month in the balan...
Question 59: Note: This question is part of a series of questions that pr...
Question 60: You need to create a visualization that compares revenue and...
Question 61: You are building a dataset from a JSON file that contains an...
Question 62: You are creating a Power Bi model in Power BI Desktop You ne...
Question 63: You have a Power BI report. The report contains visualizatio...
Question 64: You have an API that returns more than 100 columns. The foll...
Question 65: You are building a Power Bl report. Users will view the repo...
Question 66: You have a Power Bi report that contains five bookmarks. You...
Question 67: You have a Power BI model that contains a table named Sales....
Question 68: What should you create to meet the reporting requirements of...
Question 69: You have a Power Bi model mat contains a table named Date. T...
Question 70: You have the following table named Location. (Exhibit) The G...
Question 71: You are profiling data by using Power Query Editor. You have...
Question 72: You create a dataset sourced from dozens of flat files in Az...
Question 73: You are using the key influencers visual to identify which f...
Question 74: You have a Microsoft Excel spreadsheet that contains the dat...
Question 75: You have a CSV file that contains user complaints. The file ...
Question 76: You have a report page that contains the visuals shown in th...
Question 77: For the sales department at your company, you publish a Powe...
Question 78: You have the line chart shown in the exhibit. (Click the Exh...
Question 79: Note: This question is part of a series of questions that pr...
Question 80: You have a report that contains a donut chart and a clustere...
Question 81: You need to create a visualization to meet the reporting req...
Question 82: You need to create a relationship in the dataset for RLS. Wh...
Question 83: You have a Microsoft Power Bl report. The size of PBIX file ...
Question 84: You are using existing reports to build a dashboard that wil...
Question 85: You have multiple dashboards. You need to ensure that when u...
Question 86: Note: This question is part of a series of questions that pr...
Question 87: You have a Power B1 data model that contains two tables name...
Question 88: You have two tables named Customers and Invoice in a Power B...
Question 89: You use an R visual to produce a map of 500,000 customers. Y...
Question 90: You have a table that contains the following three columns: ...
Question 91: You have a data model that contains many complex DAX express...
Question 92: You have a Power BI app named App1. The privacy for the App1...
Question 93: You have a Power Bl report. You have the following tables. (...
Question 94: You are creating an analytics report that will consume data ...
Question 95: Note: This question is part of a series of questions that pr...
Question 96: You have a report that contains three pages. One of the page...
Question 97: You have a Power BI model that has the following tables: Pro...
Question 98: You need to grant access to the business unit analysts. What...
Question 99: Your company plans to use Power BI for 20 users in the sales...
Question 100: Note: This question is part of a series of questions that pr...
Question 101: You have the visual shown in the exhibit. (Click the Exhibit...
Question 102: You have a Power Bl report for the marketing department. The...
Question 103: You have a Microsoft Excel workbook that contains two tables...
Question 104: You have a Power B1 report named ReportA. You have a Power B...
Question 105: You have two Power Bl reports named ReportA and ReportB that...
Question 106: Note: This question is a part of a series of questions that ...
Question 107: You build a report to help the sales team understand its per...
Question 108: Note: This question is part of a series of questions that pr...
Question 109: You need to create the Top Customers report. Which type of f...
Question 110: The Sales table contains records of sales by day from the la...
Question 111: You need to create a visual that enables the adhoc explorati...
Question 112: Note: This question is part of a series of questions that pr...
Question 113: You are creating a Power BI report to analyze consumer purch...
Question 114: Note: This question is part of a series of questions that pr...
Question 115: You are configuring a Microsoft Power Bl data model to enabl...
Question 116: You have a report in Power BI Desktop. You add a key influen...
Question 117: You have a column named UnitslnStock as shown in the followi...
Question 118: Your company plans to completely separate development and pr...
Question 119: You need to create the dataset. Which dataset mode should yo...
Question 120: You have a Microsoft Power Bl workspace. You need to grant t...
Question 121: (Exhibit) You have a dataset that has the permissions shown ...
Question 122: What should you do to address the existing environment data ...
Question 123: You are preparing a financial report in Power BI. You connec...
Question 124: You have a Power Bl query named Sates that imports the colum...
Question 125: You have a Power Bl workspace that contains a dataset. a rep...
Question 126: Note: This question is part of a series of questions that us...
Question 127: You have a large dataset that contains more than 1 million r...
Question 128: You are creating a Microsoft Power BI data model that has th...
Question 129: You have a sales system that contains the tables shown in th...
Question 130: You have a Q&amp;A visual that displays information from a t...
Question 131: You have a table that contains a column named Phone. The fol...
Question 132: You have a Rawer Bl report That imports a dace table and a s...
Question 133: You attempt to connect Purer 81 Desktop to a Cassandra datab...
Question 134: In Power BI Desktop, you are building a sales report that co...
Question 135: Your company has employees in 10 states. The company recentl...
Question 136: You have a dataset that contains revenue data from the past ...
Question 137: You use Power Bi Desktop to create a Power Bl data model and...
Question 138: Which DAX expression should you use to get the ending balanc...