PL300 by Rufat Babayev Q&A

What can be achieved by removing unnecessary rows and columns? 

• It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.

• Deleting unnecessary rows and columns can damage the structure of the data model.

• Deleting unnecessary rows and columns will reduce the dataset size and it is a good practice to load only necessary data into your data model.

Your goal is to adjust this table to match the desired format.  

What should you do?

• From the Format menu, click Trim.

• From the Extract menu, click Last Characters.

• From the Split Column menu, click By Delimiter.

• From the Extract menu, click Text After Delimiter.

 How many rows does Power Query scan to detect the type of data in the columns?  

• 10,000

• 1,000

• 100

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

5. For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel file located in a Microsoft SharePoint folder. The data model contains several measures You need to create a Power BI report from the existing data. The solution must minimize development effort.

Which type of data source should you use?

• Power BI dataset

• a SharePoint folder

• an Excel workbook

 If you have two queries that contain different data with the same structure, and you want to combine them into one query, which operation should you perform?  

• Merge

• Append

• Combine column

There are [answer choice] different values in State including nulls

• 4

• 65

• 69

• 73

There are [answer choice] non-null values that occur only once in State. 

• 4

• 65

• 69

• 73

  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?   

• 1318

• 1319

• 21318 Lasalle Street

• 21319 Lasalle Street

Choose right answers

There are [answer choice] csv files

• 9

• 10

• 25

• 90

• 1000