Download Data Engineering on Microsoft Azure (beta).PremiumDmps.DP-203.2021-07-14.4e.60q.vcex

Download Exam

File Info

Exam Data Engineering on Microsoft Azure (beta)
Number DP-203
File Name Data Engineering on Microsoft Azure (beta).PremiumDmps.DP-203.2021-07-14.4e.60q.vcex
Size 5.17 Mb
Posted July 14, 2021
Downloads 4

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAM_HUB

Discount: 20%

 
 



Demo Questions

Question 1
You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. 
What should you create? 

  • A: a table that has an IDENTITY property
  • B: a system-versioned temporal table
  • C: a user-defined SEQUENCE object
  • D: a table that has a FOREIGN KEY constraint



Question 2
You need to ensure that the Twitter feed data can be analyzed in the dedicated SQL pool. The solution must meet the customer sentiment analytic requirements.  
Which three Transact-SQL DDL commands should you run in sequence? 
To answer, move the appropriate commands from the list of commands to the answer area and arrange them in the correct order.  
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select. 
 




Question 3
You need to design the partitions for the product sales transactions. The solution must meet the sales transaction dataset requirements.  
What should you include in the solution? To answer, select the appropriate options in the answer area.  
NOTE: Each correct selection is worth one point. 




Question 4
You are designing a fact table named FactPurchase in an Azure Synapse Analytics dedicated SQL pool. The table contains purchases from suppliers for a retail store. FactPurchase will contain the following columns.  

   
  
FactPurchase will have 1 million rows of data added daily and will contain three years of data.  
Transact-SQL queries similar to the following query will be executed daily.  
SELECT  
  SupplierKey, StockItemKey, COUNT(*)  
FROM FactPurchase  
WHERE DateKey >= 20210101  
  AND DateKey <= 20210131  
GROUP By SupplierKey, StockItemKey  
Which table distribution will minimize query times?

  • A: replicated
  • B: hash-distributed on PurchaseKey
  • C: round-robin
  • D: hash-distributed on DateKey



Question 5
You have a table in an Azure Synapse Analytics dedicated SQL pool. The table was created by using the following Transact-SQL statement.  

   
  
You need to alter the table to meet the following requirements: 
Ensure that users can identify the current manager of employees.  
Support creating an employee reporting hierarchy for your entire company.   
Provide fast lookup of the managers’ attributes such as name and job title.  
Which column should you add to the table?

  • A: [ManagerEmployeeID] [int] NULL
  • B: [ManagerEmployeeID] [smallint] NULL
  • C: [ManagerEmployeeKey] [int] NULL
  • D: [ManagerName] [varchar](200) NULL



Question 6
You have an Azure Synapse workspace named MyWorkspace that contains an Apache Spark database named mytestdb.  
You run the following command in an Azure Synapse Analytics Spark pool in MyWorkspace.  
CREATE TABLE mytestdb.myParquetTable(  
  EmployeeID int,  
  EmployeeName string,  
  EmployeeStartDate date)  
USING Parquet  
You then use Spark to insert a row into mytestdb.myParquetTable. The row contains the following data.  

   
  
One minute later, you execute the following query from a serverless SQL pool in MyWorkspace.  
SELECT EmployeeID  
FROM mytestdb.dbo.myParquetTable  
WHERE name = 'Alice';  
What will be returned by the query?

  • A: 24
  • B: an error
  • C: a null value



Question 7
You have files and folders in Azure Data Lake Storage Gen2 for an Azure Synapse workspace as shown in the following exhibit.  

   
  
You create an external table named ExtTable that has LOCATION='/topfolder/'.  
When you query ExtTable by using an Azure Synapse Analytics serverless SQL pool, which files are returned?

  • A: File2.csv and File3.csv only
  • B: File1.csv and File4.csv only
  • C: File1.csv, File2.csv, File3.csv, and File4.csv
  • D: File1.csv only



Question 8
You are designing the folder structure for an Azure Data Lake Storage Gen2 container.  
Users will query data by using a variety of services including Azure Databricks and Azure Synapse Analytics serverless SQL pools. The data will be secured by subject area. Most queries will include data from the current year or current month.  
Which folder structure should you recommend to support fast queries and simplified folder security?

  • A: /{SubjectArea}/{DataSource}/{DD}/{MM}/{}{YYYY}/{FileData}_{YYYY}_{MM}_{DD}.csv
  • B: /{DD}/{MM}/{YYYY}/{SubjectArea}/{DataSource}/{FileData}_{YYYY}_{MM}_{DD}.csv
  • C: /{YYYY}/{MM}/{DD}/{SubjectArea}/{DataSource}/{FileData}_{YYYY}_{MM}_{DD}.csv
  • D: /{SubjectArea}/{DataSource}/{YYYY}/{MM}/{DD}/{FileData}_{}{YYYY}_{MM}_{DD}.csv



Question 9
You need to design an Azure Synapse Analytics dedicated SQL pool that meets the following requirements: 
Can return an employee record from a given point in time.  
Maintains the latest employee information.   
Minimizes query complexity.  
How should you model the employee data?

  • A: as a temporal table
  • B: as a SQL graph table
  • C: as a degenerate dimension table
  • D: as a Type 2 slowly changing dimension (SCD) table



Question 10
You have an enterprise-wide Azure Data Lake Storage Gen2 account. The data lake is accessible only through an Azure virtual network named VNET1.  
You are building a SQL pool in Azure Synapse that will use data from the data lake.  
Your company has a sales team. All the members of the sales team are in an Azure Active Directory group named Sales. POSIX controls are used to assign the Sales group access to the files in the data lake.  
You plan to load data to the SQL pool every hour.  
You need to ensure that the SQL pool can load the sales data from the data lake.  
Which three actions should you perform? Each correct answer presents part of the solution.  
NOTE: Each area selection is worth one point.

  • A: Add the managed identity to the Sales group.
  • B: Use the managed identity as the credentials for the data load process.
  • C: Create a shared access signature (SAS).
  • D: Add your Azure Active Directory (Azure AD) account to the Sales group.
  • E: Use the snared access signature (SAS) as the credentials for the data load process.
  • F: Create a managed identity.






CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset