2018/November Braindump2go 70-778 Exam Dumps with PDF and VCE New Updated Today! Following are some new 70-778 Real Exam Questions:
1.|2018 Latest 70-778 Exam Dumps (PDF & VCE) 152Q&As Download:
https://www.braindump2go.com/70-778.html
2.|2018 Latest 70-778 Exam Questions & Answers Download:
https://drive.google.com/drive/folders/16paLNO0K007UUoxJ5EJClSbsQGAtO3Xy?usp=sharing
QUESTION 121
Note: This question is 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. Click Replace Errors… and enter a value of.
Does this meet the goal?
A. Yes
B. No
Answer: A
QUESTION 122
Note: This question is 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, open Advanced Editor and add the following query step.
Does this meet the goal?
A. Yes
B. No
Answer: B
QUESTION 123
Note: This question is 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 Remove Errors.
Does this meet the goal?
A. Yes
B. No
Answer: B
QUESTION 124
You have a Power BI model for sales data. You create a measure to calculate the year-to-date sales.
You need to compare the year-to-date sales with the previous year for the same time period.
Which DAX function should you use?
A. LASTDATE
B. TOTALYTD
C. SAMEPERIODLASTYEAR
D. PREVIOUSYEAR
Answer: C
QUESTION 125
From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data.
You add Region and Sales to visualization and the visualization displays the following data.
What causes the visualization to display four rows of data instead of six?
A. the Data Category of Region
B. the Default Summarization on Region
C. the Default Summarization on Sales
D. the Data Category of Sales
Answer: B
QUESTION 126
You have a table named Sales. A sample of the data in Sales is shown in the following table.
You create a stacked column chart visualization that displays ProductName by Date.
You discover that the axis for the visualization displays all the individual dates. You need to ensure that the visualization displays ProductName by year and that you can drill down to see ProductName by week and day.
What should you do first?
A. Create a new table that has columns for the date, year, week, and day.
B. Create a new hierarchy in the Sales table.
C. Format the visualization and set the type of the X-Axis to Categorical.
D. Configure a visual filter for the Date column that uses an advanced filter.
Answer: A
QUESTION 127
You need to create a custom visualization for Power BI.
What should you install first?
A. jQuery
B. Node.js
C. Microsoft Azure PowerShell
D. Microsoft.NET
Answer: B
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-custom-visuals-getting-started-with-developer-tools
QUESTION 128
You have a Power BI report that is configured to use row-level security (RLS).
You have the following roles:
– A manager role that limits managers to see only the sales data from the stores they manage
– A region role that limits users to see only the data from their respective region
You plan to use Power BI Embedded to embed the report into an application. The application will authenticate the users.
You need to ensure that RLS is enforced when accessing the embedded report.
What should you do?
A. From dev.powerbi.com/apps, register the new application and enable the Read All Reports API access.
B. In the access token for the application, include the user name and the role name.
C. From dev.powerbi.com/apps, register the new application and enable the Read All Groups API access.
D. In the access token for the application, include the report URL and the Microsoft Azure Active Directory domain name.
Answer: B
QUESTION 129
You are creating a report in Power BI Desktop that has two visualizations on a page as shown in the following exhibit.
You need to ensure that when you click the bar of a country, only the values for that country are shown on the Revenue by Year and Manufacturer chart.
A. Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Filter.
B. Click the Revenue by Year and Manufacturer chart. On the Format tab, click Edit Interactions. On the Units by Country chart, click Highlight.
C. Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Filter.
D. Click the Units by Country chart. On the Format tab, click Edit Interactions. On the Revenue by Year and Manufacturer chart, click Highlight.
Answer: C
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
QUESTION 130
Your company has a security policy stating that proprietary data must not be transferred over the Internet.
During a security audit, auditors discover that executives use the Power BI service for reporting.
You need to recommend a solution to ensure that the company adheres to the security policy.
What should you include in the recommendation?
A. Microsoft SQL Server column encryption
B. Microsoft Azure ExpressRoute
C. a site-to-site VPN to Microsoft Azure
D. the on-premises gateway for Power BI
Answer: B
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-admin-power-bi-expressroute
QUESTION 131
You have a Power BI Desktop project that uses DirectQuery to access an on-premises Microsoft SQL Server database.
From Power BI Desktop, you can query the database.
When you publish the Power BI Desktop project to the Power BI service, the visualizations cannot display the data.
What should you do to resolve the issue?
A. Locate the published dataset for the project in the Power BI service and configure the data source credentials.
B. Install the on-premises data gateway (personal mode) and republish the project.
C. Install the on-premises data gateway and configure a data source.
D. Configure a Microsoft Azure ExpressRoute connection between the on-premises network and the Power BI service.
Answer: C
Explanation:
https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial
!!!RECOMMEND!!!
1.|2018 Latest 70-778 Exam Dumps (PDF & VCE) 152Q&As Download:
https://www.braindump2go.com/70-778.html
2.|2018 Latest 70-778 Study Guide Video: