무료 온라인 액세스 Microsoft.DP-300-KR.v2026-06-08.q176 모의 시험 (Page 11)

DP-300-KR 문제 46

db1이라는 Azure SQL 데이터베이스가 있고, 그 안에 user1이라는 Azure Active Directory(Azure AD) 사용자가 있습니다.
db1에서 user1의 가장 권한이 높은 사용자로 테스트를 진행하려면 SELECT 문을 실행한 후 원래 실행 컨텍스트로 돌아가야 합니다.
Transact-SQL 문을 어떻게 완성해야 합니까? 답하려면 답변 영역에서 적절한 옵션을 선택하십시오.
참고: 정답 하나당 1점입니다.

DP-300-KR 문제 47

다양한 볼륨의 데이터를 수집하는 스트리밍 데이터 솔루션을 설계하고 있습니다.
생성 후에 파티션 수를 변경할 수 있는지 확인해야 합니다.
데이터를 수집하려면 어떤 서비스를 사용해야 합니까?

A. Azure Event Hubs 표준

B. Azure 스트림 분석

C. Azure 데이터 팩토리

D. 전용 Azure Event Hubs

DP-300-KR 문제 48

60TB 프로덕션 데이터베이스인 DB1을 호스팅하는 온프레미스 Microsoft SQL Server 2022 인스턴스가 있습니다.
DB1을 Azure로 마이그레이션할 계획입니다.
DB1에 대한 호스팅 솔루션을 추천해주세요.
DB1을 호스팅하려면 어떤 Azure SQL Database 서비스 계층을 사용해야 합니까?

A. 하이퍼스케일

B. 비즈니스에 중요함

C. 일반 목적

DP-300-KR 문제 49

Azure 구독에는 db1이라는 이름의 Azure SQL 데이터베이스가 있습니다.
db1에 SQL Insights를 구현해야 합니다.
어떤 리소스 두 개를 먼저 생성해야 할까요? 각 정답은 해결책의 일부를 나타냅니다.
참고: 정답 하나당 1점입니다.

A. Azure 로직 앱

B. 가상 머신

C. Azure 함수

D. 로그 분석 작업 공간

E. 스토리지 계정

정답: B,D

Basic Concept: This question tests monitor, configure, and optimize database 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 B and D is Correct: a virtual machine is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation.
This fits the case because the requested outcome is: You need to implement SQL insights for db1. The selected feature addresses that outcome directly rather than relying on a workaround. a Log Analytics workspace matches the expected DP-300 administration action. Log Analytics stores logs and metrics in a queryable workspace and supports workbooks, dashboards, alerting, and cross-resource analysis. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: You need to implement SQL insights for db1.
Why A is Wrong: an Azure logic app is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It is useful in other troubleshooting paths, but this scenario requires a more specific monitoring or optimization feature.
Why C is Wrong: an Azure function is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It does not expose the required metric, query history, wait/blocking signal, or tuning mechanism; using it would not give the administrator the evidence requested.
Why E is Wrong: a storage account is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It would produce a different operational signal than the one needed to investigate, alert, or tune the workload in this question.

DP-300-KR 문제 50

df1이라는 Azure Data Factory 버전 2(V2) 데이터 팩터리가 포함된 Azure 구독이 있습니다. DF1에는 연결된 서비스가 포함되어 있습니다.
key1이라는 암호화 키를 포함하는 Vault1이라는 Azure Key Vault가 있습니다.
key1을 사용하여 df1을 암호화해야 합니다.
먼저 무엇을 해야 할까요?

A. Vault1에서 제거 보호를 비활성화합니다.

B. df1에서 연결된 서비스를 제거합니다.

C. 자체 호스팅 통합 런타임을 만듭니다.

D. Vault1에서 일시 삭제를 비활성화합니다.

정답: C

A customer-managed key can only be configured on an empty data Factory. The data factory can ' t contain any resources such as linked services, pipelines and data flows. It is recommended to enable customer- managed key right after factory creation.
Note: Azure Data Factory encrypts data at rest, including entity definitions and any data cached while runs are in progress. By default, data is encrypted with a randomly generated Microsoft-managed key that is uniquely assigned to your data factory.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/enable-customer-managed-key Basic Concept: This question tests secure database administration, where the control must match the data state, access boundary, identity model, or compliance requirement.
Why C is Correct: Create a self-hosted integration runtime. is correct because it is the feature whose normal purpose matches the stated requirement. Create a self-hosted integration runtime. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. The scenario wording points to that specific behavior: You need to encrypt df1 by using key1.
Why A is Wrong: Disable purge protection on vault1. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: You need to encrypt df1 by using key1.
Why B is Wrong: Remove the linked service from df1. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It protects or manages a different security layer, so the required database access or protection behavior would still be incomplete.
Why D is Wrong: Disable soft delete on vault1. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: You need to encrypt df1 by using key1.

다른 버전: 218Microsoft.DP-300-KR.v2026-06-08.q157; 578Microsoft.DP-300-KR.v2026-04-06.q179; 709Microsoft.DP-300-KR.v2026-03-17.q211; 655Microsoft.DP-300-KR.v2025-03-19.q146; 1063Microsoft.DP-300-KR.v2025-03-05.q148

최근 업로드: 112WGU.Global-Economics-for-Managers.v2026-06-15.q48; 137Databricks.Databricks-Certified-Data-Engineer-Professional.v2026-06-15.q112; 125Oracle.1Z0-136.v2026-06-15.q46; 116SAP.C-P2W10-2504.v2026-06-15.q29; 120SAP.C_SAC_2601.v2026-06-15.q39; 125Nutanix.NCP-NS.v2026-06-15.q39; 145SAP.C_S4CPB_2602.v2026-06-13.q7; 162SAP.C-S4CS-2602.v2026-06-13.q29; 191Salesforce.Slack-Con-201.v2026-06-13.q86; 195Oracle.1Z1-136.v2026-06-13.q46