1.
In Azure Synapse Analytics dedicated SQL pool, Transparent Data Encryption encrypts the storage of an entire database by using a symmetric key called the ..............................
2.
Pipelines are a component of Azure Synapse Analytics that enables you to ingest, prepare, and serve data to other Azure Synapse Components or Azure services.
3.
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?
4.
The first step in deploying Azure Synapse Analytics is to deploy
5.
You plan to create a retail store table that will contain the address of each retail store. The table will be approximately 2 MB. Queries for retail store sales will include the retail store addresses. You need to implement the surrogate key for the retail store table. What should you create?
6.
In Azure Blob Storage, Data in the ........................ access tier is stored offline.
7.
In Azure Blob Storage, Only the ......... and ............. access tiers can be set at the account level.
8.
Azure portal is the best place to centrally work with all Azure Synapse Analytics capabilities
9.
A .............. allows you to interact with data without the need to understand how the data is formatted, structured, or what is its data type
10.
If you need to provision a data store that will store but not query data, your cheapest option is to set up a storage account as ..................
11.
You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information. What should you include in the recommendation?
12.
You develop data engineering solutions for a company. The company has on-premises Microsoft SQL Server databases at multiple locations. The company must integrate data with Microsoft Power BI and Microsoft Azure Logic Apps. The solution must avoid single points of failure during connection and transfer to the cloud. The solution must also minimize latency. You need to secure the transfer of data between on-premises databases and Microsoft Azure. What should you do?
13.
You implement an enterprise data warehouse in Azure Synapse Analytics. you need to distribute the large fact table that is 10 terabytes (TB) in size across multiple nodes to optimize performance of the table. Which technology should you use?
14.
By default, tables in dedicated SQL pool are created as
15.
Prescriptive Analytics helps answer questions about
16.
In Azure Synapse Analytics dedicated SQL pool, The .................. helps protect against the threat of malicious activity by encrypting and decrypting your data at rest. Ex: When you encrypt your database, associated backups and transaction log files are encrypted without requiring any changes to your applications.
17.
The Data Lake is primary storage location for source files that can be used within the various analytical engines
18.
You need to schedule an Azure Data Factory pipeline to execute when a new file arrives in an Azure Data Lake Storage Gen2 container. Which type of trigger should you use?
19.
A .............. is a core component of Business Intelligence (BI) solutions that provides a central repository of data stored in relational tables.
20.
Which options you can do to query Blob store?
21.
Which resource model in Azure Synapse Analytics is the most effective to use the resources when required
22.
...................................... brings together the best of SQL technologies used in enterprise data warehousing, Spark technologies used for big data, Pipelines for data integration and ETL/ELT, and deep integration with other Azure services such as Power BI, CosmosDB, and AzureML.
23.
........... attempts to draw inferences from existing data and patterns, derive conclusions based on existing knowledge bases, and then add these findings back into the knowledge base for future inferences, a self-learning feedback loop.
24.
.............. provisions and set up data platform technologies that are on-premises and in the cloud
25.
In Azure Blob Storage, The ............. access tier can only be set at the blob level.
26.
You are designing an HDInsight/Hadoop cluster solution that uses Azure Data Lake Gen1 Storage. The solution requires POSIX permissions and enables diagnostics logging for auditing. You need to recommend solutions that optimize storage. Which solution meets the goal?
27.
Which Integration runtime type should you recommend to import the daily inventory data from the SQL server to Azure Data Lake Storage?
28.
What should you do to improve high availability of the real-time data processing solution?
29.
In Azure Synapse Analytics, the ............................ improve query performance on large fact tables.
30.
Diagnostic Analytics helps answer questions about
31.
............ is where you can develop TSQL scripts and notebooks in Azure Synapse Analytics
32.
The .............. resource model reserves processing power for data stored in SQL tables and is not an ideal resource model to use for ad hoc data preparation.
33.
In Azure SQL, the virtual network rule applies at the server-level as well as at the database-level.
34.
Which resource model, the Azure Synapse SQL offers?
35.
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?
36.
You have an Azure subscription that contains a logical Microsoft SQL server named Server1. Server1 hosts an Azure Synapse Analytics SQL dedicated pool named Pool1. You need to recommend a Transparent Data Encryption (TDE) solution for Server1. What should you use to track the usage of encryption keys?
37.
Which Azure Storage option is the cheapest way to store data in Azure?
38.
Descriptive Analytics helps answer questions about
39.
To open Azure Synapse Studio, Go to the ............................... and sign in to your workspace.
40.
In Azure Blob Storage, you can directly read or download a blob in Archive access.
41.
You are developing a solution that will stream to Azure Stream Analytics. The solution will have both streaming data and reference data. Which input type should you use for the reference data?
42.
You have Customer data, including name, contact information, and loyalty number, comes from Salesforce, What should you recommend using to secure sensitive customer contact information?
43.
............................. is a distributed query system that enables you to implement data warehousing and data virtualization scenarios using standard T-SQL experiences familiar to data engineers.
44.
............................. is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact.
45.
In Azure Blob Storage, The .............. doesn't support all redundancy options.
46.
You have an Azure data factory. You need to examine the pipeline failures from the last 60 days. What should you use?
47.
You are designing an Azure Stream Analytics solution that will analyze Twitter data. You need to count the tweets in each 20-second window. The solution must ensure that each tweet is counted only once. Which Window type should you use?
48.
Predictive Analytics helps answer questions about
49.
You have a partitioned table in an Azure Synapse Analytics dedicated SQL pool. You need to design queries to maximize the benefits of partition elimination. What should you include in the Transact-SQL queries?
50.
In Azure Blob Storage, The hot access tier has ..............
51.
You are a data architect. The data engineering team needs to configure synchronization of data between an on-premises Microsoft SQL Server database to Azure SQL Database. Ad-hoc and reporting queries are being overutilized in the on-premises production instance. The synchronization process must Perform an initial data synchronization to Azure SQL Database with minimal downtime and Perform bi-directional data synchronization after initial synchronization. Which synchronization method should you use to implement this synchronization solution?
52.
If you create a storage account as a Blob store, you can query the data directly
Are you sure, you would like to submit your responses on DP-203 Exam Questions and Answers (Part 1) and view your results?
