Online Access Free DP-300 Exam Questions

Hotspot Question
You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytics in a star schema.
You plan to have a fact table for website visits. The table will be approximately 5 GB.
You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Explanation:
Box 1: Hash
Consider using a hash-distributed table when:
The table size on disk is more than 2 GB.
The table has frequent insert, update, and delete operations.
Box 2: Clustered columnstore
Clustered columnstore tables offer both the highest level of data compression and the best overall query performance.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index

SIMULATION
You need to configure a monthly backup of db2. The monthly backups must be retained for five years, and then deleted.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Correct Answer:

Change automated backup settings for Azure SQL Database
You can modify automated backup settings for Azure SQL Database, such as the short-term retention policy and the backup storage redundancy option that's used for backups.
To change differential backup frequency, select 12 Hours or 24 hours from the drop-down menu under Differential backup frequency.
Step 1: Go to the logical server in Azure with the databases whose retention period you want to change.
Step 2: Select Backups on the left pane, and then select the Retention policies tab.
Step 3: Select the databases for which you want to change the PITR backup retention. [Select db2] Step 4: Select Configure policies from the action bar.
Step 5: To change the retention period for point-in-time restore backups, use the slider under Point-in-time restore. [Skip] Step 6: To change the PITR (point-in-time recovery) backup retention period or the differential backup frequency for active databases by using the Azure portal: [Skip]

Step 7: In Long-term retention, Monthly LTR Bakcups, Set Keep the first backup of each month for: 5 Years Question: The monthly backups must be retained for five years, and then deleted.
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-change-settings

You have an Azure SQL database named DB1.
You need to query the fragmentation information of data and indexes for the tables in DB1.
Which command should you run?

• A.DBCC CHECKALLOC
• B.DBCC SHOWCONTIG
• C.sts.dm_db_index_physical_stats
• D.sys.dm_db_index_usage_stats

You have an on-premises server that has Microsoft SQL Server 2022 installed. The server contains multiple databases.
You have an Azure subscription that contains multiple Azure SQL databases.
You configure daily backups for the databases.
You need to ensure that all the backups are stored in a central location.
What should you use to store the backups?

• A.a Recovery Services Vault
• B.Azure Table storage
• C.an Azure Files share
• D.Azure Blob Storage

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.
You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead.
What should you do?

• A.From the Azure portal, set a sensitivity classification of Confidential for the Email column.
• B.From the Azure portal, set a mask on the Email column.
• C.From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.
• D.From Microsoft SQL Server Management Studio, set an email mask on the Email column.