ちなみに、JPNTest DP-300の一部をクラウドストレージからダウンロードできます：https://drive.google.com/open?id=1psuZZIsP3-rIAdpyrzDZQGK9ypAjJeed
MicrosoftのDP-300試験の合格書は君の仕事の上で更に一歩の昇進と生活条件の向上を助けられて、大きな財産に相当します。MicrosoftのDP-300認定試験はIT専門知識のレベルの考察として、とっても重要な地位になりつつます。JPNTestは最も正確なMicrosoftのDP-300試験資料を追求しています。
DP-300試験は、Microsoft Azure上で関係データベースを管理するための幅広いトピックをカバーしています。試験には、インフラストラクチャの展開と構成、データベースの管理、セキュリティの実装、パフォーマンスの監視と最適化、高可用性ソリューションの実装などのトピックが含まれています。この試験は、これらのすべての領域での候補者の知識とスキルをテストするように設計されており、データベース管理者にとって包括的な認定資格となっています。
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
弊社のDP-300練習資料は、さまざまな学位の受験者に適しています。これらの受験者は、この分野の知識のレベルに関係ありません。これらのDP-300トレーニング資料は当社にとって名誉あるものであり、お客様の目標達成を支援するための最大限の特権として扱っています。私たちの知る限り、DP-300試験準備は何百万人もの受験者に夢を追いかけ、より効率的に学習するように動機付けました。 DP-300の練習資料は、あなたを失望させません。
質問 # 258
You have an Azure Data Factory instance named ADF1 and two Azure Synapse Analytics workspaces named WS1 and WS2.
ADF1 contains the following pipelines:
P1:Uses a copy activity to copy data from a nonpartitioned table in a dedicated SQL pool of WS1 to an Azure Data Lake Storage Gen2 account P2:Uses a copy activity to copy data from text-delimited files in an Azure Data Lake Storage Gen2 account to a nonpartitioned table in a dedicated SQL pool of WS2 You need to configure P1 and P2 to maximize parallelism and performance.
Which dataset settings should you configure for the copy activity of each pipeline? To answer, select the appropriate options in the answer area.
正解：
解説：
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-data-warehouse
https://docs.microsoft.com/en-us/azure/data-factory/load-azure-sql-data-warehouse
質問 # 259
You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
The database role membership for a user named User1 is 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.
正解：
解説：
Explanation
Box 1: delete a row from Table1
Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.
Box 2: db_datareader
Members of the db_datareader fixed database role can read all data from all user tables.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles
質問 # 260
You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table.
You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements:
The first six numerals of each customer's phone number must be masked.
The last four digits of each customer's phone number must be visible.
Hyphens must be preserved and displayed.
How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area.
正解：
解説：
Explanation:
Box 1: 0
Custom String : Masking method that exposes the first and last letters and adds a custom padding string in the middle. prefix,[padding],suffix Box 2: xxx-xxx Box 3: 5 Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking Basic Concept: This question tests secure database administration, where the control must match the data state, access boundary, identity model, or compliance requirement.
Why the selected answer is Correct: The selected values fit this scenario because they apply the required Azure SQL configuration at the correct scope and sequence: The mask must meet the following requirements:
The first six numerals of each customer's phone number must be masked.
Why the alternate choices are Wrong: The alternate selections apply to different administrative stages or different scopes. In a hotspot or drag-drop task, order and scope are part of the answer, so a technically valid Azure feature can still be wrong if it is placed in the wrong step.
質問 # 261
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?
正解：D
解説：
DBCC SHRINKDATABASE shrinks the size of the data and log files in the specified database.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkdatabase-transact-sql Basic Concept: This question tests plan and implement data platform resources in the DP-300 exam context.
The correct choice is determined by the exact service boundary and operational requirement stated in the scenario.
Why D is Correct: DBCC SHRINKFILE matches the expected DP-300 administration action. DBCC SHRINKFILE is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: You need to minimize the amount of space by the data and log files of sqldb1.
Why A is Wrong: DBCC SHRINKDATABASE is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It applies to a different Azure data-platform design than the one the question is testing.
Why B is Wrong: sp_clean_db_free_space is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It would solve a neighboring problem, but not the deployment, sizing, or migration requirement in this item.
Why C is Wrong: sp_clean_db_file_free_space is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It mismatches the target platform, migration method, compute tier, or deployment model described in the scenario, so it would not satisfy the workload as stated.
質問 # 262
SIMULATION
You need to encrypt the LastName column of the SalesLT.Customer table in db1 by using Always Encrypted. You must use the Windows Certificate Store.
You may need to use SQL Server Management Studio and the Azure portal.
正解：
解説：
Solution 1 [Less complex]
Configure column encryption using Always Encrypted Wizard
The Always Encrypted Wizard is a powerful tool that allows you to set the desired Always Encrypted configuration for selected database columns. Depending on the current configuration and the desired target configuration, the wizard can encrypt a column, decrypt it (remove encryption), or re-encrypt it (for example, using a new column encryption key or an encryption type that is different from the current type, configured for the column). Multiple columns can be configured in a single run of the wizard.
Step 1: Open the Always Encrypted Wizard
You can launch the wizard at three different levels:
At a database level - if you want to encrypt multiple columns located in different tables.
At a table level - if you want to encrypt multiple columns located in the same table.
*-> At a column level - if you want to encrypt one specific column. [This option here] Step 2: Connect to your SQL Server with the Object Explorer component of SQL Server Management Studio.
Step 3: To encrypt an individual column, navigate to the column, right-click on it, and then select Encrypt Columns. [Select the LastName column of the SalesLT.Customer table in db1] Step 4: Column Selection page In this page, you select columns you want to encrypt, re-encrypt, or decrypt, and you define the target encryption configuration for the selected columns.
Step 5: If you want the wizard to encrypt or re-encrypt one or more columns using a new column encryption key, pick a key containing (New) in its name. The wizard will generate the key.
Step 6: Master Key Configuration page
If you have selected an autogenerated column encryption key for any column on the previous page, in this page you need to either select an existing column master key or configure a new column master key that will encrypt the column encryption key.
When configuring a new column master key, you can either pick an existing key in Windows Certificate Store or in Azure Key Vault and have the wizard to create just a metadata object for the key in the database, or you can choose to generate both the key and the metadata object describing the key in the database.
Step 7: Click "Next" and follow the wizard's instructions to complete the process.
Solution 2 [A bit more complex. Use for reference]
To encrypt a specific column using Always Encrypted with a Windows Certificate Store, you'll first need to set up a Column Master Key (CMK) [Task 1] and a Column Encryption Key (CEK) [Task
2]. The CMK will be protected by a certificate in the Windows Certificate Store, and the CEK will then be used to encrypt the data in your chosen column.
Task 1: Set up a Column Master Key (CMK)
Create a self-signed certificate using SQL Server Management Studio (SSMS) Provision Column Master Keys with the New Column Master Key Dialog The New Column Master Key dialog allows you to generate a column master key or pick an existing key in a key store, and create column master key metadata for the created or selected key in the database.
Step 1: Using Object Explorer, navigate to the Security -> Always Encrypted Keys node under your database.
Step 2: Right-click on the Column Master Keys node and select New Column Master Key....
Step 3: In the New Column Master Key dialog, enter the name of the column master key metadata object.
Step 4: Select a key store:
*-> Certificate Store - Current User - indicates the Current User certificate store location in the Windows Certificate Store, which is your personal store. [Select this one] Certificate Store - Local computer Azure Key Vault Etc.
Step 5: If you're using SQL Server 2019 (15.x) and your SQL Server instance is configured with a secure enclave, you can select the Allow enclave computations checkbox to make the master key enclave-enabled. [Skip] Step 6: Pick an existing key in your key store, or click the Generate Key or Generate Certificate button, to create a key in the key store. [Pick existing] Step 7: Click OK and the new key appears in the list.
Task 2: Create a Column Encryption Key (CEK)
1. In SSMS, navigate to "Always Encrypted Keys" -> "Column Encryption Keys".
2. Right-click and select "New Column Encryption Key".
3. Give the CEK a name.
4. Select the CMK you just created. [Created in Stage 1]
5. Click "OK".
Task 3: Encrypt the data in your chosen column.
1. Right-click on the specific column you want to encrypt in Object Explorer. [Select the LastName column of the SalesLT.Customer table in db1]
2. Select "Tasks" -> "Encrypt Columns".
3. The Always Encrypted Wizard will guide you through the process:
4. Select the column you want to encrypt. [Select the LastName column of the SalesLT.Customer table in db1]
5. Choose the encryption type (Deterministic or Randomized).
6. Select the CEK you created. [Created in Stage 2]
7. Click "Next" and follow the wizard's instructions to complete the process.
Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted- wizard
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/create-and-store- column-master-keys-always-encrypted
質問 # 263
......
あなたはもうMicrosoft DP-300資格認定試験を申し込んでいましたか．いまのあなたは山となるDP-300復習教材と練習問題に面して頭が痛いと感じますか。JPNTestは絶対にあなたに信頼できるウエブサイトなので、あなたの問題を解決するJPNTestをお勧めいたします。役立つかどうかな資料にあまり多い時間をかけるより、早くJPNTestのサービスを体験してください。躊躇わなく、行動しましょう。
DP-300参考書: https://www.jpntest.com/shiken/DP-300-mondaishu
さらに、JPNTest DP-300ダンプの一部が現在無料で提供されています：https://drive.google.com/open?id=1psuZZIsP3-rIAdpyrzDZQGK9ypAjJeed