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 132
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 chart that displays a sum of Order[Order_amount] by month for the Order_ship_date column and the Order_date column.
How should you model the data?
A. Create a one-to-many relationship from Date[Date_ID] to Order[Order_date] and another relationship from Date[Date_ID] to Monthly_returns[Date_ID].
B. Add a second Date table named Ship_date to the model. Create a many-to-many relationship from Date[Date_ID] to Order[Order_date] and many-to-many relationship from Ship_date[Date_ID] to Order [Order_ship_date].
C. Add a second Date table named Ship_date to the model. Create a one-to-many relationship from Date [Date_ID] to Order[Order_date] and a one-to-many relationship from Ship_Date[Date_ID] to Order [Order_ship_date].
D. Create a one-to-many relationship from Date[Date_ID] to Order[Order_date] and another relationship from Date[Date_ID] to Order[Order_ship_date].
Answer: C
QUESTION 133
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 are modeling the data in Power BI.
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. From Query Editor, create a custom column that uses a custom column formula.
B. From Query Editor, add a SELECT statement that uses a WHERE clause to the source definition.
C. In the Power BI model, create a calculated table.
D. From Query Editor, filter the table by Order_date.
E. From Query Editor, create a column by using Column From Examples.
Answer: BD
QUESTION 134
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 are modifying the model to report on the number of orders.
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 column that uses the COUNTA(Order_ID) DAX formula.
C. Create a calculated column that uses the SUM(Order_ID) DAX formula.
D. Create a calculated measure that uses the SUM(Order_ID) DAX formula.
Answer: A
QUESTION 135
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 plan to create a chart that displays total Order[Order_amount] by Store[Name].
You need to modify the model to ensure that you can create the chart.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Create a relationship between the Order table and the Store table.
B. To the Order table, add a measure that uses the COUNTA(‘Order'[Order_ID]) DAX formula.
C. To the Order table, add a column that uses the RELATED(‘Store'[Store_ID]) DAX formula.
D. To the Order table, add a measure that uses the COUNT(‘Order'[Order_amount]) DAX formula.
Answer: AC
QUESTION 136
You plan to create a dashboard in the Power BI service that retrieves data from a Microsoft SQL Server database. The dashboard will be shared between the users in your organization.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
A. Deploy an on-premises data gateway. Connect to the data by using the Import Data Connectivity mode.
B. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode.
C. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Import Data Connectivity mode.
D. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.
Answer: B
QUESTION 137
You plan to use Power BI Desktop optimized for Power BI Report Server to create a report. The report will be published to Power BI Report Server.
You need to ensure that all the visualization in the report can be consumed by users.
Which three types of visualizations should you include in the report? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. bubble maps
B. custom visuals
C. R visuals
D. breadcrumbs
E. funnel charts
Answer: ABE
Explanation:
https://docs.microsoft.com/en-us/power-bi/report-server/install-powerbi-desktop
QUESTION 138
You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization.
The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data.
You need to ensure that the users will see the current data when they view the dashboard.
How should you configure the connection to the data source?
A. Deploy an on-premises data gateway. Connect to the data by using the Connect live option.
B. Deploy an on-premises data gateway. Connect to the data by using the DirectQuery Data Connectivity mode.
C. Deploy an on-premises data gateway (personal mode). Connect to the data by using the Connect live option.
D. Deploy an on-premises data gateway (personal mode). Connect to the data by using the DirectQuery Data Connectivity mode.
Answer: A
QUESTION 139
You plan to use Power BI Desktop to create a report. The report will consume data from an on-premises tabular database 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 Connect live option.
B. Deploy an on-premises data gateway and configure the connection to SalesDB to use the Import Data Connectivity mode.
C. Deploy an on-premises data gateway (personal mode) and configure the connection 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.
Answer: A
QUESTION 140
You plan to join a fact table named ActivityLog to a Date dimension named ActivityDate. The date value in ActivityLog is a datetime column named ActivityStart. The date value in ActivityDate is a number column named DateID. DateID is in the YYYYMMDD format.
What should you do in the model before you create the relationship?
A. Change the Data Type of ActivityStart to Date.
B. Create a measure in ActivityLog that uses the FORMAT DAX function.
C. Change the Data Type of DateID to Date.
D. Create a calculated column in ActivityLog that uses the FORMAT DAX function.
Answer: D
!!!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: