迁移SERVER1数据库至Azure：解决方案与购买模式

版权申诉

AZURE

Database

5星 · 超过95%的资源 93 浏览量更新于2024-07-20 1 收藏 364KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

"DP-300-laolee.pdf 是一份关于在Microsoft Azure上管理关系数据库的最新题库，内容涵盖了数据库迁移、购买模式选择、数据保留策略以及数据分析存储方案等多个方面，旨在帮助用户掌握在Azure环境中管理和优化数据库的关键技能。" 在Azure数据库管理中，以下是一些重要的知识点： 1. 数据库迁移：在迁移SERVER1的数据库时，必须确保新解决方案符合业务需求。这可能涉及到评估现有架构、性能需求、可用性和成本效益。Azure提供了多种迁移工具和服务，如Database Migration Service (DMS) 和 Azure SQL Managed Instance，以平滑地将本地数据库迁移到云端。 2. 购买模式和部署选项：对于新的30个数据库，推荐采用基于DTU的购买模型和弹性池部署选项。DTU（Database Throughput Unit）是Azure SQL Database的一种计量单位，代表了数据库的处理能力。弹性池允许在一个池中管理多个数据库，提供资源共享和成本优化，适合具有相似工作负载需求的数据库。 3. 数据保留策略：设计Twitter数据记录的数据保留方案时，应考虑使用Azure Storage的功能，如生命周期管理。生命周期管理允许自动地将冷数据移动到更低成本的存储层，从而满足长期存储和分析客户情绪的需求。 4. 代理键实施：在零售商店表中实现代理键以满足销售事务数据集要求，可以创建一个具有IDENTITY属性的表。IDENTITY属性自动为表中的新行生成唯一的整数，这对于主键或唯一标识符非常有用，尤其是在支持大数据插入和更新的事务系统中。 5. 分析存储解决方案：设计用于事务数据的分析存储方案时，可能需要考虑使用列式存储、Azure Synapse Analytics或Data Lake Storage等服务，这些服务优化了大数据分析和查询性能。列式存储尤其适用于数据仓库和分析工作负载，因为它可以高效地处理大量数据的聚合查询。 6. 性能监控和调整：在Azure环境中，使用Azure Monitor和SQL Database Advisor可以持续监控数据库性能，提供优化建议，如调整DTU配额、添加索引或优化查询。 7. 安全与合规性：确保使用Azure Active Directory进行身份验证和授权，启用透明数据加密（TDE）保护数据安全，并遵循Azure的合规性标准，如ISO、HIPAA和PCI-DSS等。 8. 高可用性和灾难恢复：考虑设置读取副本、自动备份和故障转移群集实例以实现高可用性和灾难恢复，保证服务连续性和数据完整性。通过深入理解这些知识点，并结合DP-300的题库进行实践，用户能够有效地在Azure平台上规划、实施和管理关系数据库解决方案，满足业务和技术要求。

资源详情

资源推荐

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The

table contains a column name Email.

You need to prevent nonadministrative users from seeing the full email addresses in the

Email column. The users must see values in a format of aXXX@XXXX.com instead.

A. From the Azure portal, set a mask on the Email column.

B. From the Azure portal, set a sensitivity classification of

Confidential for the Email column.

从Azure门户，为电子邮件列设置机密的敏感度分类。

C. From Microsoft SQL Server Management Studio, set an email

mask on the Email column.

D. From Microsoft SQL Server Management Studio, grant the

SELECT permission to the users for all the

columns in the dbo.Customers table except Email.

You have an Azure Databricks workspace named workspace1 in the Standard pricing tier.

Workspace1 contains an all-purpose cluster named cluster1.

You need to reduce the time it takes for cluster1 to start and scale up. The solution must

minimize costs.

What should you do first?

A. Upgrade workspace1 to the Premium pricing tier.

B. Configure a global init script for workspace1.

C. Create a pool in workspace1.

D. Create a cluster policy in workspace1.

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named

Table1.

You have files that are ingested and loaded into an Azure Data Lake Storage Gen2

container named container1.

You plan to insert data from the files into Table1 and transform the data. Each row of data

in the files will produce one row in the serving layer of Table1.

You need to ensure that when the source data files are loaded to container1, the DateTime

is stored as an additional column in Table1.

Solution: In an Azure Synapse Analytics pipeline, you use a Get Metadata activity that

retrieves the DateTime of the files.

Does this meet the goal?

A. Yes

B. No

Instead use a serverless SQL pool to create an external table with

the extra column.

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named

Table1.

You have files that are ingested and loaded into an Azure Data Lake Storage Gen2

container named container1.

You plan to insert data from the files into Table1 and transform the data. Each row of data

in the files will produce one row in the serving layer of Table1.

You need to ensure that when the source data files are loaded to container1, the DateTime

is stored as an additional column in Table1.

Solution: You use an Azure Synapse Analytics serverless SQL pool to create an external

table that has an additional DateTime column.

Does this meet the goal?

A. Yes

B. No

Explanation:

In dedicated SQL pools you can only use Parquet native external

tables. Native external tables are

generally available in serverless SQL pools.

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named

Table1.

You have files that are ingested and loaded into an Azure Data Lake Storage Gen2

container named container1.

You plan to insert data from the files into Table1 and transform the data. Each row of data

in the files will produce one row in the serving layer of Table1.

You need to ensure that when the source data files are loaded to container1, the DateTime

is stored as an additional column in Table1.

Solution: You use a dedicated SQL pool to create an external table that has an additional

DateTime column.

Does this meet the goal?

A. Yes

B. No

Explanation:

Instead use a serverless SQL pool to create an external table with

the extra column.

Note: In dedicated SQL pools you can only use Parquet native

external tables. Native external tables are generally available in

serverless SQL pools.

Scenario: Authenticate database users by using Active Directory credentials.

The configuration steps include the following procedures to configure and use Azure Active

Directory authentication.

1. Create and populate Azure AD.

2. Optional: Associate or change the active directory that is

currently associated with your Azure Subscription.

3. Create an Azure Active Directory administrator. (Step 1)

4. Configure your client computers.

5. Create contained database users in your database mapped to

Azure AD identities. (Step 2)

6. Connect to your database by using Azure AD identities. (Step 3)

Scenario: Authenticate database users by using Active Directory

credentials.

The configuration steps include the following procedures to

configure and use Azure Active Directory

authentication.

1. Create and populate Azure AD.

2. Optional: Associate or change the active directory that is

currently associated with your Azure

Subscription.

3. Create an Azure Active Directory administrator. (Step 1)

4. Configure your client computers.

5. Create contained database users in your database mapped to

Azure AD identities. (Step 2)

6. Connect to your database by using Azure AD identities. (Step 3)

Box 1: Yes

DBAGroup1 is member of the Contributor role.

The Contributor role grants full access to manage all resources, but

does not allow you to assign roles in azure RBAC, manage

assignments in Azure Blueprints, or share image galleries.

Box 2: No

Box 3: Yes

DBAGroup2 is member of the SQL DB Contributor role.

The SQL DB Contributor role lets you manage SQL databases, but

not access to them. Also, you can't

manage their security-related policies or their parent SQL servers.

As a member of this role you can create and manage SQL

databases.

You have a new Azure SQL database. The database contains a column that stores

confidential information.

您有一个新的Azure SQL数据库。数据库包含存储机密信息的列。

You need to track each time values from the column are returned in a query. The tracking

information must be stored for 365 days from the date the query was executed.

您需要跟踪查询中每次返回列中的值。跟踪信息必须从执行查询之日起存储365天。

Which three actions should you perform? Each correct answer presents part of the solution.

你应该做哪三个动作？每一个正确的答案都是解决问题的一部分。

NOTE: Each correct selection is worth one point.

注意：每个正确的选择值一分。

A. Turn on auditing and write audit logs to an Azure Storage

account.

A.打开审核并将审核日志写入Azure存储帐户。

B. Add extended properties to the column.

B.向列添加扩展属性。

C. Turn on Advanced Data Security for the Azure SQL server.

C.为Azure SQL server启用高级数据安全性。

D. Apply sensitivity labels named Highly Confidential to the column.

D.对列应用名为“高度机密”的敏感标签。

E. Turn on Azure Advanced Threat Protection (ATP).

E。打开Azure高级威胁防护（ATP）。

You have an Azure virtual machine named VM1 on a virtual network named VNet1.

Outbound traffic from VM1 to the internet is blocked.

在名为VNet1的虚拟网络上有一个名为VM1的Azure虚拟机。从VM1到internet的出站流量被

阻止。

You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.

在名为SqlSrv1的逻辑服务器上有一个名为SqlDb1的Azure SQL数据库。

You need to implement connectivity between VM1 and SqlDb1 to meet the following

requirements:

您需要在VM1和SqlDb1之间实现连接，以满足以下要求：

Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.

确保到SqlSrv1的公共端点的所有通信都被阻止。

Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.

尽量减少VM1过滤存储在SqlDb1中的数据的可能性。

What should you create on VNet1?

您应该在VNet1上创建什么？

A. a VPN gateway

B. a service endpoint

C. a private link

D. an ExpressRoute gateway

Azure Private Link enables you to access Azure PaaS Services (for

example, Azure Storage and SQL

Database) and Azure hosted customer-owned/partner services over

a private endpoint in your virtual

network.

Traffic between your virtual network and the service travels the

Microsoft backbone network. Exposing your

service to the public internet is no longer necessary.

剩余45页未读，继续阅读

sbiaqgpyu

粉丝: 2
资源: 12

迁移SERVER1数据库至Azure：解决方案与购买模式

DP-300

DP-300认证T.docx

Azure-Certification-DP-200：Azure数据工程师之路第一部分：DP-200-实施Azure数据解决方案

Azure-DP-300-Study-Guide_clone

dp题库一（带答案）

nginx-1.24.0.tar

智能化病虫害标注系统前端.zip

Python 小游戏 （贪吃蛇、五子棋、扫雷、俄罗斯方块）

MATLAB/simulink 电力系统之变压器仿真-变压器空载运行仿真，磁通饱和+励磁电流

超级好的电赛习题分享.zip

8051Proteus仿真c源码串口通讯计算器

算法部署-基于ONNX+MNN+Cpp部署语音识别模型-附项目源码-优质项目实战.zip

全球与中国聚烯烃弹性体 （POE）市场现状及未来发展趋势（2024版）.docx

k8s1.31-images.tar

8051Proteus仿真c源码直流电机的速度环PI控制-速度电流检测部分

Halcon深度学习Ocr

IIS反向代理的安装包

软件测试面试题软件测试面试题

8051Proteus仿真c源码无线遥控实现

type-c耳机执行同行者进程被杀日志

最新资源

Python 小游戏（贪吃蛇、五子棋、扫雷、俄罗斯方块）

全球与中国聚烯烃弹性体（POE）市场现状及未来发展趋势（2024版）.docx