70-778 Royal Pack Testengine pdf
100% Actual & Verified — 100% PASS
Unlimited access to the world's largest Dumps library! Try it Free Today!https://www.exambible.com/70-778-exam/
Exam Number/Code: 70-778
Exam name: Analyzing and Visualizing Data with Microsoft Power BI (beta)
n questions with full explanations
Certification: Microsoft Certification
Last updated on Global synchronizing
Pass4sure 70-778 Questions are updated and all 70-778 answers are verified by experts. Once you have completely prepared with our 70-778 exam prep kits you will be ready for the real 70-778 exam without a problem. We have Most up-to-date Microsoft 70-778 dumps study guide. PASSED 70-778 First attempt! Here What I Did.
P.S. Download 70-778 vce are available on Google Drive, GET MORE: https://drive.google.com/open?id=1DsY4MrMrQbFhmpjP8lcA3sh-CLMy30N3
New Microsoft 70-778 Exam Dumps Collection (Question 2 - Question 11)
You have the following tables.
You need to create a measure to calculate a running total of TransactionQuantity.
How should you complete the DAX formula? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Q3. You have a Power BI model that contains the following tables:
u2711 Sales (Sales_ID, DateID, sales_amount)
u2711 Date (DateID, Date, Month, week, Year)
The tables have a relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the sales for the last 12 months.
Which DAX formula should you use?
A. CALCULATEx(SUM(sales[sales_amount]) DATESYTD (u2018Dateu2019 [Date]))
B. CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR (u2018Dateu2019 [Date]))
C. SUM(sales[sales_amount])-CALCULATE(SUM(sales[sales_amount]), SAMEPERIODLASTYEAR(u2018Dateu2019[Date]))
D. SUM(sales[sales_amount])- CALCULATE(SUM(sales[sales_amount]),DATESYTD(u2018Dateu2019[Date]))
https://msdn.microsoft.com/en-us/library/ee634825.aspx https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics https://msdn.microsoft.com/en-us/library/ee634972.aspx
Q4. You plan to use Power BI Embedded to deliver reports in a web application. You need to ensure that the reports display live data.
Which data source you should use?
A. Microsoft Azure Data Lake Store
B. Microsoft Azure Table Storage
C. Microsoft Azure HDInsight
D. Microsoft Azure SQL Database
References: https://docs.microsoft.com/en-us/power-bi/service-azure-sql-database-with- direct-connect
Q5. You have a Microsoft SharePoint Online site named Sales.
Your company has 1,000 sales users. All the sales users can access Sales.
You create a report in an app workspace in the Power BI service. You embed the report into a page on the Sales site by using the Power BI web part.
You need to ensure that all the sales can view the report from the Sales site. What should you do?
A. Configure the app workspace for Premium capacity.
B. Enable anonymous access for the Sales site.
C. Configure the Portal Site Connection for the Sales site.
D. Disable the Embed content in apps setting from the Tenant settings in Power BI.
Q6. 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 Valuesu2026 Does this meet the goal?
Q7. You have a table in Power BI Desktop as shown in the following exhibit.
You pivot the columns as shown in the following exhibit.
You need to resolve the error in row3. The solution must preserve all the data. What should you do?
A. Change the Data Type of the Value column.
B. Select the Score column, and then click Remove Errors.
C. Select the Key column, and then click Remove Duplicates
D. Change the Aggregate Value Function of the pivot.
Q8. You have a Microsoft Excel 2016 workbook that has a Power Pivot model. The model contains the following tables:
u2711 Product (Product_id, Producct_Name)
u2711 Sales (Order_id, Order_Date, Product_id, Selasperson_id, Sales_Amount)
u2711 Salesperson (Salesperson_id, Salesperson_name, address)
The model has the following relationships:
u2711 Sales to Product
u2711 Sales to Salesperson
You create a new Power BI file and import the Power Pivot model.
You need to ensure that you can generate a report that displays the count of products sold by each salesperson.
What should you do before you create the report?
A. Create a many-to-one relationship between Product and Salesperson.
B. For each relashionship, change the Cardinality to One to One (1:1).
C. Create a one-to-one relashionship between Product and Salesporson.
D. For each relationship, change the Cross filter direction to Both.
References: https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage- relationships
Q9. Note: This question is a part of a series of questions that present 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 exactly the same in each question in this series.
Start of repeated scenario
You have a Microsoft SQL Server database that contains the following tables.
The following columns contain data information:
u2711 Date[Month] in the mmyyyy format
u2711 Date[Date_ID] in the ddmmyyyy format
u2711 Date[Date_name] in the mm/dd/yyyy format
u2711 Monthly_returns[Month_ID] in the mmyyyy format
The Order table contains more than one million rows.
The Store table has 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. End of repeated scenario.
You are modifying the model to report on the number of order.
You need to calculate the number of orders. What should you do?
A. Create a calculated measure that uses the COUNTA(Order_ID) DAX formula.
B. Create a calculated measure that uses the SUM (Order_ID) DAX formula.
C. Create a calculated column that uses the SUM (Order_ID) DAX formula.
D. Create a calculated column that uses the COUNTA (Order_ID) DAX formula.
You have a query that retrieves data from a Microsoft Azure SQL database.
You discover that column named ErrorCode has several values starting with a space character, and a column named SubStatus contains several non-printable characters.
You need to remove all the leading whitespaces from ErrorCode and all the non-printable characters from SubStatus. All other data must be retained.
What should you do on each column? To answer, drag the appropriate tasks to the correct columns. Each task may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Q11. You have an app workspace named Retail Analysis in the Power BI service. You need manage the members that have access to the app workspace. What should you do?
A. From the Power BI Admin portal, click Usage metrics.
B. From the Office 365 Admin center, click Users.
C. From the Office 365 Admin center, click Groups.
D. From the Power BI Admin portal, click Tenant settings.
Recommend!! Get the Download 70-778 dumps in VCE and PDF From Examcollection, Welcome to download: http://www.examcollectionuk.com/70-778-vce-download.html (New 58 Q&As Version)