207 Exam Questions for DP-201 Updated Versions With Test Engine
Pass DP-201 Exam with Updated DP-201 Exam Dumps PDF 2022
Career Opportunities and Salary Potential
Completing the Microsoft DP-201 exam and obtaining the Microsoft Certified: Azure Data Engineer Associate certification provides the individuals with numerous prospects. First of all, this certificate prepares the professionals for a career of an Azure Data Engineer. However, the holders of this associate-level option can also explore other positions. The job titles that will also become available to you after getting certified include an Azure Cloud Engineer, a Cloud Solutions Systems Engineer, a Software Engineer, a DevOps Engineer, a Senior DevOps Engineer, among others. According to PayScale, an Azure Data Engineer with 1-4 years of experience earns an average of $90,496 per year, but the same professional with 5-9 years of experience can get about $98,686 per annum.
How to study the DP-201 Exam
DumpsMaterials expert team recommends you to prepare some notes on these topics along with it don’t forget to practice Microsoft DP-201 Exam dumps which been written by our expert team, Both these will help you a lot to clear this exam with good marks.
NEW QUESTION 34
You are designing the security for a mission critical Azure SQL database named DB1. DB1 contains several columns that store Personally Identifiable Information (PII) data You need to recommend a security solution that meets the following requirements:
* Ensures that DB1 is encrypted at rest
* Ensures that data from the columns containing PII data is encrypted in transit Which security solution should you recommend for DB1 and the columns? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
DB1: Transparent Data Encryption
Azure SQL Database currently supports encryption at rest for Microsoft-managed service side and client-side encryption scenarios.
Support for server encryption is currently provided through the SQL feature called Transparent Data Encryption.
Columns: Always encrypted
Always Encrypted is a feature designed to protect sensitive data stored in Azure SQL Database or SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the database engine (SQL Database or SQL Server).
Note: Most data breaches involve the theft of critical data such as credit card numbers or personally identifiable information. Databases can be treasure troves of sensitive information. They can contain customers' personal data (like national identification numbers), confidential competitive information, and intellectual property. Lost or stolen data, especially customer data, can result in brand damage, competitive disadvantage, and serious fines--even lawsuits.
References:
https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-atrest
https://docs.microsoft.com/en-us/azure/security/fundamentals/database-security-overview
NEW QUESTION 35
You need to design a backup solution for the processed customer data.
What should you include in the design?
- A. Geo-Replication
- B. AzCopy
- C. Geo-Redundancy
- D. AdlCopy
Answer: C
Explanation:
Scenario: All data must be backed up in case disaster recovery is required.
Geo-redundant storage (GRS) is designed to provide at least 99.99999999999999% (16 9's) durability of objects over a given year by replicating your data to a secondary region that is hundreds of miles away from the primary region. If your storage account has GRS enabled, then your data is durable even in the case of a complete regional outage or a disaster in which the primary region isn't recoverable.
Reference:
https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy-grs
NEW QUESTION 36
You design data engineering solutions for a company.
You must integrate on-premises SQL Server data into an Azure solution that performs Extract-Transform-Load (ETL) operations have the following requirements:
* Develop a pipeline that can integrate data and run notebooks.
* Develop notebooks to transform the data.
* Load the data into a massively parallel processing database for later analysis.
You need to recommend a solution.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
NEW QUESTION 37
You are designing a solution that will use Azure Databricks and Azure Data Lake Storage Gen2.
From Databricks, you need to access Data Lake Storage directly by using a service principal.
What should you include in the solution?
- A. access keys in Data Lake Storage
- B. an organizational relationship in Azure Active Directory (Azure AD)
- C. an application registration in Azure Active Directory (Azure AD)
- D. shared access signatures (SAS) in Data Lake Storage
Answer: C
Explanation:
Explanation
Create and grant permissions to service principal
If your selected the access method requires a service principal with adequate permissions, and you do not have one, follow these steps:
1. Create an Azure AD application and service principal that can access resources. Note the following properties:
* client-id: An ID that uniquely identifies the application.
* directory-id: An ID that uniquely identifies the Azure AD instance.
* service-credential: A string that the application uses to prove its identity.
2. Register the service principal, granting the correct role assignment, such as Storage Blob Data
3. Contributor, on the Azure Data Lake Storage Gen2 account.
References:
https://docs.databricks.com/data/data-sources/azure/azure-datalake-gen2.html
NEW QUESTION 38
You need to design network access to the SQL Server data.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: 8080
1433 is the default port, but we must change it as CONT_SQL3 must not communicate over the default ports.
Because port 1433 is the known standard for SQL Server, some organizations specify that the SQL Server port number should be changed to enhance security.
Box 2: SQL Server Configuration Manager
You can configure an instance of the SQL Server Database Engine to listen on a specific fixed port by using the SQL Server Configuration Manager.
References:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-speci
NEW QUESTION 39
You are designing the security for a mission critical Azure SQL database named DB1. DB1 contains several columns that store Personally Identifiable Information (PII) data You need to recommend a security solution that meets the following requirements:
* Ensures that DB1 is encrypted at rest
* Ensures that data from the columns containing PII data is encrypted in transit Which security solution should you recommend for DB1 and the columns? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
DB1: Transparent Data Encryption
Azure SQL Database currently supports encryption at rest for Microsoft-managed service side and client-side encryption scenarios.
Support for server encryption is currently provided through the SQL feature called Transparent Data Encryption.
Columns: Always encrypted
Always Encrypted is a feature designed to protect sensitive data stored in Azure SQL Database or SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to the database engine (SQL Database or SQL Server).
Note: Most data breaches involve the theft of critical data such as credit card numbers or personally identifiable information. Databases can be treasure troves of sensitive information. They can contain customers' personal data (like national identification numbers), confidential competitive information, and intellectual property. Lost or stolen data, especially customer data, can result in brand damage, competitive disadvantage, and serious fines--even lawsuits.
References:
https://docs.microsoft.com/en-us/azure/security/fundamentals/encryption-atrest
https://docs.microsoft.com/en-us/azure/security/fundamentals/database-security-overview
NEW QUESTION 40
You need to recommend an Azure SQL Database service tier.
What should you recommend?
- A. Standard
- B. Basic
- C. Premium
- D. Business Critical
- E. General Purpose
Answer: C
Explanation:
Explanation/Reference:
Explanation:
The data engineers must set the SQL Data Warehouse compute resources to consume 300 DWUs.
Note: There are three architectural models that are used in Azure SQL Database:
General Purpose/Standard
Business Critical/Premium
Hyperscale
Incorrect Answers:
A: Business Critical service tier is designed for the applications that require low-latency responses from the
underlying SSD storage (1-2 ms in average), fast recovery if the underlying infrastructure fails, or need to
off-load reports, analytics, and read-only queries to the free of charge readable secondary replica of the
primary database.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-service-tier-business-critical
NEW QUESTION 41
Which Azure Data Factory components should you recommend using together to import the daily inventory data from SQL to Data Lake Storage? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation:
Box 1: Self-hosted integration runtime
A self-hosted IR is capable of nunning copy activity between a cloud data stores and a data store in private network.
Scenario: Daily inventory data comes from a Microsoft SQL server located on a private network.
Box 2: Schedule trigger
Daily schedule
Box 3: Copy activity
Scenario:
Stage inventory data in Azure Data Lake Storage Gen2 before loading the data into the analytical data store. Litware wants to remove transient data from Data Lake Storage once the data is no longer in use. Files that have a modified date that is older than 14 days must be removed.
NEW QUESTION 42
The following code segment is used to create an Azure Databricks cluster.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Explanation
Box 1: Yes
Box 2: No
autotermination_minutes: Automatically terminates the cluster after it is inactive for this time in minutes. If not set, this cluster will not be automatically terminated. If specified, the threshold must be between 10 and
10000 minutes. You can also set this value to 0 to explicitly disable automatic termination.
Box 3: Yes
References:
https://docs.databricks.com/dev-tools/api/latest/clusters.html
NEW QUESTION 43
You need to design the system for notifying law enforcement officers about speeding vehicles.
How should you design the pipeline? To answer, drag the appropriate services to the correct locations. Each service may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
NEW QUESTION 44
What should you recommend using to secure sensitive customer contact information?
- A. row-level security
- B. data labels
- C. column-level security
- D. Transparent Data Encryption (TDE)
Answer: C
Explanation:
Scenario: All cloud data must be encrypted at rest and in transit.
Always Encrypted is a feature designed to protect sensitive data stored in specific database columns from access (for example, credit card numbers, national identification numbers, or data on a need to know basis). This includes database administrators or other privileged users who are authorized to access the database to perform management tasks, but have no business need to access the particular data in the encrypted columns. The data is always encrypted, which means the encrypted data is decrypted only for processing by client applications with access to the encryption key.
References:
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-security-overview To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other question on this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next sections of the exam. After you begin a new section, you cannot return to this section.
To start the case study
To display the first question on this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
NEW QUESTION 45
You need to recommend a storage solution for a sales system that will receive thousands of small files per minute. The files will be in JSON, text, and CSV formats. The files will be processed and transformed before they are loaded into a data warehouse in Azure Synapse Analytics. The files must be stored and secured in folders.
Which storage solution should you recommend?
- A. Azure SQL Database
- B. Azure Data Lake Storage Gen2
- C. Azure Blob storage
- D. Azure Cosmos DB
Answer: B
Explanation:
Azure provides several solutions for working with CSV and JSON files, depending on your needs. The primary landing place for these files is either Azure Storage or Azure Data Lake Store.1 Azure Data Lake Storage is an optimized storage for big data analytics workloads.
Incorrect Answers:
D: Azure Blob Storage containers is a general purpose object store for a wide variety of storage scenarios.
Blobs are stored in containers, which are similar to folders.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/scenarios/csv-and-json
NEW QUESTION 46
You are designing an Azure Databricks interactive cluster.
You need to ensure that the cluster meets the following requirements:
Enable auto-termination
Retain cluster configuration indefinitely after cluster termination.
What should you recommend?
- A. Start the cluster after it is terminated.
- B. Clone the cluster after it is terminated.
- C. Pin the cluster
- D. Terminate the cluster manually at process completion.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
To keep an interactive cluster configuration even after it has been terminated for more than 30 days, an administrator can pin a cluster to the cluster list.
References:
https://docs.azuredatabricks.net/user-guide/clusters/terminate.html
NEW QUESTION 47
You need to design a solution to support the storage of datasets. The solution must meet the following requirements:
Send email alerts when new datasets are added.
Control access to collections of datasets by using Azure Active Directory groups.
Support the storage of Microsoft Excel, Comma Separated Values (CSV), and zip files.
What should you include in the solution?
- A. Azure SQL Database
- B. Azure Storage
- C. Azure HDInsight
- D. Azure Cosmos DB
Answer: B
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/data-storage
NEW QUESTION 48
You need to recommend an Azure SQL Database pricing tier for Planning Assistance.
Which pricing tier should you recommend?
- A. Business critical Azure SQL Database single database
- B. General purpose Azure SQL Database single database
- C. Business critical Azure SQL Database Managed Instance
- D. General purpose Azure SQL Database Managed Instance
Answer: D
Explanation:
Explanation
Azure resource costs must be minimized where possible.
Data used for Planning Assistance must be stored in a sharded Azure SQL Database.
The SLA for Planning Assistance is 70 percent, and multiday outages are permitted.
NEW QUESTION 49
You plan to ingest streaming social media data by using Azure Stream Analytics. The data will be stored in files in Azure Data Lake Storage, and then consumed by using Azure Databricks and PolyBase in Azure Synapse Analytics.
You need to recommend a Stream Analytics data output format to ensure that the queries from Databricks and PolyBase against the files encounter the fewest possible errors. The solution must ensure that the files can be queried quickly and that the data type information is retained.
What should you recommend?
- A. CSV
- B. Avro
- C. JSON
- D. Parquet
Answer: B
Explanation:
Explanation/Reference:
Explanation:
The Avro format is great for data and message preservation.
Avro schema with its support for evolution is essential for making the data robust for streaming architectures like Kafka, and with the metadata that schema provides, you can reason on the data. Having a schema provides robustness in providing meta-data about the data stored in Avro records which are self-documenting the data.
References:
http://cloudurable.com/blog/avro/index.html
NEW QUESTION 50
......
Certification Path
The Microsoft Certified Azure Data Engineer Associate Certification include DP-200 and DP-201 exams.
DP-201 Exam Dumps - Free Demo & 365 Day Updates: https://www.dumpsmaterials.com/DP-201-real-torrent.html
