callicon +1 210 504 8191
whatsAppIcon +1 210 415 9856
emailIcon info@koenig-solutions.com
koenig-logo
Login
whatsAppIcon +1 210 415 9856
phoneIcon +1 210 504 8191
koenig-logo
All Courses

DA-100 Analyze Data with Power BI Quiz Questions and Answers

Answer :
  • Set Data Connectivity mode to DirectQuery.

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.
Answer :
  • Split the Date column into two columns, one that contains only the time and another that contains only the date.

Explanation :

We have to separate date & time tables. Also, we donג€™t need to put the time into the date table, because the time is repeated every day. Split your DateTime column into a separate date & time columns in fact table, so that you can join the date to the date table & the time to the time table. The time need to be converted to the nearest round minute or second so that every time in your data corresponds to a row in your time table.
Answer :
  • Create a parameter and update the queries to use the parameter.

Explanation :

As you can't edit datasets data sources in Power BI service, we recommend using parameters to store connection details such as instance names and database names, instead of using a static connection string. This allows you to manage the connections through the Power BI service web portal, or using APIs, at a later stage
Answer :
  • No

Explanation :

Instead modify the source step of the queries to use DataSourceExcel as the file path. Note: Parameterising a Data Source could be used in many different use cases. From connecting to different data sources defined in Query Parameters to load different combinations of columns.
Answer :
  • Split the Logged column by using at as the delimiter.

Explanation :

The column needs to be in Date format. We need to split the column to a date part and a time of day part. In Power Query, you can split a column through different methods. In this case, the column(s) selected can be split by a delimiter