没有合适的资源?快使用搜索试试~ 我知道了~
PL-300微软MCP ET.pdf
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 22 浏览量
2024-04-29
10:46:03
上传
评论
收藏 43.23MB PDF 举报
温馨提示
试读
328页
必备的助力资源
资源推荐
资源详情
资源评论
Topic 1 - Question Set 1
Topic 1
Question #1
HOTSPOT -
You plan to create the Power BI model shown in the exhibit. (Click the Exhibit tab.)
The data has the following refresh requirements:
✑
Customer must be refreshed daily.
✑
Date must be refreshed once every three years.
✑
Sales must be refreshed in near real time.
✑
SalesAggregate must be refreshed once per week.
You need to select the storage modes for the tables. The solution must meet the following requirements:
✑
Minimize the load times of visuals.
✑
Ensure that the data is loaded to the model based on the refresh requirements.
Which storage mode should you select for each table? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Correct Answer:
Box 1: Dual -
Customer should use the dual storage mode.
Dual: Tables with this setting can act as either cached or not cached, depending on the context of the query that's submitted to the Power BI
dataset. In some cases, you fulll queries from cached data. In other cases, you fulll queries by executing an on-demand query to the data
source.
Note: You set the Storage mode property to one of these three values: Import, DirectQuery, and Dual.
Box 2: Dual -
You can set the dimension tables (Customer, Geography, and Date) to Dual to reduce the number of limited relationships in the dataset, and
improve performance.
Box 3: DirectQuery -
Sales should use the DirectQuery storage mode.
DirectQuery: Tables with this setting aren't cached. Queries that you submit to the Power BI dataset
ג
€"for example, DAX queries
ג
€"and that
return data from
DirectQuery tables can be fullled only by executing on-demand queries to the data source. Queries that you submit to the data source use the
query language for that data source, for example, SQL.
Box 4: Import -
Import: Imported tables with this setting are cached. Queries submitted to the Power BI dataset that return data from Import tables can be
fullled only from cached data.
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode
Topic 1
Question #2
You have a project management app that is fully hosted in Microsoft Teams. The app was developed by using Microsoft Power Apps.
You need to create a Power BI report that connects to the project management app.
Which connector should you select?
A. Microsoft Teams Personal Analytics
B. SQL Server database
C. Dataverse
D. Dataows
Correct Answer:
C
Data sources in Power BI Desktop.
The Power Platform category provides the following data connections:
Power BI datasets -
Power BI dataows -
Common Data Service (Legacy)
Dataverse -
Dataows -
Other data sources include Microsoft Teams Personal Analytics (Beta).
Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
Community vote distribution
C (100%)
Topic 1
Question #3
For the sales department at your company, you publish a Power BI report that imports data from a Microsoft Excel le located in a Microsoft
SharePoint folder.
The data model contains several measures.
You need to create a Power BI report from the existing data. The solution must minimize development effort.
Which type of data source should you use?
A. Power BI dataset
B. a SharePoint folder
C. Power BI dataows
D. an Excel workbook
Correct Answer:
B
Connect to a SharePoint folder from Power Query Desktop
To connect to a SharePoint folder:
1. From Get Data, select SharePoint folder.
2. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL text box in the SharePoint folder dialog box. In this
example, the site URL is https://contoso.sharepoint.com/marketing/data. If the site URL you enter is invalid, a warning icon. warning icon will
appear next to the URL text box.
Select OK to continue.
3. If this is the rst time you've visited this site address, select the appropriate authentication method. Enter your credentials and choose which
level to apply these settings to. Then select Connect.
4. When you select the SharePoint folder you want to use, the le information about all of the les in that SharePoint folder are displayed. In
addition, le information about any les in any subfolders is also displayed.
5. Etc.
Reference:
https://docs.microsoft.com/en-us/power-query/connectors/sharepointfolder
Community vote distribution
A (84%) B (16%)
剩余327页未读,继续阅读
资源评论
xueyunshengling
- 粉丝: 181
- 资源: 511
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功