DP-300 무료 덤프문제 온라인 액세스

SIMULATION
You plan to create an automation runbook that will create database users in db1 from Azure AD identities.
You need to configure sql12345678 to support the creation of new database users.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

정답:

Provision Microsoft Entra admin (SQL Managed Instance)
Your SQL Managed Instance needs permission to read Microsoft Entra ID to accomplish tasks such as authentication of users through security group membership or creation of new users. For this to work, you must grant the SQL Managed Instance permission to read Microsoft Entra ID.
You can do this using the Azure portal or PowerShell.
To grant your SQL Managed Instance read permissions to Microsoft Entra ID using the Azure portal, sign in as a Global Administrator and follow these steps:
Step 1: In the Azure portal, in the upper-right corner select your account, and then choose Switch directories to confirm which directory is your Current directory. Switch directories, if necessary.

Step 2: Choose the correct Microsoft Entra directory as the Current directory.
This step links the subscription associated with Microsoft Entra ID to the SQL Managed Instance, ensuring the Microsoft Entra tenant and SQL Managed Instance use the same subscription.
Step 3: Now, you can choose your Microsoft Entra admin for your SQL Managed Instance. For that, go to your managed instance resource in the Azure portal and select Microsoft Entra admin under Settings.

Step 4: Select the banner on top of the Microsoft Entra admin page and grant permission to the current user.

Step 5: After the operation succeeds, the following notification will show up in the top-right corner:

Note: Microsoft Entra authentication uses identities in Microsoft Entra ID to access data sources such as Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. The Microsoft.Data.SqlClient namespace allows client applications to specify Microsoft Entra credentials in different authentication modes when they're connecting to Azure SQL Database and Azure SQL Managed Instance. To use Microsoft Entra authentication with Azure SQL, you must configure and manage Microsoft Entra authentication with Azure SQL.
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure
https://learn.microsoft.com/en-us/sql/connect/ado-net/sql/azure-active-directory-authentication

You have an Azure SQL database named DB1.
You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled.
During a database audit, you discover that none of the fields contain more than 150 characters.
You need to ensure that you can apply page compression to Table1.
What should you do?

• A.Change the column type to varchar (200).
• B.Change the column type to nvarchar (MAX).
• C.Configure the columns as sparse.
• D.Change the column type to varchar (MAX).

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL database named SQLDB1.
You need to replicate DB1 to SQLDB1.
Which type of replication should you use?

• A.snapshot
• B.merge
• C.peer-to-peer
• D.transactional

Hotspot Question
You have an Azure subscription that contains an Azure SQL database named DB1.
Users report that DB1 has query performance issues.
You need to ensure that you can move specific tables in DB1 to In-Memory OLTP.
How should you complete the T-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

정답:

Explanation:
Box 1: IsXTPSupported;
Step 1: Ensure you are using a Premium or Business Critical tier database In-Memory OLTP is supported if the result from the following query is 1 (not 0):
SELECT DATABASEPROPERTYEX(DB_NAME(), 'IsXTPSupported');
XTP stands for Extreme Transaction Processing, which is an informal name of the In-Memory OLTP feature.
(Step 2: Identify objects to migrate to In-Memory OLTP)
Box 2: MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT
Step 3: Create a comparable test database
Suppose the report indicates your database has a table that would benefit from being converted to a memory-optimized table. We recommend that you first test to confirm the indication by testing.
You need a test copy of your production database. The test database should be at the same service tier level as your production database.
To ease testing, tweak your test database as follows:
Connect to the test database by using SQL Server Management Studio (SSMS).
To avoid needing the WITH (SNAPSHOT) option in queries, set the current database's MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT option, as shown in the following T-SQL statement:
ALTER DATABASE CURRENT SET MEMORY_OPTIMIZED_ELEVATE_TO_SNAPSHOT = ON;
(Step 4: Migrate tables)
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-configure

Hotspot Question
You have an Azure subscription that is linked to an Azure Active Directory (Azure AD) tenant named contoso.com The subscription contains an Azure SQL database named SQL1 and an Azure web app named app1. App1 has the managed identity feature enabled.
You need to create a new database user for app1.
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:
In T-SQL, just point to App name not managed identity.
https://learn.microsoft.com/en-us/azure/active-directory/managed-identities-azure-resources/tutorial-windows-vm-access-sql