Microsoft DP-300 Exam Questions & Answers

Correct Answer: D

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

Correct Answer:

Box 1: A single Azure SQL database in the serverless computer tier Automatically scales compute based on the workload demand. Provides per-second billing.

Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second.

Box 2: General Purpose service

The serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier.

Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview

Correct Answer:

Step 1: Connect to SQLDB1 and run the following Transact-SQL statement ALTER DATABASE SQLDb1 SET CHANGE_TRACKING - ON

Before you can use change tracking, you must enable change tracking at the database level.

The following example shows how to enable change tracking by using ALTER DATABASE.

ALTER DATABASE AdventureWorks2012

SET CHANGE_TRACKING = ON

(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)

Step 2: Connect to SQLDB1 and run the following Transact-SQL statement ALTER TABLE dbo.Table1 ENABLE CHANGE TRACKING

Enable Change Tracking for a Table

Change tracking must be enabled for each table that you want tracked. When change tracking is enabled, change tracking information is maintained for all rows in the table that are affected by a DML operation.

The following example shows how to enable change tracking for a table by using ALTER TABLE.

ALTER TABLE Person.Contact

ENABLE CHANGE_TRACKING

WITH (TRACK_COLUMNS_UPDATED = ON)

Step 3: From webapp1, connect to SQLDb1, obtain the initial dataset, and run the CHANGETABLE() function.

Obtain changes by using change tracking functions

The CHANGETABLE function is used to obtain change tracking information.

This rowset function is used to query for change information. The function queries the data stored in the internal change tracking tables. The function returns a results set that contains the primary keys of rows that have changed together with

other change information such as the operation, columns updated and version for the row.

Incorrect:

* CHANGE_TRACKING_CURRENT_VERSION() function

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/enable-and-disable-change-tracking-sql-server https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/work-with-change-tracking-sql-server