Microsoft 070-470

From a free demo to 365 days of free updates and a conditional money-back guarantee, Dumpkiller covers every stage of your Microsoft Recertification for MCSE: Business Intelligence preparation. Start with the 316 070-470 practice questions today and make 2026 the year you get certified.

Microsoft 070-470 Exam Overview:

Microsoft 070-470 Exam Syllabus Topics:

What Candidates Ask About the Microsoft 070-470 Exam

Can you give me an overview of the 070-470 exam?

The Microsoft Recertification for MCSE: Business Intelligence exam (code: 070-470) is the official Microsoft exam that leads to the MCSE certification. It sits at the Expert level of the Microsoft certification track. It is also connected with related credentials such as MCSE: Business Intelligence, MCSA: SQL Server. Passing it proves to employers that your skills have been validated by Microsoft itself, which is why the 070-470 credential keeps showing up in job postings.

How many questions are in the 070-470 exam, and how long does it take?

The Microsoft Recertification for MCSE: Business Intelligence exam gives you 120 minutes to work through 40-60. Pacing matters more than most candidates expect, so before exam day, run at least one full timed session in the Dumpkiller test engine to learn how long you can afford per question. If an item stalls you, flag it and move on — coming back later beats burning five minutes on a single question.

What score do I need to pass the 070-470 exam, and how much does it cost?

The passing score for the Microsoft Recertification for MCSE: Business Intelligence exam is 700 (on a scale of 1000), and the official registration fee is USD 165 (varies by region). Remember that a failed attempt means paying that fee in full again, so a timed self-assessment with Dumpkiller practice questions about a week before your exam date is a cheap way to confirm you are scoring comfortably above 700 (on a scale of 1000).

Are there any prerequisites for the 070-470 exam?

According to Microsoft, the following applies: Recommended experience with SQL Server, SSIS, SSAS, SSRS, and data warehouse concepts; typically associated with MCSA: SQL Server certification before MCSE: Business Intelligence. Certification policies do change from time to time, so confirm the latest requirements on the official exam page at https://learn.microsoft.com/en-us/credentials/certifications/retired-certifications before you register.

Can I try the 070-470 practice questions before buying?

Yes. Dumpkiller offers a free 070-470 PDF demo so you can review the question style, difficulty, and explanations before committing to anything. After purchase, your Microsoft Recertification for MCSE: Business Intelligence material includes 365 days of free updates, and if your product expires after that, you can extend the update service at a 50% discount from your member zone.

What happens if I do not pass the 070-470 exam, and how is my order delivered?

If you take the corresponding 070-470 exam within 60 days of your purchase and do not pass, you can apply for a full refund under our 100% Money Back Guarantee, subject to a few conditions: the failed exam must be the one matching your purchase; sitting the exam within 3 days of purchase does not qualify, since that leaves too little preparation time; downloading the material without actually taking the exam does not qualify; free materials and expired orders are excluded; and the candidate name must match the payer name. To apply, send a scanned copy of your enrollment slip together with your official Score Report (PDF) within 2 days after the exam, and claims are processed within 7 days. If you would rather not take a refund, you can exchange your purchase for two free products of equal value while keeping the update service on the product you originally bought. As for delivery, everything is an instant download: your products are sent to your email within one minute of payment — contact customer service if nothing arrives within 2 hours — and there is no limit on the number of computers you can install the software on.

What topics are covered in the 070-470 exam?

The official Microsoft Recertification for MCSE: Business Intelligence syllabus is organized into 3 main domains. The first three are Implementing BI Solutions, Designing BI Solutions, and BI System Deployment and Maintenance. For the full domain-by-domain breakdown, see the complete Exam Topics outline above.

Microsoft Recertification for MCSE: Business Intelligence Sample Questions:

Question #1

You are developing a SQL Server Analysis Services (SSAS) tabular project. A model defines a measure named Profit and includes a table named Date. The table includes year, semester, quarter, month, and date columns. The Date column is of data type Date. The table contains a set of contiguous dates.
You need to create a measure to report on year-over-year growth of profit.
What should you do? (Each answer presents a complete solution. Choose all that apply.)

A. Define the following calculation.Year Over Year Profit Growth:=[Profit] CALCULATE([Profit], PARALLELPERIOD('Date'[Date], -12, MONTH))
B. Use the Business Intelligence Wizard and then use the Define time intelligence enhancement.
C. Define the following calculation.Year Over Year Profit Growth:=[Profit] CALCULATE([Profit], SAMEPERIODLASTYEAR('Date'[Date]))
D. Define the following calculation.Year Over Year Profit Growth:=CALCULATE([Profit], DATEADD('Date'[Date], 1, YEAR))

Question #2

HOTSPOT
You are designing a SQL Server Reporting Services (SSRS) report that sources data from a SQL Azure database.
You need to design the report to show the sum of sales. The sales must be grouped by region on the rows and year on the columns.
Which report item should you add? To answer, select the appropriate setting in the answer area.

Question #3

A company has a relational data warehouse, a SQL Server Analysis Services (SSAS) database, and a SQL Server Reporting Services (SSRS) instance. The SSAS database contains a cube named Sales. Shared data sources exist in SSRS for the relational and SSAS databases. Each company department has its own report writers.
Report writers in the Marketing department want to create new reports by using Report Builder. Many reports will include data generated by a custom formula that references data stored either in a data warehouse table or in the Sales cube. The custom formula will compare time periods across multiple products, categories, and regions.
You have the following requirements:
- Ensure that only Marketing department report writers can access the custom
formula.
- Implement only one dataset.
- Ensure that the dataset references the data source that will provide the fastest
data retrieval.
You need to meet the requirements to support the Marketing department report writers.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Create and secure in the data warehouse a stored procedure that implements the custom formula. Create and deploy a shared dataset that references the data warehouse shared data source.
B. Create, deploy, and secure a shared dataset that references the data warehouse shared data source and includes custom Transact-SQL (T-SQL) code for the custom formula.
C. Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes a calculated member for the custom formula.
D. Create a calculated member in the Sales cube. Create, deploy, and secure a shared dataset that references the SSAS database shared data source and includes the calculated member from the cube.

Question #4

HOTSPOT
You are setting role permissions for a SQL Server Analysis Service (SSAS) cube.
You plan to grant Read access for specific attribute members only to specific Active Directory security groups.
You need to enter a Multidimensional Expressions (MDX) expression to configure the attribute member access.
On which tab should you enter the MDX expression? To answer, select the appropriate tab in the answer area.

Question #5

--- --
You are designing a fact table in a SQL Server database.
The fact table must meet the following requirements:
Include a columnstore index.
Allow users to choose up to 10 dimension tables and up to five facts at one time.
Maximize performance of queries that aggregate measures by using any of the 10
dimensions.
Support billions of rows.
Use the most efficient design strategy.
You need to design the fact table to meet the requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)

A. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on only the measure columns.
B. Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the measure columns.
C. Design a fact table with 10 dimensional key columns and 5 measure columns. Place the columnstore index on the dimensional key columns and the measure columns.
D. Design a fact table with 5 dimensional key columns and 10 measure columns. Place the columnstore index on the dimensional key columns.

Solutions: