Font size
WorksheetsDP-300 Full MCQ Set
Total questions: 31
Worksheet time: 16mins
You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload?
Total size of all the databases
Geo-replication support
Number of concurrently peaking databases * peak CPU utilization per database
Maximum number of concurrent sessions for all the databases
Total number of databases * average CPU utilization per database
Which type of compression provides the greatest space reduction for a fact table with billions of rows in Azure SQL Database?
Page compression
Row compression
Columnstore compression
Columnstore archival compression
You plan to migrate DB1 from SQL Server 2019 to an Azure SQL database. What feature should be removed or replaced before migration?
Clustered columnstore indexes
PolyBase
Change tracking
Automatic tuning
You have a 4-TB database named DB1 in an on-premises SQL Server 2019 instance. You plan to migrate DB1 to an Azure SQL Database managed instance. What should you use to minimize downtime and data loss during the migration?
Distributed availability groups
Database mirroring
Always On Availability Group
Azure Database Migration Service
You have an on-premises SQL Server 2016 database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance using Azure Database Migration Service. How should you configure the backup of DB1?
Use full database backup
Use differential backup only
Use log backup only
Use transaction log backup with no recovery
Which type of compression provides the greatest space reduction for a large, batch-loaded table in Azure SQL Database?
Page compression
Row compression
Columnstore compression
Columnstore archival compression
Which distribution type should you use for a date dimension table in Azure Synapse Analytics dedicated SQL pool to minimize data movement?
HASH
REPLICATE
ROUND_ROBIN
In Azure Synapse Analytics, which file format should you use for tables in a Spark pool so they are automatically available as external tables to the built-in serverless SQL pool?
JSON
CSV
Parquet
ORC
You are designing a streaming data solution in Azure. Which service allows you to change the partition count after creation?
Azure Event Hubs Standard
Azure Stream Analytics
Azure Data Factory
Azure Event Hubs Dedicated
What is the best solution for anomaly detection on streaming data from an Azure IoT hub that must send results to Azure Synapse and minimize development effort?
Azure SQL Database
Azure Databricks
Azure Stream Analytics
Which output mode should you use in Azure Databricks Structured Streaming to report only new events that arrive during each interval?
Complete
Append
Update
Which disk type should be used for SQL Server transaction logs on Azure Virtual Machines to minimize latency?
Standard HDD
Standard SSD
Premium SSD
Ultra SSD
To ensure only masked values are visible in an Azure Synapse Analytics dedicated SQL pool column, what feature should you use?
Column-level encryption
Dynamic Data Masking
Always Encrypted
Row-level security
What is the first step to reduce the time it takes for an Azure Databricks cluster to start and scale up?
Upgrade workspace to Premium
Configure a global init script
Create a pool
Create a cluster policy
Which two objects should you create to ensure users from each company see only their company’s data in Azure Synapse Analytics dedicated SQL pool?
Column encryption key
Asymmetric keys
A function
Custom RBAC role
A security policy
Which Azure SQL deployment option supports SQL Server Agent and the use of master/target (MSX/TSX) jobs?
Azure SQL Managed Instance
Azure SQL Database
SQL Server on Azure Virtual Machines
Azure Database for MySQL
What is required to enable managed identities to access an Azure SQL database?
Assign a login at server level
Assign a contained database user with External provider
Assign db_owner role
Assign dbmanager role
Which Azure SQL Database compute tier allows dynamic scaling and pausing for cost savings?
Business Critical
Serverless compute tier
Elastic pool
General Purpose
You want to maximize memory-to-vCore ratio and optimize latency on an Azure SQL Managed Instance. Which service tier and hardware generation should you choose?
General Purpose on standard-series
Business Critical on premium-series
General Purpose on memory-optimized-series
Business Critical on memory-optimized-series
Which solution provides randomized encryption, supports comparison operators, and encrypts data in motion for Azure SQL Database?
Always Encrypted with secure enclaves
Always Encrypted
Column-level encryption
Transparent Data Encryption (TDE)
You need to provide a user with the ability to add and remove columns from tables in an Azure SQL database using least privilege. Which two actions should you perform?
Assign the database user the db_owner role.
Create a contained database user.
Create a login and associated database user.
Assign the database user the db_ddladmin role.
You plan to migrate an on-premises SQL Server database to Azure SQL Database. The solution must minimize downtime. What should you do?
Configure Transaction Log Shipping.
Implement Always On availability groups.
Configure transactional replication.
Import a BACPAC.
You need to ensure that when a user connects to an Azure SQL logical server using Azure Data Studio, they can see all the databases. What should you do?
Create the user in the master database.
Assign the db_datareader role for the master database.
Assign the db_datareader role for the databases the user creates.
Grant SELECT on sys.databases to public in the master database.
You want to encrypt a salary column in Azure SQL Database so that even DBAs can’t read the data. Which solution provides the most secure encryption?
Transparent Data Encryption (TDE)
Always Encrypted
Dynamic data masking
Row-level security
You need to ensure that salespeople can view only their respective sales orders in Azure SQL Database. What should you implement?
Row-level security
Column-level encryption
Always Encrypted
Dynamic data masking
You want to allow an application temporary access to Azure Data Lake Storage Gen2. Which solution should you use?
Role assignments
Account keys
Shared access signatures (SAS)
Azure Active Directory (Azure AD) identities
You want to minimize disk latency for an Azure SQL managed instance. Which service tier should you use?
Business Critical
Hyperscale
General Purpose
Premium
Which two objects should be used to ensure users from each company can view only their company’s data in Azure Synapse Analytics?
Column encryption key
Asymmetric keys
Function
Custom RBAC role
Security policy
You have a logical SQL server with two databases, db1 and db2, and an Azure AD service principal named app1. You need to ensure that app1 can access db1 with the least privilege. Which action should you take?
Create a contained database user for app1 on db1
Assign the db_owner role to app1 on db1
Create a login for app1 on the logical server
Assign the dbmanager role to app1
You need to grant a SQL Server Agent job account the minimum necessary OS user right. Which should you assign?
Increase scheduling priority
Log on as a service
Profile system performance
Log on as a batch job
You have an Azure SQL database and need to track every time values from a confidential column are returned in a query for 365 days. What should you do? (Choose 3.)
Turn on auditing and write audit logs to an Azure Storage account
Add extended properties to the column
Turn on auditing and write audit logs to an Event Hub
Apply sensitivity labels named Highly Confidential to the column
Turn on Azure Defender for SQL
