Exam DP-300: Administering Microsoft Azure SQL Solutions QUESTION AND ANSWERS. exam dumps
here are 40 legitimate and updated multiple-choice questions and answers for the Microsoft Exam DP-300:
1.What is the primary purpose of Azure SQL Database?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed key-value store in the cloud
Answer: B
2.What is the primary purpose of Azure SQL Managed Instance?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed key-value store in the cloud
Answer: B
3.What is the primary difference between Azure SQL Database and Azure SQL Managed Instance?
A. Azure SQL Database is fully managed by Microsoft, while Azure SQL Managed Instance requires more user management
B. Azure SQL Managed Instance provides better performance than Azure SQL Database
C. Azure SQL Managed Instance is more expensive than Azure SQL Database
D. Azure SQL Database is only suitable for small databases, while Azure SQL Managed Instance is suitable for large databases
Answer: A
4.What is a firewall rule in Azure SQL Database?
A. A rule that specifies which resources can access the database
B. A rule that specifies which databases can access the resource
C. A rule that specifies which users can access the database
D. A rule that specifies which IP addresses can access the database
Answer: D
5.What is an Azure Virtual Network?
A. A network that connects on-premises resources to the cloud
B. A network that connects cloud resources to each other
C. A network that connects resources in different regions
D. A network that connects resources in different subscriptions
Answer: B
6.What is an Azure Load Balancer?
A. A load balancing mechanism that distributes traffic across multiple resources in the same region
B. A load balancing mechanism that distributes traffic across multiple resources in different regions
C. A load balancing mechanism that distributes traffic across multiple subscriptions
D. A load balancing mechanism that distributes traffic across multiple virtual networks
Answer: A
7.What is an Azure Application Gateway?
A. A load balancing mechanism that distributes traffic across multiple resources based on HTTP request content
B. A load balancing mechanism that distributes traffic across multiple resources based on TCP/UDP ports
C. A load balancing mechanism that distributes traffic across multiple virtual networks
D. A load balancing mechanism that distributes traffic across multiple subscriptions
Answer: A
8.What is Azure Monitor?
A. A service that allows you to monitor and alert on performance and availability of your resources
B. A service that allows you to monitor and alert on security issues in your resources
C. A service that allows you to monitor and alert on cost and usage of your resources
D. A service that allows you to monitor and alert on compliance issues in your resources
Answer: A
9.What is Azure Log Analytics?
A. A service that allows you to collect and analyze log data from your resources
B. A service that allows you to collect and analyze performance data from your resources
C. A service that allows you to collect and analyze security data from your resources
D. A service that allows you to collect and analyze compliance data from your resources
Answer: A
10.What is Azure Backup?
A. A service that allows you to back up your data to the cloud
B. A service that allows you to back up your data to on-premises storage
C. A service that allows you to back up your data to a different region
D. A service that allows you to back up your
Answer: A
11.What is Azure Site Recovery?
A. A disaster recovery solution that allows you to replicate your resources to a secondary location in the event of a disaster
B. A backup and restore solution that allows you to restore your resources to a specific point in time
C. A monitoring solution that allows you to monitor the performance and availability of your resources
D. A security solution that allows you to monitor and alert on security issues in your resources
Answer: A
12.What is the purpose of a primary key in a database?
A. To provide a unique identifier for each row in a table
B. To provide a unique identifier for each column in a table
C. To ensure that each row in a table has the same number of columns
D. To ensure that each column in a table has a unique value
Answer: A
13.What is the purpose of a foreign key in a database?
A. To establish a relationship between two tables
B. To provide a unique identifier for each row in a table
C. To ensure that each row in a table has the same number of columns
D. To ensure that each column in a table has a unique value
Answer: A
14.What is the purpose of an index in a database?
A. To improve query performance by allowing data to be retrieved more efficiently
B. To provide a unique identifier for each row in a table
C. To ensure that each row in a table has the same number of columns
D. To ensure that each column in a table has a unique value
Answer: A
15.What is the purpose of a stored procedure in a database?
A. To provide a precompiled set of instructions that can be executed by a client application
B. To provide a unique identifier for each row in a table
C. To ensure that each row in a table has the same number of columns
D. To ensure that each column in a table has a unique value
Answer: A
16.What is the purpose of a trigger in a database?
A. To execute a set of instructions automatically in response to a specific event
B. To provide a unique identifier for each row in a table
C. To ensure that each row in a table has the same number of columns
D. To ensure that each column in a table has a unique value
Answer: A
17.What is the difference between a clustered and non-clustered index in a database?
A. A clustered index determines the physical order of data in a table, while a non-clustered index is a separate structure that points to the physical location of data
B. A clustered index is a separate structure that points to the physical location of data, while a non-clustered index determines the physical order of data in a table
C. A clustered index is used for text-based data, while a non-clustered index is used for numeric data
D. A clustered index is used for numeric data, while a non-clustered index is used for text-based data
Answer: A
18.What is the difference between a synchronous and asynchronous commit in a database?
A. A synchronous commit requires the transaction to be committed to the primary database and all replicas before the transaction is considered complete, while an asynchronous commit only requires the transaction to be committed to the primary database
B. A synchronous commit only requires the transaction to be committed to the primary database, while an asynchronous commit requires the transaction to be committed to all replicas
C. A synchronous commit and an asynchronous commit are the same thing
D. A synchronous commit and an asynchronous commit are used for different types of transactions
Answer: A
19.What is the difference between a logical and physical backup in a database?
A. A logical backup backs up the logical data structures of a database, while a physical backup backs up the physical data structures of a database
B. A logical backup backs up the physical data structures of a database, while a physical backup backs up the logical data structures of a database
C. A logical backup is a backup of the transaction log, while a physical backup is a backup of the data files
D. A logical backup and a physical backup are the same thing
Answer: A
20.What is the difference between a hot and cold backup in a database?
A. A hot backup is performed while the database is still running, while a cold backup is performed while the database is offline
B. A hot backup is a backup of the transaction log, while a cold backup is a backup of the data files
C. A hot backup and a cold backup are the same thing
D. A hot backup is performed automatically by the database, while a cold backup must be initiated by the user
Answer: A
21.What is the difference between a full and incremental backup in a database?
A. A full backup backs up all of the data in a database, while an incremental backup only backs up the data that has changed since the last backup
B. An incremental backup backs up all of the data in a database, while a full backup only backs up the data that has changed since the last backup
C. A full backup is a backup of the transaction log, while an incremental backup is a backup of the data files
D. A full backup and an incremental backup are the same thing
Answer: A
22.What is the difference between a point-in-time and point-to-point recovery in a database?
A. A point-in-time recovery allows you to restore a database to a specific point in time, while a point-to-point recovery allows you to restore a database from one server to another
B. A point-in-time recovery allows you to restore a database from one server to another, while a point-to-point recovery allows you to restore a database to a specific point in time
C. A point-in-time recovery and a point-to-point recovery are the same thing
D. A point-in-time recovery allows you to restore a database from a backup, while a point-to-point recovery allows you to restore a database from a snapshot
Answer: A
23.What is the difference between a local and global temporary table in a database?
A. A local temporary table is only visible to the current session, while a global temporary table is visible to all sessions
B. A global temporary table is only visible to the current session, while a local temporary table is visible to all sessions
C. A local temporary table is stored on disk, while a global temporary table is stored in memory
D. A local temporary table and a global temporary table are the same thing
Answer: A
24.What is a columnstore index in Azure SQL Database?
A. An index that stores data in columnar format for improved query performance
B. An index that stores data in row format for improved query performance
C. An index that stores data in both columnar and row formats
D. An index that stores data in a distributed fashion across multiple servers
Answer: A
25.What is a data-tier application in Azure SQL Database?
A. A packaged database containing schema and data that can be deployed to a target server
B. A package of tools used for managing Azure SQL Database instances
C. A set of rules used for controlling access to Azure SQL Database instances
D. A mechanism for managing backups and restores in Azure SQL Database
Answer: A
26.What is the purpose of the Azure SQL Database elastic pool ?
A. To allow for cost savings by sharing resources across multiple databases
B. To provide a dedicated set of resources for each database
C. To allow for better performance by increasing the resources available to each database
D. To provide automatic failover between multiple databases
Answer: A
27.What is the purpose of the Azure SQL Database Hyperscale service tier?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed SQL database with scalable storage and compute
Answer: D
28.What is the purpose of the Azure SQL Database Managed Instance service?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server with nearly 100% feature compatibility
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed SQL database with scalable storage and compute
Answer: B
29.What is the purpose of the Azure SQL Database Business Critical service tier?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server with nearly 100% feature compatibility and high availability
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed SQL database with scalable storage and compute
Answer: B
30.What is the purpose of the Azure SQL Database General Purpose service tier?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server with a balance of cost and performance
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed SQL database with scalable storage and compute
Answer: B
31.What is the purpose of the Azure SQL Database Basic service tier?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server with basic features
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed SQL database with limited compute and storage resources
Answer: D
32.What is the purpose of the Azure SQL Database Premium service tier?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server with high performance and scalability
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed SQL database with limited compute and storage resources
Answer: B
33.What is the purpose of the Azure SQL Database Dev/Test service tier?
A. To provide a distributed file system in the cloud
B. To provide a cloud-based version of Microsoft SQL Server with limited features for development and testing
C. To provide a distributed NoSQL database in the cloud
D. To provide a distributed SQL database with limited compute and storage resources for development and testing
Answer: D
34.What is the purpose of Azure SQL Database Data Sync?
A. To synchronize data between on-premises and cloud databases
B. To synchronize data between multiple cloud databases
C. To synchronize data between databases in different regions
D. To synchronize data between databases in different subscriptions
Answer: B
35.What is the purpose of Azure SQL Database Always On availability groups?
A. To provide automatic failover between multiple databases
B. To provide a distributed file system in the cloud
C. To provide a cloud-based version of Microsoft SQL Server with high availability
D. To provide a distributed NoSQL database in the cloud
Answer: C
36.What is the purpose of Azure SQL Database transparent data encryption?
A. To encrypt data at rest in the database
B. To encrypt data in transit between the client and the database
C. To encrypt data in transit between the database and other Azure services
D. To encrypt data in transit between the database and on-premises systems
Answer: A
37.What is the purpose of Azure SQL Database firewall rules?
A. To control access to Azure SQL Database based on IP address
B. To control access to Azure SQL Database based on user account
C. To control access to Azure SQL Database based on database schema
D. To control access to Azure SQL Database based on database role
Answer: A
38.What is the purpose of Azure SQL Database auditing?
A. To track changes to the database schema and data
B. To track performance metrics for the database
C. To track security-related events for the database
D. To track user activity for the database
Answer: C
39.What is the purpose of Azure SQL Database threat detection?
A. To identify potential security threats in real-time
B. To monitor database performance metrics
C. To monitor user activity in the database
D. To monitor database backups and restores
Answer: A
40.What is the purpose of Azure SQL Database automatic tuning?
A. To automatically optimize query performance for the database
B. To automatically manage database backups and restores
C. To automatically manage database security settings
D. To automatically manage database schema changes
Answer: A
=============================xxx========================================
Comments
Post a Comment