PDF Version DemoPhone, tablet, laptop, desktop: the ActualPDF online version runs the Microsoft Recertification for MCSE: Business Intelligence simulation on any operating system, so 070-470 practice happens wherever you happen to be.
Microsoft 070-470 Exam Overview:
| Certification Vendor: | Microsoft |
|---|---|
| Exam Name: | Designing Business Intelligence Solutions with Microsoft SQL Server |
| Exam Number: | 70-470 |
| Exam Duration: | 120 minutes |
| Available Languages: | Simplified Chinese, English, Japanese |
| Related Certifications: | MCSE: Business Intelligence MCSA: SQL Server |
| Exam Price: | USD 165 (varies by region) |
| Certificate Validity Period: | Retired (no longer available for new certification / recertification paths) |
| Passing Score: | 700 (on a scale of 1000) |
| Real Exam Qty: | 40-60 |
| Exam Format: | Drag and drop, Multiple choice, Case studies |
| Sample Questions: |  |
| Exam Way: | Computer-based exam delivered via Pearson VUE (test center or online proctored where available) |
| Pre Condition: | Recommended experience with SQL Server, SSIS, SSAS, SSRS, and data warehouse concepts; typically associated with MCSA: SQL Server certification before MCSE: Business Intelligence |
| Official Syllabus URL: | https://learn.microsoft.com/en-us/credentials/certifications/retired-certifications |
Microsoft 070-470 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Topic 1: Implementing BI Solutions | - SQL Server Analysis Services (SSAS)
|
| Topic 2: BI System Deployment and Maintenance | - Security and Management
|
| Topic 3: Designing BI Solutions | - Designing a Data Warehouse Solution
|
070-470 Exam FAQ: Before You Book Your Seat
Microsoft Recertification for MCSE: Business Intelligence is an official Microsoft exam, listed under exam code 070-470. A passing result earns you the MCSE certification at the Expert level. It also ties into MCSE: Business Intelligence, MCSA: SQL Server, extending its value across your certification roadmap. Employers read this credential as verified competence, which is why it keeps appearing in job requirements.
Expect 40-60 questions inside 120 minutes on the Microsoft Recertification for MCSE: Business Intelligence exam. That pace punishes hesitation, so rehearse it: the ActualPDF software engine simulates the real exam scene, reminds you of the questions you got wrong, and pushes you to re-practice them until the clock stops being your enemy.
Passing Microsoft Recertification for MCSE: Business Intelligence requires 700 (on a scale of 1000), and the official registration fee is USD 165 (varies by region). Retakes charge the full USD 165 (varies by region) again, which is why experienced candidates treat preparation as the cheaper exam fee. Verify your readiness with repeated ActualPDF practice scores above the requirement before you commit to a date.
Recommended experience with SQL Server, SSIS, SSAS, SSRS, and data warehouse concepts; typically associated with MCSA: SQL Server certification before MCSE: Business Intelligence
Requirements evolve, so confirm the current conditions before registering on the official exam page.
Yes. ActualPDF provides a free download demo of the Microsoft Recertification for MCSE: Business Intelligence material, so you can check the content before choosing a version. After purchase, a one-year warranty covers you: the latest version is sent to you as it releases, free for 365 days, and after expiry you can extend the update service at a 50% discount.
Your purchase is covered by a 100% money-back guarantee with clear conditions. Take the Microsoft Recertification for MCSE: Business Intelligence exam within 60 days of purchase; if you fail, provide your unqualified result by submitting a scanned enrollment slip and the official Score Report PDF within 2 days of the exam, and the full refund is processed within 7 days. The exam must match your product, candidate and payer names must match, and attempts within 3 days of purchase, unused downloads, free materials, and expired orders are not covered. Alternatively, exchange for two other exam products of equal value, free, or wait for updates while keeping your original product's update service.
Delivery is instant: files unlock for download at payment and are emailed within one minute. If nothing arrives within 2 hours, check spam and contact customer service, which works 7/24 and normally replies within two hours. Installation is unlimited across your computers.
The Microsoft Recertification for MCSE: Business Intelligence syllabus spans 3 domains, led by BI System Deployment and Maintenance, Implementing BI Solutions, and Designing BI Solutions. The complete topic list is published above; candidates who study the map first rarely get lost later.
Microsoft Recertification for MCSE: Business Intelligence Sample Questions:
Question 1
You need to configure SSRS to meet the maximum number of snapshots requirement.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. In Reporting Services Configuration Manager, set the System Snapshot Limit option to
5.C. For each report, set the Limit number of snapshots option to 5.
B. In SharePoint Central Administration, set the System Snapshot Limit option to 5.
C. Use PowerShell to set the System Snapshot Limit option to 5.
Question 2
You have a SQL Server Reporting Services (SSRS) 2008 instance integrated with an Internet-facing Microsoft SharePoint 2010 farm. PerformancePoint Services and Excel Services are installed and configured.
You need to upgrade to SSRS 2012 with the minimum downtime and hardware requirements.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Install SSRS 2012 on a new SharePoint farm and migrate content to the new farm.
B. Perform an in-place upgrade of the SSRS environment.
C. Migrate SSRS content to new servers that run SSRS 2012.
D. Migrate SSRS content to a separate instance of SSRS 2012 on the same server.
Question 3
You are restructuring an existing cube. One of the measures in the cube is Amount. The Sum aggregation function is used for the Amount measure. The cube includes a dimension named Account and the dimension's Type property is set to Accounts. The Account dimension includes an account type attribute.
You need to ensure that the Amount measure aggregates correctly according to the account type classification. Development effort must be minimized.
What should you do? (More than one answer choice may achieve the goal. Select the BEST answer.)
A. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing AggregateFunction property value of the Amount measure to FirstNonEmpty and then use the application.
B. Develop a .NET application that uses Analysis Management Objects (AMO) to change the existing AggregateFunction property value of the Amount measure to ByAccount and then use the application.
C. Use SQL Server Data Tools to change the AggregateFunction property value of the Amount measure to ByAccount.
D. Add the ByAccount attribute to the account dimension.
Question 4
You need to fix the PowerPivot data refresh problem by using the least amount of administrative effort.
What should you do?
A. Use the PowerPivot Configuration Tool and select the Upgrade Features, Services, Applications and Solutions option.
B. In SharePoint Central Administration, create a target application and configure the PowerPivot service application settings to use the target application.
C. Use the PowerPivot Configuration Tool and select the Configure or Repair PowerPivot for SharePoint option.
D. Reinstall SSAS in PowerPivot for SharePoint mode by using the SQL Server 2012 installation media.
Question 5
You are developing a SQL Server Analysis Services (SSAS) cube for the sales department at your company.
The sales department requires the following set of metrics:
Unique count of customers
Unique count of products sold
Sum of sales
You need to ensure that the cube meets the requirements while optimizing query response time.
What should you do? (Each answer presents a complete solution. Choose all that apply.)
A. Place the distinct count measures in separate measure groups.
B. Use the Define Semiadditive Behavior page to disable semi-additive behavior.
C. Create a single measure group containing all measures
D. Use ROLAP storage for all partitions.
E. Use the Distinct Count and Sum measure aggregation functions.
F. Use the Define Semiadditive Behavior page to enable semi-additive behavior.
Solutions:
| Question 1 Answer: B | Question 2 Answer: C | Question 3 Answer: C | Question 4 Answer: C | Question 5 Answer: A,F |
