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

DP-300-KR 문제 51

Azure 구독을 보유하고 계십니다.
Azure 가상 머신에 SQL Server 인스턴스를 배포해야 합니다. 솔루션은 다음 요구 사항을 충족해야 합니다.
* 사용자 지정 성능 구성(예: lCPS, 용량 및 처리량)을 지원해야 합니다.
* 비용을 최소화해야 합니다
솔루션에 어떤 유형의 디스크를 포함해야 합니까?

A. 프리미엄 SSD v2

B. 프리미엄 SSD

C. 울트라 SSD

D. 표준 SSD

DP-300-KR 문제 52

DB1이라는 Azure SQL 데이터베이스가 포함된 Azure 구독이 있습니다.
DB1을 사용하여 탄력적 작업을 호스팅해야 합니다. DB1도 작업 대상으로 구성됩니다. 솔루션은 위치 기반 조건부 액세스 정책 사용을 지원해야 합니다.
탄력적 작업은 DB1에 액세스하기 위해 무엇을 사용해야 합니까?

A. 시스템에서 할당한 관리 ID

B. Azure SQL 로그인 자격 증명

C. 데이터베이스 범위 자격 증명

D. 사용자가 할당한 관리 ID

DP-300-KR 문제 53

과제 1
db1이라는 Azure SQL 데이터베이스에서 SalesLT.SalesOrderHeader 테이블의 PK_SalesOrderHeader_SalesOrderlD 클러스터형 인덱스에 대해 페이지 압축을 활성화해야 합니다.

정답:

See the explanation part for the complete Solution.
Explanation:
To enable page compression on the PK_SalesOrderHeader_SalesOrderlD clustered index of the SalesLT.
SalesOrderHeader table in db1, you can use the following Transact-SQL script:
-- Connect to the Azure SQL database named db1
USE db1;
GO
-- Enable page compression on the clustered index
ALTER INDEX PK_SalesOrderHeader_SalesOrderlD ON SalesLT.SalesOrderHeader REBUILD WITH (DATA_COMPRESSION = PAGE); GO This script will rebuild the clustered index with page compression, which can reduce the storage space and improve the query performance The script solution consists of three parts:
The first part is USE db1; GO. This part connects to the Azure SQL database named db1, where the SalesLT.
SalesOrderHeader table is located. The GO command separates the batches of Transact-SQL statements and sends them to the server.
The second part is ALTER INDEX PK_SalesOrderHeader_SalesOrderlD ON SalesLT.SalesOrderHeader REBUILD WITH (DATA_COMPRESSION = PAGE); GO. This part enables page compression on the clustered index named PK_SalesOrderHeader_SalesOrderlD, which is defined on the SalesLT.
SalesOrderHeader table. The ALTER INDEX statement modifies the properties of an existing index.
The REBUILD option rebuilds the index from scratch, which is required to change the compression setting.
The DATA_COMPRESSION = PAGE option specifies that page compression is applied to the index, which means that both row and prefix compression are used. Page compression can reduce the storage space and improve the query performance by compressing the data at the page level. The GO command ends the batch of statements.
The third part is optional, but it can be useful to verify the compression status of the index. It is SELECT name, index_id, data_compression_desc FROM sys.indexes WHERE object_id = OBJECT_ID( ' SalesLT.
SalesOrderHeader ' );. This part queries the sys.indexes catalog view, which contains information about the indexes in the database. The SELECT statement returns the name, index_id, and data_compression_desc columns for the indexes that belong to the SalesLT.SalesOrderHeader table. The OBJECT_ID function returns the object identification number for the table name. The data_compression_desc column shows the compression type of the index, which should be PAGE for the clustered index after the script is executed.
These are the steps of the script solution for enabling page compression on the clustered index of the SalesLT.
SalesOrderHeader table in db1.

DP-300-KR 문제 54

Azure SQL Database 관리형 인스턴스에 데이터베이스를 배포합니다.
읽기 쿼리가 데이터베이스에 쓰려고 하는 쿼리를 차단하지 못하도록 방지해야 합니다.
어떤 데이터베이스 옵션을 설정해야 합니까?

A. 강제로 매개변수화

B. 매개변수화를 SIMPLE로

C. 강제로 지연된 내구성

D. READ_COMMITTED_SNAPSHOT을 ON으로 설정

DP-300-KR 문제 55

트위터 피드 데이터 기록을 위한 데이터 보존 솔루션을 설계해야 합니다. 이 솔루션은 고객 감정 분석 요구 사항을 충족해야 합니다.
솔루션에 어떤 Azure Storage 기능을 포함해야 할까요?

A. 시간 기반 유지

B. 피드 변경

C. 라이프사이클 관리

D. 소프트 삭제

정답: C

The lifecycle management policy lets you:
Delete blobs, blob versions, and blob snapshots at the end of their lifecycles Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/storage-lifecycle-management-concepts Basic Concept: This question tests plan and configure a high availability and disaster recovery (ha/dr) environment in the DP-300 exam context. The correct choice is determined by the exact service boundary and operational requirement stated in the scenario.
Why C is Correct: lifecycle management matches the expected DP-300 administration action. lifecycle management is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: You need to design a data retention solution for the Twitter feed data records.
Why A is Wrong: time-based retention is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It does not meet the failover, restore, quorum, or cross-region continuity target stated in the question, even if it is valid in a different availability design.
Why B is Wrong: change feed is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It handles a different resilience pattern and would not deliver the failover or recovery behavior required here.
Why D is Wrong: soft delete is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It does not meet the failover, restore, quorum, or cross-region continuity target stated in the question, even if it is valid in a different availability design.

다른 버전: 936Microsoft.DP-300-KR.v2026-08-26.q212; 1024Microsoft.DP-300-KR.v2026-06-08.q157; 1331Microsoft.DP-300-KR.v2026-04-06.q179; 1716Microsoft.DP-300-KR.v2026-03-17.q211; 1226Microsoft.DP-300-KR.v2025-03-19.q146; 1450Microsoft.DP-300-KR.v2025-03-05.q148

최근 업로드: 136HashiCorp.Terraform-Associate-004.v2026-09-13.q130; 122PaloAltoNetworks.XDR-Engineer.v2026-09-13.q53; 128NREMT.EMT.v2026-09-13.q110; 144Splunk.SPLK-1002.v2026-09-13.q139; 192Salesforce.Experience-Cloud-Consultant.v2026-09-12.q117; 137Salesforce.B2C-Commerce-Architect.v2026-09-12.q72; 180PMI.PMI-ACP.v2026-09-12.q100; 257CIMA.F3.v2026-09-11.q205; 189CompTIA.SK0-005.v2026-09-11.q100; 155SAP.C_P2W22_2504.v2026-09-11.q29