70-778 exam dumps

Microsoft 70-778 Value Package

(Include: PDF + Desktop Test Engine + Online Test Engine)

  • Exam Code: 70-778
  • Exam Name: Analyzing and Visualizing Data with Power BI
  • No. of Questions: 155 Questions and Answers
  • Updated: Oct 21, 2026

This exam has been stopped to register, new exam code replace: DA-100


Instant Download: Upon successful payment, Our systems will automatically send the product you have purchased to your mailbox by email. (If not received within 12 hours, please contact us. Note: don't forget to check your spam.)

Download Demo

Custom purchase

This exam has been stopped to register, new exam code replace: DA-100

Choosing Purchase: "Online Test Engine"
Price: $69.98 
  • Best exam practice material
  • Three formats are optional
  • 10 years of excellence
  • 365 Days Free Updates
  • Learn anywhere, anytime
  • 100% Safe shopping experience

100% Money Back Guarantee

PrepAwayETE has an unprecedented 99.6% first time pass rate among our customers. We're so confident of our products that we provide no hassle product exchange.

Good products listen. PrepAwayETE welcomes feedback from Microsoft Analyzing and Visualizing Data with Power BI candidates and folds it into regular content and usability updates — free for a full year after purchase.

Microsoft 70-778 Exam Overview:

Certification Vendor:Microsoft
Exam Name:Analyzing and Visualizing Data with Microsoft Power BI
Exam Number:70-778
Exam Price:USD 165
Passing Score:700 (on a scale of 1000)
Available Languages:English
Certificate Validity Period:Retired (Exam retired January 31, 2021; superseded by DA-100 / PL-300)
Exam Format:Multiple Choice, Short Answer, Drag and Drop
Related Certifications:MCSA: BI Reporting (requires 70-778 and other exams)
Real Exam Qty:40-60
Exam Duration:120 minutes
Sample Questions: DOWNLOAD DEMO
Exam Way:Delivered via Pearson VUE testing or online proctored; retired as of January 31, 2021, replaced by role-based exam (e.g., DA-100 / PL-300).
Pre Condition:Recommended experience with Power BI Desktop and Power BI Service, data analysis and visualization tasks.
Official Syllabus URL:https://learn.microsoft.com/

Microsoft 70-778 Exam Syllabus Topics:

SectionObjectives
Topic 1: Consume and Transform Data- Connect to Data Sources
  • 1. Using Power Query for transformation
  • 2. Cleansing and shaping data
  • 3. Connecting to databases and files
Topic 2: Configure Dashboards, Reports and Apps- Power BI Service Integration
  • 1. Publish and embed reports
  • 2. Security and access configuration
  • 3. Configure dashboards and apps
Topic 3: Model and Visualize Data- Data Modeling and DAX
  • 1. Create calculated tables/columns and measures
  • 2. Optimize data models
  • 3. Manage relationships and hierarchies
- Report and Visualization Design
  • 1. KPI and performance visualization
  • 2. Configure report layout and interaction
  • 3. Create and format interactive visuals

70-778 Exam FAQ: Informed Choices, Real Preparation

The official Microsoft Analyzing and Visualizing Data with Power BI outline defines 3 domains. The leading three are Configure Dashboards, Reports and Apps, Consume and Transform Data, and Model and Visualize Data. The full list is in the topics section above, and PrepAwayETE's 155 practice questions cover each one.

Recommended experience with Power BI Desktop and Power BI Service, data analysis and visualization tasks. Since requirements change over time, confirm the latest on the official Microsoft exam page before scheduling.

Delivered via Pearson VUE testing or online proctored; retired as of January 31, 2021, replaced by role-based exam (e.g., DA-100 / PL-300). Register for the Microsoft Analyzing and Visualizing Data with Power BI exam through these official channels:

    After booking, PrepAwayETE delivers your practice questions within 1 minute — preparation starts the same day.

    The 70-778 exam is a Microsoft certification exam validating the Microsoft Analyzing and Visualizing Data with Power BI syllabus shown above. It belongs to these credential paths: MCSA: BI Reporting (requires 70-778 and other exams). Candidates in 2026 start with PrepAwayETE's 155 practice questions, available as a printable PDF, a Windows Desktop Test Engine, and an Online Test Engine — three versions of the same materials.

    The Microsoft Analyzing and Visualizing Data with Power BI exam contains 40-60 to complete within 120 minutes. Timed simulation in the PrepAwayETE Desktop Test Engine teaches that rhythm before exam day does.

    PrepAwayETE issues a full refund if you take the Microsoft Analyzing and Visualizing Data with Power BI exam within 60 days of purchase and do not pass. The policy does not apply if the exam is taken within 3 days of purchase, if the exam was never actually taken, or to free materials or expired orders, and the candidate name must match the payer name. Submit a scan of your enrollment slip and the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Alternatively, exchange for two free exam products of equal value and keep your original update service. Orders arrive by email within 1 minute — contact support if nothing arrives within 2 hours.

    The Microsoft Analyzing and Visualizing Data with Power BI exam requires 700 (on a scale of 1000) to pass, and registration costs USD 165. A failed attempt means paying the same fee again — a readiness check with the PrepAwayETE engines before booking is the cheaper option.

    Microsoft recommends these training resources for the Microsoft Analyzing and Visualizing Data with Power BI exam:

      Follow the training with steady self-testing — the 155 practice questions from PrepAwayETE help you apply theory and fill any gaps the training leaves.

      Three versions of the same study materials: a printable, expert-prepared PDF with free demo download and instant access; a Desktop Test Engine for Windows with customizable simulation and timed modes that works offline; and an Online Test Engine for any browser on Windows, Mac, Android, and iOS with test history and performance review. All 155 practice questions are identical across versions. Every purchase includes 365 days of free updates, a 50% renewal discount afterward, and unlimited computer installations.

      Microsoft Analyzing and Visualizing Data with Power BI Sample Questions:

      You have an app workspace that contains a dashboard and four reports. All the reports are generated from a single dataset that contains sales data for your company.
      The reports display the data configured as shown in the following table.

      You need to ensure that the users of the reports can locate the correct report by using natural language queries.
      What should you do?

      • A. From the properties of the workspace, modify the Language Settings.
      • B. From the properties of the dataset, create four Featured Q&A Questions.
      • C. From the properties of the dataset, modify the Q&A and Cortana settings.
      • D. From the Format settings of the reports, modify the Page Information.
      Reveal Solution  Discussion  0

      Correct Answer: C  🗳️

      Explanation: Only visible for PrepAwayETE members. You can sign-up / login (it's free).

      Note: This question is a 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 for a table named Sales. Sales has a column named CustomerID. The Data type of CustomerID is Whole Number.
      You refresh the data and find several errors. You discover that new entries in the Sales table contain nonnumeric values.
      You need to ensure that nonnumeric values in the CustomerID column are set to 0.
      Solution: From Query Editor, select the CustomerID column and click Replace Errors.
      Does this meet the goal?

      • A. No
      • B. Yes
      Reveal Solution  Discussion  0

      Correct Answer: B  🗳️

      Explanation: Only visible for PrepAwayETE members. You can sign-up / login (it's free).

      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.
      You have a Microsoft SQL Server database that contains the following tables.

      The following columns contain date information:
      - Date[Month] in the mmyyyy format
      - Date[Date_ID] in the ddmmyyyy format
      - Date[Date_name] in the mm/dd/yyyy format
      - Monthly_returns[Month_ID] in the mmyyyy format
      The Order table contains more than one million rows.
      The Store table has a relationship to the Monthly_returns table on the Store_ID column. This is the only relationship between the tables.
      You plan to use Power BI Desktop to create an analytics solution for the data.
      You need to create a relationship between the Monthly_returns table and Date[Date_ID].
      What should you do before you create the relationship?

      • A. In the Monthly_returns table, create a new calculated column named DateJD that uses the ddmmyyyy format.
      • B. In the Date table, create a new calculated column named MonthJD that uses the yyyydd format.
      • C. To the Date table, add a calculated column that uses the RE LATE D(Monthly_ret urns [MonthJD]) DAX formula.
      • D. To the Order table, add a calculated column that uses the RELATED(Monthly_returns[Month_ID]) DAX formula.
      Reveal Solution  Discussion  0

      Correct Answer: A  🗳️

      Explanation: Only visible for PrepAwayETE members. You can sign-up / login (it's free).

      You have a Microsoft Excel spreadsheet that contains a table named Sales.
      You need to add the Sales table to a Power BI dashboard as a tile.
      How should you configure the tile?

      • A. From the Power BI service, upload the Excel workbook.
      • B. From the Power BI tab in Excel, pin the table.
      • C. From the Power BI service, import the data from the Excel workbook.
      • D. From Excel, publish the workbook to the Power BI service.
      Reveal Solution  Discussion  0

      Correct Answer: B  🗳️

      Explanation: Only visible for PrepAwayETE members. You can sign-up / login (it's free).

      You open powerbi.com as shown in the following exhibit.
      Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
      NOTE: Each correct selection is worth one point.

      Reveal Solution  Discussion  0

      Correct Answer:


      Explanation

      References: https://docs.microsoft.com/en-us/power-bi/service-data-classification

      Viewing page 1 out of 31 pages.
      Viewing questions 1-5 out of 155 questions.

      3%

      0 Customer ReviewsCustomers Feedback (* Some similar or old comments have been hidden.)

      LEAVE A REPLY

      Your email address will not be published. Required fields are marked *

      0
      0
      0
      0

      Contact Us

      If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

      Our Working Time: ( GMT 0:00-15:00 )
      From Monday to Saturday

      Support: Contact now