Certification Training for DA-100 Exam Dumps Test Engine [2021]
Sep 03, 2021 Step by Step Guide to Prepare for DA-100 Exam
NEW QUESTION 56
You build a report to analyze customer transactions from a database that contains the tables shown in the following table.
You import the tables.
Which relationship should you use to link the tables?
- A. one-to-one between Customer and Transaction
- B. one-to-many from Transaction to Customer
- C. many-to-many between Customer and Transaction
- D. one-to-many from Customer to Transaction
Answer: D
Explanation:
Explanation
Each customer can have many transactions.
For each transaction there is exactly one customer.
NEW QUESTION 57
Your company has affiliates who help the company acquire customers.
You build a report for the affiliate managers at the company to assist them in understanding affiliate performance.
The managers request a visual showing the total sales value of the latest 50 transactions for each affiliate. You have a data model that contains the following tables.
You need to develop a measure to support the visual.
How should you complete the DAX expression? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/dax/topn-function-dax
NEW QUESTION 58
You have a data model that contains many complex DAX expressions.
The expressions contain frequent references to the related and relatedtable functions.
You need to recommend a solution to minimize the use of the related and relatedtable functions.
What should you recommend?
- A. Merge tables by using Power Query. )
- B. Hide unused columns in the model. )
- C. Transpose.
- D. Split the model into multiple models.
Answer: A
Explanation:
Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.
When you have one or more columns that you'd like to add to another query, you merge the queries.
Note: The RELATEDTABLEfunction is a shortcut for CALCULATETABLE function with no logical expression.
CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
NEW QUESTION 59
You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"}) A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
- A. 0
- B. 1
- C. 21318 Lasalle Street
- D. 21319 Lasalle Street
Answer: D
Explanation:
Explanation
Example:
Replace the text "ur" with the text "or" in the table.
Reference:
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
NEW QUESTION 60
You receive revenue data that must be included in Microsoft Power Bl reports.
You perform an initial load of the data from a Microsoft Excel source as shown in the following exhibit.
You plan to create several visuals from the data, including a visual that shows revenue split by year and product.
You need to transform the data to ensure that you can build the visuals. The solution must ensure that the columns are named appropriately for the data that they contain.
Answer:
Explanation:
NEW QUESTION 61
You need to provide a user with the ability to add members to a workspace. The solution must use the principle of least privilege.
Which role should you assign to the user?
- A. Viewer
- B. Member
- C. Admin
- D. Contributor
Answer: B
Explanation:
Explanation
A Member can add members or others with lower permissions.
Note:
NEW QUESTION 62
You create a dashboard by using the Microsoft Power Bl Service. The dashboard contains a card visual that shows total sales from the current year. You grant users access to the dashboard by using the viewer role on the workspace. A user wants to receive daily notifications of the number shown on the card visual. You need to automate the notifications. What should you do?
- A. Share the dashboard to the user.
- B. Create a subscription.
- C. Create a data alert.
- D. Tag the user in a comment.
Answer: B
Explanation:
Explanation
You can subscribe yourself and your colleagues to the report pages, dashboards, and paginated reports that matter most to you. Power BI e-mail subscriptions allow you to:
* Decide how often you want to receive the emails: daily, weekly, hourly, monthly, or once a day after the initial data refresh.
* Choose the time you want to receive the email, if you choose daily, weekly, hourly, or monthly.
Note: Email subscriptions don't support most custom visuals. The one exception is those custom visuals that have been certified.
Email subscriptions don't support R-powered custom visuals at this time.
Reference:
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe
https://docs.microsoft.com/en-us/power-bi/create-reports/service-set-data-alerts
NEW QUESTION 63
You are creating a Microsoft Power BI data model that has the tables shown in the following table.
The Products table is related to the ProductCategory table through the ProductCategoryID column.
You need to ensure that you can analyze sales by product category.
How should you configure the relationships from Products to ProductCategory? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
Box 1: One-to-many
Box 2: Both
For One-to-many relationships, the cross filter direction is always from the "one" side, and optionally from the "many" side (bi-directional).
Note:
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand
NEW QUESTION 64
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Set the refresh frequency to Daily.
- B. Configure the dataset to use the personal gateway.
- C. Deploy an On-premises data gateway in personal mode.
- D. Configure the dataset to use the existing On-premises data gateway.
Answer: A,C
Explanation:
B: The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI.
On-premises data gateway (personal mode) allows one user to connect to sources, and can't be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you're the only person who creates reports, and you don't need to share any data sources with others.
C: For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
NEW QUESTION 65
You are building a dataset from a JSON file that contains an array of documents.
You need to import attributes as columns from all the documents in the JSON file. The solution must ensure that date attributes can be used as date hierarchies in Microsoft Power BI reports.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
NEW QUESTION 66
You have a folder of monthly transaction extracts.
You plan to create a report to analyze the transaction data.
You receive the following email message: "Hi. I've put 24 files of monthly transaction data onto the shared drive. File Transactions201901.csv through Transactions201912.csv have the latest set of columns, but files Transactions201801.csv to Transactions201812.csv have an older layout without the extra fields needed for analysis. Each file contains 10 to 50 transactions." You get data from the folder and select Combine & Load. The Combine Files dialog box is shown in the exhibit. (Click the Exhibit tab.)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 67
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Set the refresh frequency to Daily.
- B. Configure the dataset to use the personal gateway.
- C. Deploy an On-premises data gateway in personal mode.
- D. Configure the dataset to use the existing On-premises data gateway.
Answer: A,C
Explanation:
B: The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on- premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI.
On-premises data gateway (personal mode) allows one user to connect to sources, and can't be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well- suited to scenarios where you're the only person who creates reports, and you don't need to share any data sources with others.
C: For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently.
Incorrect Answers:
A: On-premises data gateway allows multiple users to connect to multiple on-premises data sources. You can use an on-premises data gateway with all supported services, with a single gateway installation. This gateway is well-suited to complex scenarios with multiple people accessing multiple data sources.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
NEW QUESTION 68
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?
- A. Set Data Connectivity mode to DirectQuery.
- B. Add a SQL statement.
- C. Set the Command timeout in minutes setting.
- D. Set Data Connectivity mode to Import.
Answer: A
Explanation:
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
NEW QUESTION 69
You publish a Microsoft Power BI dataset to powerbi.com. The dataset appends data from an on-premises Oracle database and an Azure SQL database by using one query.
You have admin access to the workspace and permission to use an existing On-premises data gateway for which the Oracle data source is already configured.
You need to ensure that the data is updated every morning. The solution must minimize configuration effort.
Which two actions should you perform when you configure scheduled refresh? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Configure the dataset to use the personal gateway.
- B. Set the refresh frequency to
- C. Deploy an On-premises data gateway in personal mode.
- D. Configure the dataset to use the existing On-premises data gateway.
Answer: B,C
Explanation:
Explanation
B: The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI.
On-premises data gateway (personal mode) allows one user to connect to sources, and can't be shared with others. An on-premises data gateway (personal mode) can be used only with Power BI. This gateway is well-suited to scenarios where you're the only person who creates reports, and you don't need to share any data sources with others.
C: For Power BI users, refreshing data typically means importing data from the original data sources into a dataset, either based on a refresh schedule or on-demand. You can perform multiple dataset refreshes daily, which might be necessary if the underlying source data changes frequently.
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
NEW QUESTION 70
Hotspot Question
You are creating an analytics report that will consume data from the tables shown in the following table.
There is a relationship between the tables.
There are no reporting requirements on employeejd and employee_photo.
You need to optimize the data model.
What should you configure for employeejd and employee.photo? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
NEW QUESTION 71
......
Ultimate Guide to Prepare DA-100 Certification Exam for Microsoft Certified: Data Analyst Associate: https://www.torrentvce.com/DA-100-valid-vce-collection.html