Free Download the Most Update Geekcert Microsoft 70-778 Brain Dumps

There is no need to worry about the difficulties on the MCSA Hotest 70-778 vce dumps exam preparation. Geekcert will assist you pass your MCSA Newest 70-778 vce exam with up to date Jan 14,2022 Newest 70-778 exam questions Analyzing and Visualizing Data with Microsoft Power BI PDF and VCE dumps. Geekcert provides the most update real MCSA Latest 70-778 study guide exam preparation material, covering each and every aspect which real MCSA Hotest 70-778 free download exam requires. We ensure you 100% success in MCSA Newest 70-778 free download exam.

Geekcert – help you to pass all 70-778 certification exams! you are only successful with 70-778 testing engine in your it certification – Geekcert! latest 70-778 exam dumps. get your certification easily- Geekcert. Geekcert | 70-778 certification materials | videos | study guides. 70-778 exam academy – free online 70-778 exam study guide resource for 70-778 associate specialty exams.

We Geekcert has our own expert team. They selected and published the latest 70-778 preparation materials from Microsoft Official Exam-Center: https://www.geekcert.com/70-778.html

The following are the 70-778 free dumps. Go through and check the validity and accuracy of our 70-778 dumps.Real questions from 70-778 free dumps. Download demo of 70-778 dumps to check the validity.

Question 1:

You attempt to publish a Microsoft Excel file to Power BI, and you receive the error message shown in the exhibit. (Click the Exhibit button.)

The file is in c:\data\.

You need to ensure that you can publish the file to Power BI.

What should you do first?

A. Save the file in a Microsoft SharePoint document library.

B. Decrypt the workbook.

C. Add a digital signature to the workbook.

D. Set the file attributes to read-only.

Correct Answer: B

Question 2:

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 has the tables shown in the Database Diagram exhibit. (Click the Exhibit.)

You plan to develop a Power BI model as shown in the Power BI Model exhibit. (Click the Exhibit).

You plan to use Power BI to import data from 2013 to 2015.

Product Subcategory [Subcategory] contains NULL values.

End of repeated scenario.

You implement the Power BI model.

You need to add a new column to the Product Subcategory table that uses the following formula.

=if [Subcategory] =null then “NA” else [Subcategory]

Which command should you use in Query Editor?

A. Column From Examples

B. Custom Column

C. Invoke Custom Function

D. Conditional Column

Correct Answer: D

References: http://community.powerbi.com/t5/Desktop/if-then-else/td-p/117999

Question 3:

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 user named User!. User1 is a member of a security group named Contoso PowerB1.

User1 has access to a workspace named Contoso Workspace.

You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.

Solution: From the Power B1 Admin portal, you modify the Tenant settings.

A. Yes

B. No

Correct Answer: B

Question 4:

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 user named User1. User1 is a member of a security group named Contoso PowerBI.

User1 has access to a workspace named Contoso Workspace.

You need to prevent User1 from exporting data from the visualizations in Contoso Workspace.

Solution: From the Microsoft Office 365 Admin center, you remove User1 from the All Users security group.

Does this meet the goal?

A. Yes

B. No

Correct Answer: B

Question 5:

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:

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 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.

Correct Answer: B

References: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

Question 6:

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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains two columns named Date and Time.

The tables have the following relationships:

Sales [DueDate] and Date [Date]

Sales [ShipDate] and Date [Date]

Sales [OrderDate] and Date [Date]

The active relationship is on Sales [DueDate].

You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.

Solution: You create two copies of the Date table named ShipDate and OrderDateGet. You create a measure that uses the new tables.

Does this meet the goal?

A. Yes

B. No

Correct Answer: B

Question 7:

You are creating a report in Power BI Desktop. You are consuming the following tables.

Date[Date] is in the mm/dd/yyyy format. Date[DateKey] is in the ddmmyyyy format. Date[MonthNumber] is in the mm format. Date[MonthName] is in the mmm format. You create the report shown in the exhibit. (Click the Exhibit button.)

You need to ensure that the months appear in the order of the calendar. How should you sort the MonthName column?

A. by MonthNumber

B. ascending

C. descending

D. by DateKey

Correct Answer: A

References: http://ppmworks.com/sorting-month-names-chronologically-in-microsoft- power-bi-reports/

Question 8:

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

Correct Answer: B

Question 9:

You have a power BI model that contains the following tables:

Assets( AssetsID, AssetName, Purchase_DateID, Value) Date( DateID, Date, Month, Week, Year)

The tables have relationship. Date is marked as a date table in the Power BI model. You need to create a measure to calculate the percentage that the total assets value increased since one year ago.

Which DAX formula should you use?

A. (sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR(`Date\'[Date])))/CALCULATE (sum(Assets[Value]),SAMEPERIODLASTYEAR (`Date\’ [Date]))

B. CALCULATEx(sum(Assets[Value]) DATESYTD (`Date\'[Date]))/sum(Assets[Value])

C. sum(Assets[Value])-CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (`Date\’ [Date]))

D. CALCULATE(sum(Assets[Value]),SAMEPERIODLASTYEAR (`Date\’ [Date]))/sum(Assets[Value])

Correct Answer: C

References: 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

Question 10:

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. DATE ADD

B. LASTDATE

C. ENDOFVEAR

D. PREVIOUSYEAR

Correct Answer: D

Question 11:

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 Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains two columns named Date and Time.

The tables have the following relationships:

Sales [DueDate] and Date [Date]

Sales [ShipDate] and Date [Date]

Sales [OrderDate] and Date [Date]

The active relationship is on Sales [DueDate].

You need to create measures to count the number of orders by [ShipDate] and orders by [OrderDate]. You must meet the goal without loading any additional data.

Solution: You create measures that use the CALCULATE, COUNT, and FILTER DAX functions.

Does this meet the goal?

A. Yes

B. No

Correct Answer: A

References: https://msdn.microsoft.com/en-us/library/ee634966.aspx https://msdn.microsoft.com/en-us/library/ee634825.aspx https://msdn.microsoft.com/en-us/library/ee634791.aspx

Question 12:

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.

Start of repeated scenario

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 StoreJD column. This is the only relationship between the tables.

You plan to use Power Bl Desktop to create an analytics solution for the data.

End of repeated scenario.

You are modeling the data in Power Bl.

You need to import only a sample of the data from the Order table.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. In the Power Bl model, create a calculated table.

B. From Query Editor, create a custom column that uses a custom column formula.

C. From Query Editor, add a select statement that uses a where clause to the source definition.

D. From Query Editor, create a column by using Column From Examples.

E. From Query Editor, filter the table by Order_date.

Correct Answer: CE

Question 13:

You have a query that retrieves sales data. A sample of the data is shown in the following table.

You need to ensure that the values in the Date column contain a date. Null values must be replaced with the date from the previous row. What should you click on the Transform tab in Query Editor?

A. Format, and then Clean

B. Date, and then Earliest

C. Fill, and then Down

D. Replace Values, and then Replace Errors

Correct Answer: C

References: https://www.excelcampus.com/library/fill-down-blank-null-cells-power-query/

Question 14:

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.

Correct Answer: A

References: https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo

Question 15:

You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular named SalesDB in Microsoft SQL Server Analysis Services (SSAS). The report will be published to the Power BI service.

You need to ensure that the report published to the Power BI service will access the current data in SalesDB.

What should you do?

A. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Import Data Connectivity mode.

B. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Connect live option.

C. Deploy an on-premises data gateway (personal mode) and configure to SalesDB to use the DirectQuery Data Connectivity mode.

D. Deploy an on-premises data gateway and configure the connection to SalesDB to use the DirectQuery Data Connectivity mode.

Correct Answer: D

References: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

Actual Certifications Exam Q&A – Best Exam Dumps for Sale

Free Download the Most Update Geekcert Microsoft 70-778 Brain Dumps

Leave a Reply Cancel reply