DA-100 Exam Question 51
You have the tables shown in the following table.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
- Present ad impression counts for the day, campaign, and Site_name.
The analytics for the last year are required.
- Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
- Present ad impression counts for the day, campaign, and Site_name.
The analytics for the last year are required.
- Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
DA-100 Exam Question 52
You have the tables shown in the following table.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
The Impressions table contains approximately 30 million records per month.
You need to create an ad analytics system to meet the following requirements:
Present ad impression counts for the day, campaign, and Site_name. The analytics for the last year are required.
Minimize the data model size.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
DA-100 Exam Question 53
You import two Microsoft Excel tables named Customer and Address into Power Query. Customer contains the following columns:
* Customer ID
* Customer Name
* Phone
* Email Address
* Address ID
Address contains the following columns:
* Address ID
* Address Line 1
* Address Line 2
* City
* State/Region
* Country
* Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?
* Customer ID
* Customer Name
* Phone
* Email Address
* Address ID
Address contains the following columns:
* Address ID
* Address Line 1
* Address Line 2
* City
* State/Region
* Country
* Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?
DA-100 Exam Question 54
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?
The file is in c:\data\.
You need to ensure that you can publish the file to Power BI.
What should you do first?
DA-100 Exam Question 55
You have a collection of reports for the HR department of your company. The datasets use row-level security (RLS). The company has multiple sales regions that each has an HR manager. You need to ensure that the HR managers can interact with the data from their region only. The HR managers must be prevented from changing the layout of the reports. How should you provision access to the reports for the HR managers?