Prepare DP-300 Question Answers Free Update With 100% Exam Passing Guarantee [Q17-Q40]

質問17
Vou have an Azure SQL database named DB1.
You have 10 Azure virtual machines that connect to a virtual network subnet named Subnet 1.
You need to implement a database-level firewall that meets the following requirements:
* Ensures that only the 10 virtual machines can access DB1
* Follows the principle of least privilege
How should you configure the firewall rule, and how should you establish network connectivity from the virtual machines to DB1? To answer, select the appropriate options in the answer area.
注意：各選択肢の正解は1点満点とする。

質問18
You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytics in a star schema.
You plan to have a fact table for website visits. The table will be approximately 5 GB.
You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance.
何をお勧めしますか？回答するには、回答欄で適切な選択肢を選んでください。
注意：各選択肢の正解は1点満点とする。

質問19
You configure a long-term retention policy for an Azure SQL database as shown in the exhibit. (Click the Exhibit tab.)

The first weekly backup occurred on January 4, 2020. The dates for the first 10 weekly backups are:
January 4, 2020
January 11, 2020
January 18, 2020
January 25, 2020
February 1, 2020
February 8, 2020
February 15, 2020
February 22, 2020
February 29, 2020
March 7, 2020
ドロップダウンメニューを使用して、図に示されている情報に基づいて、各ステートメントを完成させる回答の選択肢を選択します。
注意：各選択肢の正解は1点満点とする。

質問20
You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.
You scale up the virtual machine to 16 vCPUSs and 64 GB of memory.
You need to provide the lowest latency for tempdb.
What is the total number of data files that tempdb should contain?

質問21
You have an Azure subscription that contains a logical SQL server. The server hosts two databases named db1 and db2 and an Azure AD sen/ice principal named appl.
You need to ensure that appl can access db1. The solution must use the principle of least privilege.
Transact-SQLステートメントはどのように完成させるべきですか？回答するには、回答エリアで適切なオプションを選択してください。
注意：各選択肢の正解は1点満点とする。

質問22
You have an Azure SQL database named DB1 in the General Purpose service tier.
The performance metrics for DB1 are shown in the following exhibit.

You need to reduce the Log IO percentage. The solution must minimize costs.
どうするべきか？

質問23
You need to recommend an authentication solution for App1 access to DB1 and DB2 after their migration to Instance1. The solution must meet the availability requirements.
Which actions should you perform in sequence? To answer, drag the appropriate actions to the correct order.
Each action 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.
注意：各選択肢の正解は1点満点とする。

質問24
You have a SQL Server on Azure Virtual Machines instance named VM1 . You run the following query.

以下の各記述について、その記述が真であれば「はい」を選択する。そうでない場合は、「いいえ」を選択してください。

質問25
You have an Azure SQL database named DB1 that contains a table named Table 1.
You run a query to load data into Table1.
The performance metrics of Table1 during the load operation are shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point.

質問26
You configure backups for an Azure SQL database as shown in the following exhibit.

ドロップダウンメニューを使用して、図に示されている情報に基づいて、各ステートメントを完成させる回答の選択肢を選択します。
注意：各選択肢の正解は1点満点とする。

質問27
あなたはAzureサブスクリプションを持っています。
You need to deploy a logical SQL server by using an Azure Resource Manager (ARM) template. The solution must ensure that the server will allow inbound connectivity from any Azure resource.
How should you complete the template? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.

質問28
You have an Azure SQL database named DB1.
You need to encrypt DB1. The solution must meet the following requirements;
* Encrypt data in motion.
* Support comparison operators.
* Provide randomized encryption.
解決策には何を含めるべきか？

質問29
You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations.
何を使うべきか？

質問30
ホットスポットに関する質問
You configure a long-term retention policy for an Azure SQL database as shown in the exhibit.

The first weekly backup occurred on January 4, 2020. The dates for the first 10 weekly backups are:
January 4, 2020
January 11, 2020
January 18, 2020
January 25, 2020
February 1, 2020
February 8, 2020
February 15, 2020
February 22, 2020
February 29, 2020
March 7, 2020
ドロップダウンメニューを使用して、図に示されている情報に基づいて、各ステートメントを完成させる回答の選択肢を選択します。
注意：各選択肢の正解は1点満点とする。

質問31
You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1.
DF1 contains a linked service.
You have an Azure Key vault named vault1 that contains an encryption kay named key1.
You need to encrypt df1 by using key1.
まず何をすべきか？

質問32
SalesSQLDb1 のパフォーマンス問題の原因を特定する必要があります。
どの2つのダイナミック管理ビューを使うべきか？それぞれの正解は解答の一部を示しています。
注意：各選択肢の正解は1点満点とする。

質問33
You have an Azure subscription. The subscription contains three virtual machines that run Red Hat Enterprise Linux (RHEL).
You plan to implement a highly available deployment of Microsoft SQL Server 2022 on the virtual machines by using failover cluster instances (FCIs).
You need to prepare for the implementation.
What should you do first on each server?

質問34
You have an Azure SQL database named sqldb1.
You need to minimize the amount of space by the data and log files of sqldb1.
What should you run?

質問35
You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order.
You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders.
What should you include in the solution? To answer, select the appropriate options in the answer are a.
注意：各選択肢の正解は1点満点とする。

質問36
You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements.
推薦状には何を書くべきか？

質問37
You need to design an analytical storage solution for the transactional dat a. The solution must meet the sales transaction dataset requirements.
解決策には何を含めるべきですか？解答するには、解答欄で適切な選択肢を選んでください。
注意：各選択肢の正解は1点満点とする。

質問38
You have a data warehouse in Azure Synapse Analytics.
You need to ensure that the data in the data warehouse is encrypted at rest.
What should you enable?

質問39
server1 という名前のサーバー上に db1 という名前の Azure SQL データベースがあります。
Query Performance Insight を使用して db1 を監視します。
パフォーマンス・モニタリング・データができるだけ早く利用できるように、クエリー・ストアの設定を変更する必要があります。
どの構成設定を変更し、どの値を構成する必要がありますか？回答するには、回答エリアで適切なオプションを選択してください。
注意：各選択肢の正解は1点満点とする。

質問40
You have an Azure subscription that contains an Azure SQL database named DB1.
You need to migrate DB1 to a vCore-based purchasing model by using the Azure Command-Line Interface (Azure CLI). The solution must meet the following requirements:
* Include two high availability replicas.
* ダウンタイムの最小化
How should you complete the Azure CLI command? To answer, select the appropriate options in the answer area.
注意：各選択肢の正解は1点満点とする。