Microsoft 70-470 - Recertification for MCSE: Business Intelligence Exam
Page: 1 / 64
Total 316 questions
Question #1 (Topic: Topic 1)
You need to create the KPI in the AdhocReports project in time for the next production
release cycle.
What should you do?
release cycle.
What should you do?
A. Create a measure by using the SUM([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.
B. Create a KPI based on the OrderQuantity column and then set the target value. Check in the changes before the next release cycle.
C. Create a measure by using the SUM([OrderQuantity]) expression. Then use the CREATE KPI CURRENTCUBE statement to define the KPI and target value. Check in the changes before the next release cycle.
D. Create a measure by using the COUNT([OrderQuantity]) expression and create a KPI based on the measure. Then set the target value. Check in the changes before the next release cycle.
Answer: C
Question #2 (Topic: Topic 1)
You need create the data source view for the StandardReports project.
What should you do?
What should you do?
A. Generate a relational schema from the dimensions and cubes by using the Schema Generation wizard.
B. Create a data source, connect it to the data warehouse, and then use the Data Source View wizard.
C. Execute the Import from Table wizard and then use the Data Source View wizard.
D. Create a new data source view and then use the Import from Table wizard.
Answer: B
Question #3 (Topic: Topic 1)
You need to deploy the StandardReports project.
What should you do? (Each correct answer presents a complete solution. Choose all that
apply.)
What should you do? (Each correct answer presents a complete solution. Choose all that
apply.)
A. Deploy the project from SQL Server Data Tools (SSDT).
B. Use the Analysis Services Deployment utility to create an XMLA deployment script.
C. Use the Analysis Services Deployment wizard to create an MDX deployment script.
D. Use the Analysis Services Deployment wizard to create an XMLA deployment script.
Answer: A,D
Question #4 (Topic: Topic 1)
You need to create a measure for DOD sales.
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
What should you do? (Each correct answer presents part of the solution. Choose all that
apply.)
A. Specify a date table by using a Mark as Date table.
B. Use the Data Analysis Expressions (DAX) PARALLELPERIOD() function.
C. Use the Business Intelligence Wizard to define time intelligence.
D. Use the Multidimensional Expressions (MDX) LAG() function.
Answer: A,C
Question #5 (Topic: Topic 1)
You need to complete the design of the data warehouse.
Which design should you use? (To answer, drag the appropriate tables and relationships to
the correct location in the answer area. Use only the tables and relationships that apply.)
[Microsoft-70-470-5.0/Microsoft-70-470-9_2.png]
Which design should you use? (To answer, drag the appropriate tables and relationships to
the correct location in the answer area. Use only the tables and relationships that apply.)
[Microsoft-70-470-5.0/Microsoft-70-470-9_2.png]
Answer: [Microsoft-70-470-5.0/Microsoft-70-470-10_2.png]