최신 DP-300 무료덤프 - Microsoft Administering Relational Databases on Microsoft Azure
You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.
Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory.
You need to reduce tempdb contention without regatively affecting server performance.
What is the number of secondary data files that you should configure for tempdb?
Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory.
You need to reduce tempdb contention without regatively affecting server performance.
What is the number of secondary data files that you should configure for tempdb?
정답: B
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?
Which Azure Storage functionality should you include in the solution?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You have an Azure subscription.
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.
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.
정답:
Explanation:
What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and a database named DB1. DB1 contains a fact table named Table.
You need to identify the extent of the data skew in Table1.
What should you do in Synapse Studio?
You need to identify the extent of the data skew in Table1.
What should you do in Synapse Studio?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
You configure backups for an Azure SQL database as 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.
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:
You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.
You plan to access the files in Account1 by using an external table.
You need to create a data source in Pool1 that you can reference when you create the external table.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You plan to access the files in Account1 by using an external table.
You need to create a data source in Pool1 that you can reference when you create the external table.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation:
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 Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables
You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.
What should you include in the plan?
What should you include in the plan?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have an Azure subscription that contains an Azure SQL managed instance named SQL1.
You use the Microsoft Power B1 service.
You need to configure connectivity from the Power B1 service to SQL1. The solution must ensure that only the Power B1 service can initiate connections to SQL1.
Which type of endpoint should you use for SQL1, and what should you use to control the connections to SQL1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You use the Microsoft Power B1 service.
You need to configure connectivity from the Power B1 service to SQL1. The solution must ensure that only the Power B1 service can initiate connections to SQL1.
Which type of endpoint should you use for SQL1, and what should you use to control the connections to SQL1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation:
Task 2
You need to configure your user account as the Azure AD admin for the server named sql3700689S.
You need to configure your user account as the Azure AD admin for the server named sql3700689S.
정답:
See the explanation part for the complete Solution.
Explanation:
To configure your user account as the Azure AD admin for the server named sql3700689S, you can use the Azure portal or the Azure CLI. Here are the steps for both methods:
* Using the Azure portal:
* Go to the Azure portal and select SQL Server - Azure Arc.
* Select the server named sql3700689S and click on Active Directory admin.
* Click on Set admin and choose your user account from the list of Azure AD users.
* Click on Select and then Save to confirm the change.
* You can verify the Azure AD admin by clicking on Active Directory admin again and checking the current admin.
* Using the Azure CLI:
* Install the Azure CLI and log in with your Azure account.
* Run the following command to get the object ID of your user account: az ad user show --id <your- user-name> --query objectId -o tsv
* Run the following command to set your user account as the Azure AD admin for the server: az sql server ad-admin create --server sql3700689S --object-id <your-object-id> --display-name
<your-user-name>
* You can verify the Azure AD admin by running the following command: az sql server ad-admin show --server sql3700689S These are the steps to configure your user account as the Azure AD admin for the server named sql3700689S.
Explanation:
To configure your user account as the Azure AD admin for the server named sql3700689S, you can use the Azure portal or the Azure CLI. Here are the steps for both methods:
* Using the Azure portal:
* Go to the Azure portal and select SQL Server - Azure Arc.
* Select the server named sql3700689S and click on Active Directory admin.
* Click on Set admin and choose your user account from the list of Azure AD users.
* Click on Select and then Save to confirm the change.
* You can verify the Azure AD admin by clicking on Active Directory admin again and checking the current admin.
* Using the Azure CLI:
* Install the Azure CLI and log in with your Azure account.
* Run the following command to get the object ID of your user account: az ad user show --id <your- user-name> --query objectId -o tsv
* Run the following command to set your user account as the Azure AD admin for the server: az sql server ad-admin create --server sql3700689S --object-id <your-object-id> --display-name
<your-user-name>
* You can verify the Azure AD admin by running the following command: az sql server ad-admin show --server sql3700689S These are the steps to configure your user account as the Azure AD admin for the server named sql3700689S.
You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements.
What should you do?
What should you do?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
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.
What should you do first?
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.
What should you do first?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server.
You need to ensure that each customer can only connect to and access their respective database.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to ensure that each customer can only connect to and access their respective database.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
정답: B,E
설명: (DumpTOP 회원만 볼 수 있음)
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have SQL Server 2019 on an Azure virtual machine.
You are troubleshooting performance issues for a query in a SQL Server instance.
To gather more information, you query sys.dm_exec_requests and discover that the wait type is PAGELATCH_UP and the wait_resource is 2:3:905856.
You need to improve system performance.
Solution: You create additional tempdb files.
Does this meet the goal?
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have SQL Server 2019 on an Azure virtual machine.
You are troubleshooting performance issues for a query in a SQL Server instance.
To gather more information, you query sys.dm_exec_requests and discover that the wait type is PAGELATCH_UP and the wait_resource is 2:3:905856.
You need to improve system performance.
Solution: You create additional tempdb files.
Does this meet the goal?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You have an Azure subscription.
You need to deploy a logical SQL server by using PowerShell. The solution must ensure that the logical SQL server can create Azure AD users and provide Transparent Data Encryption (TDE} with a customer-managed key.
How should you complete the command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to deploy a logical SQL server by using PowerShell. The solution must ensure that the logical SQL server can create Azure AD users and provide Transparent Data Encryption (TDE} with a customer-managed key.
How should you complete the command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation:
"Assigned Identity" and "Key id" https://learn.microsoft.com/en-us/powershell/module/az.sql/new- azsqlserver?view=azps-10.2.0#code-try-3
You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?
In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.
Which type of storage accounts should you use for the backups?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
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.
Which type of compression provides the greatest space reduction for the database?
FactSales has 6 billion rows and is loaded nightly by using a batch process.
Which type of compression provides the greatest space reduction for the database?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)