Microsoft DA-100 Analyzing Data with Microsoft Power BI Online Training
Microsoft DA-100 Online Training
The questions for DA-100 were last updated at Dec 20,2024.
- Exam Code: DA-100
- Exam Name: Analyzing Data with Microsoft Power BI
- Certification Provider: Microsoft
- Latest update: Dec 20,2024
DRAG DROP
You are preparing a financial report in Power BI.
You connect to the data stored in a Microsoft Excel spreadsheet by using Power Query Editor as shown in the following exhibit.
You need to prepare the data to support the following:
✑ Visualizations that include all measures in the data over time
✑ Year-over-year calculations for all the measures
Which four 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.
HOTSPOT
You are creating a Microsoft Power Bl model that has two tables named CityData and Sales.
CityData contains only the data shown in the following table.
Sales contains only the data shown in the following table.
For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.
DRAG DROP
You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones.
You need to build the dashboard.
Which four 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.
You have a query that returns the data shown in the following exhibit.
You need to configure the query to display the data as shown in the following exhibit.
Which step should you use in the query?
- A . =Table.ExpandListColum(Table.TransformColunins(Source, {{"classes". Splitter.SplitTextByDelimiter(”,”, QuoteStyle.None), let itemType – (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "classes")
- B . = Table.Unpivot(Source, {"classes"}, "Attribute", "Value")
- C . = Table.SplitColumn(Source, "classes". Splitter.SplitTextByDelimiterf",", QuoteStyle.None), {"classes.1"})
- D . = Table.SplitColumn(Source, "classes". Splitter.SplitTextByPositions({10}), {"classes.1"})
Your company has training videos that are published to Microsoft Stream.
You need to surface the videos directly in a Microsoft Power BI dashboard.
Which type of tile should you add?
- A . video
- B . custom streaming data
- C . text box
- D . web content
You have the following three versions of an Azure SQL database:
✑ Test
✑ Production
✑ Development
You have a dataset that uses the development database as a data source.
You need to configure the dataset so that you can easily change the data source between the development, test, and production database servers from powerbi.com.
Which should you do?
- A . Create a JSON file that contains the database server names. Import the JSON file to the dataset.
- B . Create a parameter and update the queries to use the parameter.
- C . Create a query for each database server and hide the development tables.
- D . Set the data source privacy level to Organizational and use the ReplaceValue Power Query M function.
Latest DA-100 Dumps Valid Version with 114 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
