Valid DA-100 Dumps shared by ExamDiscuss.com for Helping Passing DA-100 Exam! ExamDiscuss.com now offer the newest DA-100 exam dumps, the ExamDiscuss.com DA-100 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DA-100 dumps with Test Engine here:
Access DA-100 Dumps Premium Version
(150 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 9/55
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?
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?
Correct Answer: B
With Power BI Desktop, when you connect to your data source, it's always possible to import a copy of the data into the Power BI Desktop. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
DirectQuery: No data is imported or copied into Power BI Desktop. For relational sources, the selected tables and columns appear in the Fields list. For multi-dimensional sources like SAP Business Warehouse, the dimensions and measures of the selected cube appear in the Fields list. As you create or interact with a visualization, Power BI Desktop queries the underlying data source, so you're always viewing current data.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
- Question List (55q)
- Question 1: What should you create to meet the reporting requirements of...
- Question 2: You have a data model that contains many complex DAX express...
- Question 3: You are configuring a Microsoft Power Bl data model to enabl...
- Question 4: You publish a Microsoft Power BI dataset to powerbi.com. The...
- Question 5: You have four sales regions. Each region has multiple sales ...
- Question 6: You are enhancing a Power BI model that has DAX calculations...
- Question 7: You have sales data in a star schema that contains four tabl...
- Question 8: You have a Microsoft Power BI data model that contains three...
- Question 9: You have an Azure SQL database that contains sales transacti...
- Question 10: You need to create a relationship in the dataset for RLS. Wh...
- Question 11: You have a prospective customer list that contains 1,500 row...
- Question 12: You have the visual shown in the exhibit. (Click the Exhibit...
- Question 13: You view a query named Transactions as shown in the followin...
- Question 14: You have a line chart that shows the number of employees in ...
- Question 15: Note: This question is part of a series of questions that pr...
- Question 16: You are modeling data in table named SalesDetail by using Mi...
- Question 17: You open a query in Power Query Editor. You need to identify...
- Question 18: You are creating a quick measure as shown in the following e...
- Question 19: Which DAX expression should you use to get the ending balanc...
- Question 20: You have a Microsoft Power BI data model that contains three...
- Question 21: You have a power BI tenant that hosts the datasets shown in ...
- Question 22: You have sales data in a star schema that contains four tabl...
- Question 23: You use an R visual to produce a map of 500,000 customers. Y...
- Question 24: You have a custom connector that returns ID, From, To, Subje...
- Question 25: You have a query named Customer that imports CSV files from ...
- Question 26: You need to configure access for the sales department users....
- Question 27: Note: This question is part of a series of questions that pr...
- Question 28: You have a sales system that contains the tables shown in th...
- Question 29: You need to create a visualization to meet the reporting req...
- Question 30: You create a dashboard by using the Microsoft Power Bl Servi...
- Question 31: You need to create the dataset. Which dataset mode should yo...
- Question 32: Once the profit and loss dataset is created, which four acti...
- Question 33: You need to create the Top Customers report. Which type of f...
- Question 34: You have a dataset named Pens that contains the following co...
- Question 35: You have two Azure SQL databases that contain the same table...
- Question 36: In Power BI Desktop, you are building a sales report that co...
- Question 37: You have a Power BI tenant. You have reports that use financ...
- Question 38: You are reviewing a query that produces 10,000 rows in the P...
- Question 39: You have a report that includes a card visualization. You ne...
- Question 40: You have the dataset shown in the following exhibit. (Exhibi...
- Question 41: You need to create a relationship in the dataset for RLS. Wh...
- Question 42: You have a Power BI report. You need to create a calculated ...
- Question 43: Note: This question is part of a series of questions that pr...
- Question 44: You need to create relationships to meet the reporting requi...
- Question 45: Note: This question is part of a series of questions that pr...
- Question 46: You need to create a visualization that compares revenue and...
- Question 47: You have the Power BI data model shown in the following exhi...
- Question 48: You need to create a measure that will return the percentage...
- Question 49: Your company has employees in 10 states. The company recentl...
- Question 50: You need to create a relationship between the Weekly_Returns...
- Question 51: You have a table that contains sales data and approximately ...
- Question 52: Your company plans to completely separate development and pr...
- Question 53: You create a report by using Microsoft Power BI Desktop. The...
- Question 54: Note: This question is part of a series of questions that pr...
- Question 55: You have a folder of monthly transaction extracts. You plan ...
