没有合适的资源？快使用搜索试试~ 我知道了~

文库首页行业研究行业报告DP-300 Exam微软ET_202409.pdf

DP-300 Exam微软ET_202409.pdf

1.该资源内容由用户上传，如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款（资源遇到问题，请及时私信上传者）

版权申诉

0 下载量 124 浏览量 2024-09-10 16:07:35 上传评论收藏 36.03MB PDF 举报

温馨提示

试读

389页

微软MCP认证T库，帮助您尽快获得

资源推荐

资源详情

资源评论



- Expert Veried, Online,

Free



Custom View Settings

Topic 1 - Question Set 1

Topic 1

Question #1

You have 20 Azure SQL databases provisioned by using the vCore purchasing model.

You plan to create an Azure SQL Database elastic pool and add the 20 databases.

Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the

solution.

NOTE: Each correct selection is worth one point.

A. total size of all the databases

B. geo-replication support

C. number of concurrently peaking databases * peak CPU utilization per database

D. maximum number of concurrent sessions for all the databases

E. total number of databases * average CPU utilization per database

Correct Answer:

ACE

CE: Estimate the vCores needed for the pool as follows:

For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X

Peak vCore utilization per DB)

A: Estimate the storage space needed for the pool by adding the number of bytes needed for all the databases in the pool.

Reference:

https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

Community vote distribution

ACE (100%)



Topic 1

Question #2

DRAG DROP -

You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.

A recent failure causes the master database to be lost.

You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine.

Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the

answer area and arrange them in the correct.

Select and Place:

Correct Answer:

Step 1: Attach the SSISDB database

Step 2: Turn on the TRUSTWORTHY property and the CLR property

If you are restoring the SSISDB database to an SQL Server instance where the SSISDB catalog was never created, enable common language

runtime (clr)

Step 3: Open the master key for the SSISDB database

Restore the master key by this method if you have the original password that was used to create SSISDB. open master key decryption by

password = 'LS1Setup!' --'Password used when creating SSISDB'

Alter Master Key Add encryption by Service Master Key

Step 4: Encrypt a copy of the master key by using the service master key

Reference:

https://docs.microsoft.com/en-us/sql/integration-services/catalog/ssis-catalog



Topic 1

Question #3

You have an Azure SQL database that contains a table named factSales. FactSales contains the columns shown in the following table.

FactSales has 6 billion rows and is loaded nightly by using a batch process. You must provide the greatest reduction in space for the database

and maximize performance.

Which type of compression provides the greatest space reduction for the database?

A. page compression

B. row compression

C. columnstore compression

D. columnstore archival compression

Correct Answer:

Columnstore tables and indexes are always stored with columnstore compression. You can further reduce the size of columnstore data by

conguring an additional compression called archival compression.

Note: Columnstore

€" The columnstore index is also logically organized as a table with rows and columns, but the data is physically stored in a

column-wise data format.

Incorrect Answers:

B: Rowstore

€" The rowstore index is the traditional style that has been around since the initial release of SQL Server.

For rowstore tables and indexes, use the data compression feature to help reduce the size of the database.

C: Columnstore compression is less compressed compared to columnstore archival compression.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/data-compression/data-compression

Community vote distribution

D (71%) C (29%)



Topic 1

Question #4

You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.

✑

Clustered columnstore indexes

✑

Automatic tuning

✑

Change tracking

✑

PolyBase

You plan to migrate DB1 to an Azure SQL database.

What feature should be removed or replaced before DB1 can be migrated?

A. Clustered columnstore indexes

B. PolyBase

C. Change tracking

D. Automatic tuning

Correct Answer:

This table lists the key features for PolyBase and the products in which they're available.

Incorrect Answers:

C: Change tracking is a lightweight solution that provides an ecient change tracking mechanism for applications. It applies to both Azure SQL

Database and SQL

Server.

D: Azure SQL Database and Azure SQL Managed Instance automatic tuning provides peak performance and stable workloads through

continuous performance tuning based on AI and machine learning.

Reference:

https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary

Community vote distribution

B (100%)



Topic 1

Question #5

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.

You plan to migrate DB1 to an Azure SQL Database managed instance.

What should you use to minimize downtime and data loss during the migration?

A. distributed availability groups

B. database mirroring

C. Always On Availability Group

D. Azure Database Migration Service

Correct Answer:

Azure Database Migration Service can do online migrations with minimal downtime.

Reference:

https://docs.microsoft.com/en-us/azure/dms/dms-overview

Community vote distribution

D (100%)

剩余388页未读，继续阅读

评论收藏

内容反馈

1.该资源内容由用户上传，如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款（资源遇到问题，请及时私信上传者）

版权申诉

资源评论

资源反馈

评论星级较低，若资源使用遇到问题可联系上传者，3个工作日内问题未解决可申请退款~

xueyunshengling

粉丝: 578
资源: 3169

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

前往需求广场，查看用户热搜

DP-300 Exam微软ET_202409.pdf

DP-100 Exam微软ET_202409.pdf

DP-300 Exam微软ET_2024-09.pdf

DP-100 Exam微软ET_2024-09.pdf

DP-203 Exam Exam微软ET_202409.pdf

DP-600 Exam微软ET_2024-09.pdf

DP-100 Exam微软ET_2024-9.pdf

DP-203 Exam微软ET_2024-09.pdf

DP-420 Exam微软ET_2024-09.pdf

DP-600微软MCP_ET.pdf

DP-600微软MCP ET.pdf

DP-300.197 2022年11.pdf

微软_DP-900_156Q.pdf

,PS176HDMQFN48GTR2-B0 DP-to-HDMI Dongle Reference Design_20150702.pdf

DP-300plus_QIG_300.pdf DP-300 设置说明 书 驱动

DP-24SD_26_1.109

西门子S7-300PLC应用教程-DP_ET200例程.zip西门子PLC编程实例程序源码下载

PyPI 官网下载 | dearpygui-0.6.281-cp36-cp36m-manylinux1_x86_64.whl

PyPI 官网下载 | dearpygui-1.2.2-cp39-cp39-manylinux1_x86_64.whl

Firefly-RK3399的Android10中的pdf_20211123_1657.7z

DP_MassStorage_wnt5_x86-32_1209.rar

DP-DP-Koppler_Rel3_www.44dpdp.com_www.44dpdp.con_EC1-DEB-DPM_GSD

蓝牙文档大全1

jdk-11.0.11_windows-x64_bin.exe

flash-player-npapi-32.0.0.414-release.x86_64.rpm

VMware-VMvisor-Installer-6.5.0.update01-custom.x86_64.zip

VMware-VMvisor-Installer-6.5.0.update01-custom.x86_64.txt

DP-301U_UTILITY_PSADMIN_1.00

openvswitch-2.12.0-1.x86_64.rpm

最新资源

DP-300plus_QIG_300.pdf DP-300 设置说明书驱动