070-779 무료 덤프문제 온라인 액세스

You have a query that retrieves customers and their locations. You have a sample of the data as shown in the following table.

Additional customers and locations are added frequently.
You need to transform the data as shown in the following table.

What should you do?

• A.Select the Customer columns, and then click Unpivot Columns.
• B.Select the Customer columns, and then click Unpivot Other Columns.
• C.Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into rows.
• D.Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into columns.

You have a data model that has the following tables.

You create a PivotTable. The data displayed in the PivotTable is shown in the following table.

You need to ensure that the correct data is displayed.
What should you do?

• A.Configure the PivotTable Options
• B.Modify the relationships
• C.Refresh the data connection
• D.Modify the workbook connections

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have a query named Query1 that retrieves the user information from two Excel files. One of the Excel files does not contain location information. A sample of the data retrieved by the query is shown in the following table.

You need to ensure that values in UserName are unique. The solution must ensure that the locations are retained. A sample of desired output is shown in the following table.

Solution: You use the Group By function to group the rows by UserName and you specify output columns for UserID and Location by using the Max operation.
Does this meet the goal?

• A.No
• B.Yes

Note: This question is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each question presents a different goal and answer choices, but the text of the scenario is the same in each question in this series.
Start of repeated scenario
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit.

Your company has 100 product subcategories and more than 10,000 products.
End of repeated scenario.
You need to create a simplified view of the workbook for some users. The simplified view must only display data from FactSales, DimProduct, and DimDate.
What should you do in the data model?

• A.Create a new perspective.
• B.Modify the Table Behavior settings for FactSales, DimProduct, and DimDate.
• C.Add the columns from FactSales, DimProduct, and DimDate to the Default Field Set.
• D.Click Hide from Client Tolls for all the tables except FactSales, DimProduct, and DimDate.

From a workbook query, you import a table that has the following data.

You need to configure the table to appear as shown in the following table.

What should you do?

• A.From the Extract menu, click Last Characters.
• B.From the Split Column menu, click By Delimiter.
• C.From the Format menu, click Trim.
• D.From the Format menu, click Clean.