최신 DP-300 무료덤프 - Microsoft Administering Relational Databases on Microsoft Azure
You have an Azure subscription that contains a SQL Server on Linux Azure Virtual Machines instance named VM1. VM1 contains a database named DB1.
You need to create operational performance baselines for DB1 and VM1.
What should you use?
You need to create operational performance baselines for DB1 and VM1.
What should you use?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You have an on-premises Microsoft SQL Server 2022 instance named SQL1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1.
You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1.
What should you include in the solution?
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1.
You need to configure a bidirectional disaster recovery solution between SQL1 and SQLMI1.
What should you include in the solution?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
SIMULATION
You need to capture the following information for all the databases on sq12345678:
- Queries to the databases
- Users that executed the queries
The captured information must be stored in sa12345678.
You may need to use SQL Server Management Studio and the Azure portal.
You need to capture the following information for all the databases on sq12345678:
- Queries to the databases
- Users that executed the queries
The captured information must be stored in sa12345678.
You may need to use SQL Server Management Studio and the Azure portal.
정답:
Extended Events is a lightweight performance monitoring system aimed at collecting data for monitoring and troubleshooting SQL Server problems.
To capture SQL Server queries and the users who executed them using Extended Events, you can configure an event session with the sql_statement_completed event and the sql_server_login event, as well as add actions to collect relevant information.
Step 1: Open SQL Server Management Studio (SSMS)
Step 2: .In Object Explorer locate the SQL Server named sq12345678.
Step 3: Create a New Event Session:
In SQL Server Management Studio, navigate to Management > Extended Events > Sessions, right-click, and select "New Session".
Step 4: Define Events:
sql_statement_completed: This event captures information about completed SQL statements. It will provide the SQL query text and other details.
sql_server_login: This event captures login information, including the username and IP address.
Step 5: Add Actions:
* sql_statement_completed:
Add actions like collect_system_time, collect_statement_text, collect_database_id, collect_principal_name, and collect_login_name to gather specific data.
Add an action to capture the client application name (e.g., collect_application_name).
* sql_server_login:
Add actions like collect_principal_name, collect_login_name, collect_session_id, and collect_client_hostname to capture login details.
Step 6: Select the Data Storage page, Choose Targets:
event_file: Store captured events in a file (blob) in Azure Storage for persistent storage and analysis using SSMS XEvent Profiler. [Select sa12345678 by using the browse button]
Step 7: Configure and Start:
Set the desired filter conditions (e.g., duration of queries) [skip] and start the event session.
Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server
https://www.mssqltips.com/sqlservertip/6550/capture-executions-of-stored-procedures-in-sql-server/
https://www.sqlshack.com/using-sql-server-extended-events-to-monitor-query-performance/
To capture SQL Server queries and the users who executed them using Extended Events, you can configure an event session with the sql_statement_completed event and the sql_server_login event, as well as add actions to collect relevant information.
Step 1: Open SQL Server Management Studio (SSMS)
Step 2: .In Object Explorer locate the SQL Server named sq12345678.
Step 3: Create a New Event Session:
In SQL Server Management Studio, navigate to Management > Extended Events > Sessions, right-click, and select "New Session".
Step 4: Define Events:
sql_statement_completed: This event captures information about completed SQL statements. It will provide the SQL query text and other details.
sql_server_login: This event captures login information, including the username and IP address.
Step 5: Add Actions:
* sql_statement_completed:
Add actions like collect_system_time, collect_statement_text, collect_database_id, collect_principal_name, and collect_login_name to gather specific data.
Add an action to capture the client application name (e.g., collect_application_name).
* sql_server_login:
Add actions like collect_principal_name, collect_login_name, collect_session_id, and collect_client_hostname to capture login details.
Step 6: Select the Data Storage page, Choose Targets:
event_file: Store captured events in a file (blob) in Azure Storage for persistent storage and analysis using SSMS XEvent Profiler. [Select sa12345678 by using the browse button]
Step 7: Configure and Start:
Set the desired filter conditions (e.g., duration of queries) [skip] and start the event session.
Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/extended-events/quick-start-extended-events-in-sql-server
https://www.mssqltips.com/sqlservertip/6550/capture-executions-of-stored-procedures-in-sql-server/
https://www.sqlshack.com/using-sql-server-extended-events-to-monitor-query-performance/
You have an Azure SQL database named DB1. You run a query while connected to DB1.
You review the actual execution plan for the query, and you add an index to a table referenced by the query.
You need to compare the previous actual execution plan for the query to the Live Query Statistics.
What should you do first in Microsoft SQL Server Management Studio (SSMS)?
You review the actual execution plan for the query, and you add an index to a table referenced by the query.
You need to compare the previous actual execution plan for the query to the Live Query Statistics.
What should you do first in Microsoft SQL Server Management Studio (SSMS)?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You have 20 Azure SQL databases provisioned by using the vCore purchasing model.
You plan to create an Azure SQL Database elastic pool and add the 20 databases.
Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You plan to create an Azure SQL Database elastic pool and add the 20 databases.
Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
정답: A,C,E
설명: (DumpTOP 회원만 볼 수 있음)
You have an Azure subscription that contains an Azure SQL database named DB1.
You need to host elastic jobs by using DB1. DB1 will also be configured as a job target. The solution must support the use of location-based Conditional Access policies.
What should the elastic jobs use to access DB1?
You need to host elastic jobs by using DB1. DB1 will also be configured as a job target. The solution must support the use of location-based Conditional Access policies.
What should the elastic jobs use to access DB1?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
Hotspot Question
From a website analytics system, you receive data extracts about user interactions such as downloads, link clicks, form submissions, and video plays.
The data contains the following columns:
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.
To which table should you add each column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
From a website analytics system, you receive data extracts about user interactions such as downloads, link clicks, form submissions, and video plays.
The data contains the following columns:
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.
To which table should you add each column? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
정답:
Explanation:
Box 1: DimEvent
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: FactEvents
Fact tables store observations or events, and can be sales orders, stock balances, exchange rates, temperatures, etc.
Reference:
https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
Case Study 5 - ADatum Corporation
Overview
ADatum Corporation is a financial services company that has a main office in New York City.
Existing Environment
Licensing Agreement
ADatum has a Microsoft Volume Licensing agreement that includes Software Assurance.
Network Infrastructure
ADatum has an on-premises datacenter and an Azure subscription named Sub1.
Sub1 contains a virtual network named Network1 in the East US Azure region.
The datacenter is connected to Network1 by using a Site-to-Site (S2S) VPN.
Identity Environment
The on-premises network contains an Active Directory Domain Services (AD DS) forest.
The forest contains a single domain named corp.adatum.com.
The corp.adatum.com domain syncs with a Microsoft Entra tenant named adatum.com.
Database Environment
The datacenter contains the servers shown in the following table.
DB1 and DB2 are used for transactional and analytical workloads by an application named App1.
App1 runs on Microsoft Entra hybrid joined servers that run Windows Server 2022. App1 uses Kerberos authentication.
DB3 stores compliance data used by two applications named App2 and App3.
DB3 performance is monitored by using Extended Events sessions, with the event_file target set to a file share on a local disk of SVR3.
Resource allocation for DB3 is managed by using Resource Governor.
Requirements
Planned Changes
ADatum plans to implement the following changes:
- Deploy an Azure SQL managed instance named Instance1 to Network1.
- Migrate DB1 and DB2 to Instance1.
- Migrate DB3 to Azure SQL Database.
- Following the migration of DB1 and DB2, hand over database development to remote developers who use Microsoft Entra joined Windows 11 devices.
- Following the migration of DB3, configure the database to be part of an auto-failover group.
Availability Requirements
ADatum identifies the following post-migration availability requirements:
- For DB1 and DB2, offload analytical workloads to a read-only database replica in the same Azure region.
- Ensure that if a regional disaster occurs, DB1 and DB2 can be recovered from backups.
- After the migration, App1 must maintain access to DB1 and DB2.
- For DB3, manage potential performance issues caused by resource demand changes by App2 and App3.
- Ensure that DB3 will still be accessible following a planned failover.
- Ensure that DB3 can be restored if the logical server is deleted.
- Minimize downtime during the migration of DB1 and DB2.
Security Requirements
ADatum identifies the following security requirements for after the migration:
- Ensure that only designated developers who use Microsoft Entra joined Windows 11 devices can access DB1 and DB2 remotely.
- Ensure that all changes to DB3, including ones within individual transactions, are audited and recorded.
Management Requirements
ADatum identifies the following post-migration management requirements:
- Continue using Extended Events to monitor DB3.
- In Azure SQL Database, automate the management of DB3 by using elastic jobs that have database-scoped credentials.
Business Requirements
ADatum identifies the following business requirements:
- Minimize costs whenever possible, without affecting other requirements.
- Minimize administrative effort.
You need to identify the event_file target for monitoring DB3 after the migration to Azure SQL Database. The solution must meet the management requirements.
What should you use as the event_file target?
Overview
ADatum Corporation is a financial services company that has a main office in New York City.
Existing Environment
Licensing Agreement
ADatum has a Microsoft Volume Licensing agreement that includes Software Assurance.
Network Infrastructure
ADatum has an on-premises datacenter and an Azure subscription named Sub1.
Sub1 contains a virtual network named Network1 in the East US Azure region.
The datacenter is connected to Network1 by using a Site-to-Site (S2S) VPN.
Identity Environment
The on-premises network contains an Active Directory Domain Services (AD DS) forest.
The forest contains a single domain named corp.adatum.com.
The corp.adatum.com domain syncs with a Microsoft Entra tenant named adatum.com.
Database Environment
The datacenter contains the servers shown in the following table.
DB1 and DB2 are used for transactional and analytical workloads by an application named App1.
App1 runs on Microsoft Entra hybrid joined servers that run Windows Server 2022. App1 uses Kerberos authentication.
DB3 stores compliance data used by two applications named App2 and App3.
DB3 performance is monitored by using Extended Events sessions, with the event_file target set to a file share on a local disk of SVR3.
Resource allocation for DB3 is managed by using Resource Governor.
Requirements
Planned Changes
ADatum plans to implement the following changes:
- Deploy an Azure SQL managed instance named Instance1 to Network1.
- Migrate DB1 and DB2 to Instance1.
- Migrate DB3 to Azure SQL Database.
- Following the migration of DB1 and DB2, hand over database development to remote developers who use Microsoft Entra joined Windows 11 devices.
- Following the migration of DB3, configure the database to be part of an auto-failover group.
Availability Requirements
ADatum identifies the following post-migration availability requirements:
- For DB1 and DB2, offload analytical workloads to a read-only database replica in the same Azure region.
- Ensure that if a regional disaster occurs, DB1 and DB2 can be recovered from backups.
- After the migration, App1 must maintain access to DB1 and DB2.
- For DB3, manage potential performance issues caused by resource demand changes by App2 and App3.
- Ensure that DB3 will still be accessible following a planned failover.
- Ensure that DB3 can be restored if the logical server is deleted.
- Minimize downtime during the migration of DB1 and DB2.
Security Requirements
ADatum identifies the following security requirements for after the migration:
- Ensure that only designated developers who use Microsoft Entra joined Windows 11 devices can access DB1 and DB2 remotely.
- Ensure that all changes to DB3, including ones within individual transactions, are audited and recorded.
Management Requirements
ADatum identifies the following post-migration management requirements:
- Continue using Extended Events to monitor DB3.
- In Azure SQL Database, automate the management of DB3 by using elastic jobs that have database-scoped credentials.
Business Requirements
ADatum identifies the following business requirements:
- Minimize costs whenever possible, without affecting other requirements.
- Minimize administrative effort.
You need to identify the event_file target for monitoring DB3 after the migration to Azure SQL Database. The solution must meet the management requirements.
What should you use as the event_file target?
정답: D
You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server1 contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1.
You create a master key in the master database of SQL1.
You need to create an encrypted backup of DB1.
What should you do?
You create a master key in the master database of SQL1.
You need to create an encrypted backup of DB1.
What should you do?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)