DP-300 Exam Question 86
You have a database on a SQL Server on Azure Virtual Machines instance.
The current state of Query Store for the database is shown in the following exhibit.
The current state of Query Store for the database is shown in the following exhibit.
DP-300 Exam Question 87
You are designing a streaming data solution that will ingest variable volumes of data.
You need to ensure that you can change the partition count after creation.
Which service should you use to ingest the data?
You need to ensure that you can change the partition count after creation.
Which service should you use to ingest the data?
DP-300 Exam Question 88
You have an Azure SQL database named that contains a table named Table1.
You run a query to bad data into Table1.
The performance Of Table1 during the load operation are shown in exhibit.
You run a query to bad data into Table1.
The performance Of Table1 during the load operation are shown in exhibit.
DP-300 Exam Question 89
You have an Azure SQL database named DB3.
You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click the Exhibit tab.)
Which Transact-SQL command should you run?
You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click the Exhibit tab.)
Which Transact-SQL command should you run?
DP-300 Exam Question 90
You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date
dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement?
dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement?