Microsoft Azure Data Engineer (DP-203) Exam Dumps 2022
Microsoft Azure Data Engineer (DP-203) Exam Dumps 2022
Visit Official SkillCertPro Website :-
For a full set of 920+ questions. Go to
https://skillcertpro.com/product/microsoft-azure-data-engineer-dp-203-exam-questions/
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.
Question 1:
A company is managing several business apps that use SQL databases hosted on the Microsoft SQL Server (on-prem). As a part of the transformation project, the company is considering moving the on-prem tech stack to Microsoft Azure. What would be the most convenient way to move SQL databases (with as low migration effort as possible)? Please select the correct answer.
A. Azure SQL Database (managed instance)
B. Azure SQL Database (single database)
C. Azure Cosmos DB
D. Azure Synapse Analytics
Answer: A
Explanation:
Correct Answer: As we have to migrate several apps from on-premises and SQL databases to a fully managed cloud environment (with as low migration effort as possible), the most convenient way would be to choose SQL Database Managed Instance deployment option.
For more details, please have a look at the link:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance#database-migration
Question 2:
A company manages several on-premises Microsoft SQL Server databases. You’re hired as a data engineer to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. Which data technology should you use?
A. Azure Cosmos DB
B. Azure SQL Database (single database)
C. Azure SQL Database Managed Instance
D. Azure Synapse Analytics
Answer: C
Explanation:
Correct Answer: As we need to migrate several on-prem SQL databases, the correct answer is Azure SQL Database managed instance. For more details, please follow the link: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance#database-migration
Question 3:
A company uses Microsoft Azure SQL Database to store sensitive company data. You encrypt the data and only allow access to specified users from specified locations. You need to monitor data usage, and data copied from the system to prevent data leakage. You need to configure Azure SQL Database to email a specific user when data leakage occurs. What should you configure?
A. Add the database to a failover group
B. Azure SQL Data Sync
C. Active geo-replication
D. Enable advanced threat protection
Answer: D
Explanation:
Correct Answer: You should enable advanced threat protection. Other answers are incorrect as they address other topics such as business continuity, data replication etc. For more details, please have a look at the link:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-threat-detection
Question 4:
A good candidate for a partition key in Azure Cosmos DB should meet the following requirements:
– Be a property that has a value which does not change
– The property should have a wide range of possible values
– Spread request unit (RU) consumption and data storage evenly across all logical partitions.
A. TRUE
B. FALSE
Answer: A
Explanation:
Please have a look at the link:
https://docs.microsoft.com/en-gb/azure/cosmos-db/partitioning-overview#choose-partitionkey
Question 5:
All Azure SQL databases (single, pooled, and managed instance databases) have a default backup retention period of 7 days. You can change the backup retention period to as long as 35 days. If you need to keep the backups for longer than the maximum retention period, you can modify the backup properties to add one or more long-term retention (LTR) periods to your database.
A. TRUE
B. FALSE
Answer: A
Explanation:
For more details, please have a look at the link below:
For a full set of 920+ questions. Go to
https://skillcertpro.com/product/microsoft-azure-data-engineer-dp-203-exam-questions/
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.
Question 6:
Apache Hadoop cluster type is a good choice to optimize for Hive queries used as a batch process in Azure HDInsight
A. TRUE
B. FALSE
Answer: A
Explanation:
In Azure HDInsight, there are several cluster types and technologies that can run Apache Hive queries. For example, Interactive query, Spark, HBase and Apache Hadoop. Apache Hadoop cluster type is typically used for Hive queries as a batch process.
For more information, please have a look at the link below:
Question 7:
Azure Databricks pools reduce cluster start and auto-scaling times by maintaining a set of idle, ready-to-use instances.
A. TRUE
B. FALSE
Answer: A
Explanation:
For more details, please have a look at the link:
https://docs.microsoft.com/en-us/azure/databricks/clusters/instance-pools/
Question 8:
Azure SQL Database managed instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes.
A. TRUE
B. FALSE
Answer: A
Explanation:
For more details, please have a look at the link below:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance
Question 9:
The data engineering team manages Azure HDInsight clusters. The team spends a large amount of time creating and destroying clusters daily because most of the data pipeline process runs in minutes.
You need to implement a solution that deploys multiple HDInsight clusters with minimal effort.
What should you implement?
A. Azure Resource Manager templates
B. Azure Traffic Manager
C. Azure Databricks
D. Ambari web user interface
E. Azure HDinsight
Answer: A
Explanation:
A Resource Manager template makes it easy to create the following resources for your application in a single, coordinated operation:
HDInsight clusters and their dependent resources (such as the default storage account).
Other resources (such as Azure SQL Database to use Apache Sqoop).
In the template, you define the resources that are needed for the application. You also specify deployment parameters to input values for different environments.
The template consists of JSON and expressions that you use to construct values for your deployment.
References:
Question 10:
An application will use Microsoft Azure Cosmos DB as its data solution. The application will use the Cassandra API to support a column-based database type that uses containers to store items.
You need to provision Azure Cosmos DB. Which container name and item name should you use? Each correct answer presents part of the solutions.
NOTE: Each correct answer selection is worth one point.
A. collection
B. graph
C. rows
D. entities
E. table
Answer: C, E
Explanation:
C: Depending on the choice of the API, an Azure Cosmos item can represent either a document in a collection, a row in a table or a node/edge in a graph. The following table shows the mapping between API-specific entities to an Azure Cosmos item:
E: An Azure Cosmos container is specialized into API-specific entities as follows:
References:
https://docs.microsoft.com/en-us/azure/cosmos-db/databases-containers-items
For a full set of 920+ questions. Go to
https://skillcertpro.com/product/microsoft-azure-data-engineer-dp-203-exam-questions/
SkillCertPro offers detailed explanations to each question which helps to understand the concepts better.
It is recommended to score above 85% in SkillCertPro exams before attempting a real exam.
SkillCertPro updates exam questions every 2 weeks.
You will get life time access and life time free updates
SkillCertPro assures 100% pass guarantee in first attempt.