How well do you know Change Data Capture for Azure SQL Databases

Question Title

* 1. Customers will be able to use CDC on which of the Azure SQL database tiers

Azure SQL databases higher than the S3 (Standard 3) tier.

On all tiers of Azure SQL

Azure SQL databases lower than the S3 (Standard 3) tier.

Question Title

* 2. Identify the process of Changes capture.

Changes from Transaction logs.

Place the data in change tables.

By sync trigger after insert , update and delete.

None of the above

Question Title

* 3. Which of the following command will enable CDC at the database level

EXEC sys.sp_cdc_enable_db

EXEC sys.sp_cdc_enable_table

None of the above

Question Title

* 4. Which of the following command will enable CDC at the table level

EXEC sys.sp_cdc_enable_db

EXEC sys.sp_cdc_enable_table

None of the above

Question Title

* 5. If you want to collect Firewalls, IPS, network devices logs which of the connectors you need to configure.

Logic App playbooks

Logstash collector

Log Analytics agent

None of the above

Question Title

* 6. In SQL Server capture and cleanup are run by the SQL Server Agent. On Azure SQL what is the equivalent process?

On Azure SQL - SQL Server Agent is executed for capturing and cleanup.

On Azure SQL scheduler is executed for capturing and cleanup.

Azure data factory need to be configured with Azure SQL scheduler for capturing and cleanup.

Question Title

* 7. Where are the CDC artifacts (e.g. CT tables, cdc_jobs etc.) are stored?

In a different database (outside of the database - where the CDC is enabled)

In the same database where the CDC is enabled.

Question Title

* 8. Identify key factors that might impact performance when you enable change data capture.

Space available in the source database

The number of tracked CDC-enabled tables.

Space available in the source database

Storage logs

Question Title

* 9. Identify ways to increase the performance of CDC

Increase the number of vCores

Upgrade to a higher database tier

Stop the CDC process.

Stop logging of the database.

None of the above

Question Title

* 10. Which is the most critical steps before you enable CDC and have optimal performance.

Monitor space utilization closely and test your workload.

Increase vCores.

Upgrade to a higher database tier.

None of the above