You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.
Which Azure Storage functionality should you include in the solution?

• A.time-based retention
• B.change feed
• C.lifecycle management
• D.soft delete

Comment: *

Name: *

Email: *

Verification: *

You have an Azure SQL database.
You discover that the plan cache is full of compiled plans that were used only once.
You run the select * from sys.database_scoped_configurationsTransact-SQL command and
receive the results shown in the following table.

You need relieve the memory pressure.
What should you configure?

• A.LEGACY_CARDINALITY_ESTIMATION
• B.QUERY_OPTIMIZER_HOTFIXES
• C.OPTIMIZE_FOR_AD_HOC_WORKLOADS
• D.ACCELERATED_PLAN_FORCING

Comment: *

Name: *

Email: *

Verification: *

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

• A.Configure SalesSQLDb1 as writable.
• B.Update the connection strings of SalesSQLDb1App1.
• C.Update the firewall rules of SalesSQLDb1.
• D.Update the users in SalesSQLDb1.

Comment: *

Name: *

Email: *

Verification: *

You have an Azure subscription that contains the resources shown in the following table.

You need to back up db1 to mysqlbackups, and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to a stripe set.
Which three Transact-SQL statements should you execute in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.

Correct Answer:

1 - Create Credential,,,,,,
2 - Backup Database db1,,,,,
3 - Restore Database bd2 From URL=,,,,,
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver15

Comment: *

Name: *

Email: *

Verification: *

HOTSPOT
You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales.
You need to initiate a backup of Sales.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Correct Answer:

Explanation:
Box 1: TO URL = 'https://storage1.blob.core.windows.net/blob1/Sales.bak' Native database backup in Azure SQL Managed Instance.
You can backup any database using standard BACKUP T-SQL command:
BACKUP DATABASE tpcc2501
TO URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501.bak' WITH COPY_ONLY Box 2: WITH COPY_ONLY Reference:
https://techcommunity.microsoft.com/t5/azure-sql-database/native-database-backup-in-azure-sql-managed- instance/ba-p/386154

Comment: *

Name: *

Email: *

Verification: *