没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
ID 大意 答案
1
You are planning the migration of the SERVER1 databases. The solution must meet the
business
您正在计划SERVER1数据库的迁移。解决方案必须满足业务需求
requirements.
要求。
Standard 4-vCore
A VPN gateway
2
You need to recommend the appropriate purchasing model and deployment option for the
30 new databases. The solution must meet the technical requirements and the business
requirements.
您需要为30个新产品推荐合适的购买模式和部署选项数据库。解决方案必须满足技术要求
和业务要求。
Purchasing model:DTU
Deployment option:An Azure SQL Database elastic pool
3
You need to design a data retention solution for the Twitter feed data records. The solution
must meet the
customer sentiment analytics requirements.
Which Azure Storage functionality should you include in the solution?
您需要为Twitter提要数据记录设计数据保留解决方案。解决方案必须满足客户情绪分析要
求。
C. lifecycle management
4
You need to implement the surrogate key for the retail store table. The solution must meet
the sales transaction dataset requirements.
您需要为零售商店表实现代理键。解决方案必须满足销售事务数据集的要求。
What should you create?
你应该创造什么?
B. a table the has an IDENTITY property
5
You need to design an analytical storage solution for the transactional data. The solution
must meet the sales transaction dataset requirements.
您需要为事务性数据设计一个分析存储解决方案。解决方案必须满足销售事务数据集的要
求。
What should you include in the solution?
您应该在解决方案中包括什么?
To answer, select the appropriate options in the answer area.
要回答,请在“回答”区域中选择相应的选项。
NOTE: Each correct selection is worth one point.
注意:每个正确的选择值一分。
Table type to store retail store data:Hash
Table type to store promotional data: Round-robin
Box 1: Hash
Scenario:
Ensure that queries joining and filtering sales transaction records
based on product ID complete as quickly
as possible.
A hash distributed table can deliver the highest query performance
for joins and aggregations on large
tables.
Box 2: Round-robin
Scenario:
You plan to create a promotional table that will contain a
promotion ID. The promotion ID will be associated
to a specific product. The product will be identified by a product ID.
The table will be approximately 5 GB.
A round-robin table is the most straightforward table to create and
delivers fast performance when used as
a staging table for loads. These are some scenarios where you
should choose Round robin distribution:
When you cannot identify a single key to distribute your data.
If your data doesn’t frequently join with data from other tables.
When there are no obvious keys to join.
6
You have 20 Azure SQL databases provisioned by using the vCore purchasing model.
使用vCore购买模型配置了20个Azure SQL数据库。
You plan to create an Azure SQL Database elastic pool and add the 20 databases.
您计划创建一个azuresql数据库弹性池并添加这20个数据库。
Which three metrics should you use to size the elastic pool to meet the demands of your
workload? Each
您应该使用哪三个指标来调整弹性池的大小以满足您的工作负载需求?
A. total size of all the databases
A.所有数据库的总大小
C. number of concurrently peaking databases * peak CPU utilization
per database
C.并发峰值数据库数*每个数据库的峰值CPU利用率
E. total number of databases * average CPU utilization per database
E。数据库总数*每个数据库的平均CPU利用率
7
You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.
您在包含SSISDB数据库的Azure虚拟机上拥有SQL Server 2019。
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.
您发现所有Microsoft SQL Server integration Services(SSIS)包都无法在虚拟机上运行。
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.
您应该依次执行哪四个操作来解决问题?要回答,请将适当的操作从操作列表移到回答区
域,并按正确的顺序排列。
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 mater key by using the service master
key
8
FactSales has 6 billion rows and is loaded nightly by using a batch process.
FactSales有60亿行,每晚使用批处理加载。
Which type of compression provides the greatest space reduction for the database?
哪种类型的压缩为数据库提供了最大的空间缩减?
D. columnstore archival compression
You can further reduce the size of columnstore data by configuring
an additional compression called archival compression.
通过配置称为存档压缩的附加压缩,可以进一步减小columnstore
数据的大小。
9
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?
PolyBase
10
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance
contains a 4TB 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?
D. Database Migration Assistant
11
You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a
database named DB1.
You need to perform an online migration of DB1 to an Azure SQL Database managed
instance by using Azure Database Migration Service.
How should you configure the backup of DB1? To answer, select the appropriate options in
the answer area.
Backup type:Full and log backups only
Backup option:WITH CHECKSUM
Azure Database Migration Service uses the backup and restore
method to migrate your on-premises
databases to SQL Managed Instance. Azure Database Migration
Service only supports backups created using checksum.
12
You have a resource group named App1Dev that contains an Azure SQL Database server
named DevServer1. DevServer1 contains an Azure SQL database named DB1. The schema
and permissions for DB1 are saved in a Microsoft SQL Server Data Tools (SSDT) database
project.
您有一个名为App1Dev的资源组,其中包含名为DevServer1的Azure SQL数据库服务器。
DevServer1包含一个名为DB1的Azure SQL数据库。DB1的架构和权限保存在Microsoft SQL
Server数据工具(SSDT)数据库项目中。
You need to populate a new resource group named App1Test with the DB1 database and
an Azure SQL
您需要用DB1数据库和azuresql填充名为App1Test的新资源组
Server named TestServer1. The resources in App1Test must have the same configurations as
the resources in App1Dev.
名为TestServer1的服务器。App1Test中的资源必须与App1Dev中的资源具有相同的配置。
Which four actions should you perform in sequence? To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.
你应该依次执行哪四个动作?要回答,请将相应的操作从操作列表移到回答区域,并按正
确的顺序排列。
1.From the Azure portal,export the Azure Resource Manager
templates
1.从Azure门户导出Azure资源管理器模板
2.Change the server name and related variables in the templates
2.更改模板中的服务器名称和相关变量
3.From tha Azure portal,deploy the templates.
3.从Azure门户部署模板。
4.From the database project,deploy the database schema and
permissions
4.从数据库项目中,部署数据库架构和权限
13
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data
Lake Storage Gen2 account named Account1.
您有一个名为Pool1的Azure Synapse Analytics专用SQL池和一个名为Account1的Azure Data
Lake Storage Gen2帐户。
You plan to access the files in Account1 by using an external table.
您计划使用外部表访问Account1中的文件。
You need to create a data source in Pool1 that you can reference when you create the
external table.
您需要在Pool1中创建一个数据源,在创建外部表时可以引用该数据源。
How should you complete the Transact-SQL statement? To answer, select the appropriate
options in the answer area.
如何完成Transact-SQL语句?要回答,请在“回答”区域中选择相应的选项。
Box 1: blob
The following example creates an external data source for Azure
Data Lake Gen2
CREATE EXTERNAL DATA SOURCE YellowTaxi
WITH ( LOCATION =
'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/
',
TYPE = HADOOP)
Box 2: HADOOP
14
You plan to develop a dataset named Purchases by using Azure Databricks. Purchases will
contain the
following columns:
ProductID ItemPrice LineTotal Quantity StoreID Minute Month
Hour Year Day
You need to store the data to support hourly incremental load pipelines that will vary for
each StoreID. The solution must minimize storage costs.
您需要存储数据以支持每小时递增的负载管道,每个StoreID的负载管道都会有所不同。解
决方案必须将存储成本降至最低
How should you complete the code? To answer, select the appropriate options in the
answer area.
Example:
df.write.partitionBy("y","m","d")
.mode(SaveMode.Append)
.parquet("/data/hive/warehouse/db_name.db/" + tableName)
Box 2: ("Year","Month","Day","Hour","StoreID")
Box 3: .parquet("/Purchases")
15
You are designing a streaming data solution that will ingest variable volumes of data.
您正在设计一个流式数据解决方案,它将接收可变容量的数据。
You need to ensure that you can change the partition count after creation.
您需要确保在创建之后可以更改分区计数。
Which service should you use to ingest the data?
您应该使用哪个服务接收数据?
A. Azure Event Hubs Standard
B. Azure Stream Analytics
C. Azure Data Factory
D. Azure Event Hubs Dedicated
The partition count for an event hub in a dedicated Event Hubs
cluster can be increased after the event hub has been created.
16
Box 1: CREATE EXTERNAL TABLE
An external table points to data located in Hadoop, Azure Storage blob, or Azure Data Lake
Storage.
External tables are used to read data from files or write data to files in Azure Storage. With
Synapse SQL,
you can use external tables to read external data using dedicated SQL pool or serverless
SQL pool.
Syntax:
CREATE EXTERNAL TABLE { database_name.schema_name.table_name |
schema_name.table_name |
table_name }
( <column_definition> [ ,...n ] )
WITH (
LOCATION = 'folder_or_filepath',
DATA_SOURCE = external_data_source_name,
FILE_FORMAT = external_file_format_name
Box 2. OPENROWSET
When using serverless SQL pool, CETAS is used to create an external table and export query
results to
Azure Storage Blob or Azure Data Lake Storage Gen2.
Box 1: CREATE EXTERNAL TABLE
An external table points to data located in Hadoop, Azure Storage
blob, or Azure Data Lake Storage.
External tables are used to read data from files or write data to files
in Azure Storage. With Synapse SQL,
you can use external tables to read external data using dedicated
SQL pool or serverless SQL pool.
Syntax:
CREATE EXTERNAL TABLE {
database_name.schema_name.table_name |
schema_name.table_name |
table_name }
( <column_definition> [ ,...n ] )
WITH (
LOCATION = 'folder_or_filepath',
DATA_SOURCE = external_data_source_name,
FILE_FORMAT = external_file_format_name
Box 2. OPENROWSET
When using serverless SQL pool, CETAS is used to create an
external table and export query results to
Azure Storage Blob or Azure Data Lake Storage Gen2.
17
You have an Azure Synapse Analytics Apache Spark pool named Pool1.
You plan to load JSON files from an Azure Data Lake Storage Gen2 container into the tables
in Pool1. The structure and data types vary by file.
You need to load the files into the tables. The solution must maintain the source data types.
A. Load the data by using PySpark.
B. Load the data by using the OPENROWSET Transact-SQL
command in an Azure Synapse Analytics serverless SQL pool.
C. Use a Get Metadata activity in Azure Data Factory.
D. Use a Conditional Split transformation in an Azure Synapse data
flow.
18
You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL
pool. The date dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement?
A. HASH
B. REPLICATE
C. ROUND_ROBIN
19
You need to design a star schema to support analytical queries of the data. The star schema
will contain four tables including a date dimension.
Box 1: FactEvents
Fact tables store observations or events, and can be sales orders,
stock balances, exchange rates,
temperatures, etc.
Box 2: DimChannel
Dimension tables describe business entities – the things you model.
Entities can include products, people, places, and concepts
including time itself. The most consistent table you'll find in a star
schema is a date dimension table. A dimension table contains a key
column (or columns) that acts as a unique identifier, and descriptive
columns.
Box 3: DimEvent
20
You plan to create a table in an Azure Synapse Analytics dedicated SQL pool.
Data in the table will be retained for five years. Once a year, data that is older than five
years will be deleted.
You need to ensure that the data is distributed evenly across partitions. The solutions must
minimize the amount of time required to delete old data.
How should you complete the Transact-SQL statement? To answer, drag the appropriate
values to the correct targets. Each value may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Box 1: HASH
Box 2: OrderDateKey
In most cases, table partitions are created on a date column.
21
You have an Azure Synapse Analytics workspace named WS1 that contains an Apache
Spark pool named Pool1.
You plan to create a database named DB1 in Pool1.
You need to ensure that when tables are created in DB1, the tables are available
automatically as external tables to the built-in serverless SQL pool.
Which format should you use for the tables in DB1?
A. JSON
B. CSV
C. Parquet
D. ORC
Serverless SQL pool can automatically synchronize metadata from
Apache Spark. A serverless SQL pool database will be created for
each database existing in serverless Apache Spark pools.
For each Spark external table based on Parquet and located in
Azure Storage, an external table is created in a serverless SQL pool
database. As such, you can shut down your Spark pools and still
query Spark external tables from serverless SQL pool.
剩余45页未读,继续阅读
资源评论
- zyypjc2022-01-12用户下载后在一定时间内未进行评价,系统默认好评。
- maomao20322021-07-31用户下载后在一定时间内未进行评价,系统默认好评。
- LIUGAOYUAN9992021-11-11用户下载后在一定时间内未进行评价,系统默认好评。
- iricwen2021-08-20用户下载后在一定时间内未进行评价,系统默认好评。
- haiyingcanada2022-06-09用户下载后在一定时间内未进行评价,系统默认好评。
sbiaqgpyu
- 粉丝: 2
- 资源: 12
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- yolov8n-pose.pt 用 yolov8n-pose.onnx下载
- C++之STL的vector详解,包括初始化和各种函数:vector的初始化、数据的增删查改等
- stable-diffusion-webui-master
- openPLC-Editor C语言编程 在mp157 arm板上调用io等使用记录
- 无人机悬停时间计算软件.rar
- 主要讲解 mybatis中 实体层的属性与表的列不一致时如何处理? 可以采用将列重命名方法还可以采用resultMap 方式
- e6c0100f8ff84d329888827f836189e0.zip
- 工作汇报 年终总结19.pptx
- 工作汇报 年终总结99.pptx
- 基于 QT 编写的通讯录管理系统
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功