QUESTION: 1
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 two Microsoft SQL Server database servers named Production1 and Test1.
Production1 contains the same tables as Test1. but only a subset of the data. You add Test1 as a
data source, and you select 10 tables. You configure several transformations. You need to
connect the model to the tables in Production1. The solution must maintain the existing
transformations.
Solution You create a new connection to Production1, and then you import the tables.
Does this meet the goal?
A. yes
B. No
Answer: B
QUESTION 2
You are building a KPI.
You need to configure the KPI to display a red icon when the sales from a month is less than nine
percent of the sales from the last 12 months.
What should you use to define the target value?
A. an absolute value
B. a calculated column
C. a calculated field
D. a measure
Answer: A
QUESTION 3
You have an Excel workbook that contains a table named Sales.
You add Sales to the Power Pivot model.
You need to set a column named TransactionID as the row identifier for the Sales table.
What should you do?
A. From Power Pivot, modify the Table Behavior setting.
B. From Query Editor, add an index column.
C. From Query Editor, modify the Data Type.
D. From Power Pivot, modify the Default Field Set.
Answer: A
No comments:
Post a Comment