Power Bi 2

You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)
The data has the following refresh requirements:

✑ Customer must be refreshed daily.

✑ Date must be refreshed once every three years.

✑ Sales must be refreshed in near real time.

✑ SalesAggregate must be refreshed once per week.

You need to select the storage modes for the tables. The solution must meet the following requirements:

✑ Minimize the load times of visuals.

✑ Ensure that the data is loaded to the model based on the refresh requirements.

Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

• Customer: Dual
  Date: Dual
  Sales: Import
  SalesAggregate: Import

• Customer: Dual
  Date: Dual
  Sales: Direct Query
  SalesAggregate: Import

• Customer: Import
  Date: Dual
  Sales: Import
  SalesAggregate: Import

• Customer: Dual
  Date: Dual
  Sales: Dual
  SalesAggregate: Import

You have a CSV file that contains user complaints. The file contains a column named Logged. Logged contains the date and time each complaint occurred. The data in Logged is in the following format: 2018-12-31 at 08:59.

You need to be able to analyze the complaints by the logged date and use a built-in date hierarchy.

What should you do?

• Apply a transformation to extract the last 11 characters of the Logged column and set the data type of the new column to Date.

• Change the data type of the Logged column to Date.

• Split the Logged column by using at as the delimiter.

• Apply a transformation to extract the first 11 characters of the Logged column.

You have a Microsoft Excel file in a Microsoft OneDrive folder.

The file must be imported to a Power BI dataset.

You need to ensure that the dataset can be refreshed in powerbi.com.

Which two connectors can you use to connect to the file? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

• Excel Workbook

• Text/CSV

• Folder

• SharePoint folder

• 
  Web

HOTSPOT -

You are profiling data by using Power Query Editor.

You have a table named Reports that contains a column named State. The distribution and quality data metrics for the data in State is shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.

NOTE: Each correct selection is worth one point.

Hot Area:

• 69
  4

• 65

  4

• 73
  4

• 69

  65

HOTSPOT -

You have two CSV files named Products and Categories.

The Products file contains the following columns:

✑ ProductID

✑ ProductName

✑ SupplierID

✑ CategoryID

The Categories file contains the following columns:

✑ CategoryID

✑ CategoryName

✑ CategoryDescription

From Power BI Desktop, you import the files into Power Query Editor.

You need to create a Power BI dataset that will contain a single table named Product. The Product will table includes the following columns:

✑ ProductID

✑ ProductName

✑ SupplierID

✑ CategoryID

✑ CategoryName

✑ CategoryDescription

How should you combine the queries, and what should you do on the Categories query? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

• Merge
  Delete the query

• Append
  Disable the query load

• Transpose
  Exclude the query from the report refresh

• Merge
  Disable the query load

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?

• Add a SQL statement.

• Set the Command timeout in minutes setting.

• Set Data Connectivity mode to Import.

• Set Data Connectivity mode to DirectQuery.

You have a folder that contains 100 CSV files.

You need to make the file metadata available as a single dataset by using Power BI. The solution must NOT store the data of the CSV files.

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.

Select and Place:

• 1-2-3

• 2-4-5

• 1-2-4

• 4-5-6

A business intelligence (BI) developer creates a dataflow in Power BI that uses DirectQuery to access tables from an on-premises Microsoft SQL server. The

Enhanced Dataflows Compute Engine is turned on for the dataflow.

You need to use the dataflow in a report. The solution must meet the following requirements:

✑ Minimize online processing operations.

✑ Minimize calculation times and render times for visuals.

✑ Include data from the current year, up to and including the previous day.

What should you do?

• Create a dataflows connection that has DirectQuery mode selected.

• Create a dataflows connection that has DirectQuery mode selected and configure a gateway connection for the dataset.

• Create a dataflows connection that has Import mode selected and schedule a daily refresh.

• Create a dataflows connection that has Import mode selected and create a Microsoft Power Automate solution to refresh the data hourly.

You publish a dataset that contains data from an on-premises Microsoft SQL Server database.

The dataset must be refreshed daily.

You need to ensure that the Power BI service can connect to the database and refresh the dataset.

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.

• 2 - 4 - 5 - 1

• 2 - 4 - 1 - 5

• 2 - 3 - 1 - 5

• 5 - 2 - 1 - 3

You attempt to connect Power BI Desktop to a Cassandra database.

From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.

You need to select an alternate data connector that will connect to the database.

Which type of connector should you choose?

• Microsoft SQL Server database

• ODBC

• OLE DB

• OData