1.
Azure portal is the best place to centrally work with all Azure Synapse Analytics capabilities
2.
Which resource model, the Azure Synapse SQL offers?
3.
A .............. is a core component of Business Intelligence (BI) solutions that provides a central repository of data stored in relational tables.
4.
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.
5.
............................. is a mature modeling approach widely adopted by relational data warehouses. It requires modelers to classify their model tables as either dimension or fact.
6.
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?
7.
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.
8.
Which Azure Storage option is the cheapest way to store data in Azure?
9.
In Azure Blob Storage, The ............. access tier can only be set at the blob level.
10.
............ is where you can develop TSQL scripts and notebooks in Azure Synapse Analytics
11.
Descriptive Analytics helps answer questions about
12.
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?
13.
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?
14.
...................................... 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.
15.
To open Azure Synapse Studio, Go to the ............................... and sign in to your workspace.
16.
In Azure Blob Storage, The .............. doesn't support all redundancy options.
17.
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?
18.
Diagnostic Analytics helps answer questions about
19.
The first step in deploying Azure Synapse Analytics is to deploy
20.
Which resource model in Azure Synapse Analytics is the most effective to use the resources when required
21.
A .............. allows you to interact with data without the need to understand how the data is formatted, structured, or what is its data type
22.
Predictive Analytics helps answer questions about
23.
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?
24.
What should you do to improve high availability of the real-time data processing solution?
25.
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?
26.
In Azure Blob Storage, The hot access tier has ..............
27.
In Azure Blob Storage, Data in the ........................ access tier is stored offline.
28.
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.
29.
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?
30.
You have an Azure data factory. You need to examine the pipeline failures from the last 60 days. What should you use?
31.
Which options you can do to query Blob store?
32.
In Azure Blob Storage, Only the ......... and ............. access tiers can be set at the account level.
33.
In Azure Blob Storage, you can directly read or download a blob in Archive access.
34.
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?
35.
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?
36.
Prescriptive Analytics helps answer questions about
37.
By default, tables in dedicated SQL pool are created as
38.
........... 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.
39.
If you create a storage account as a Blob store, you can query the data directly
40.
The Data Lake is primary storage location for source files that can be used within the various analytical engines
41.
In Azure Synapse Analytics dedicated SQL pool, Transparent Data Encryption encrypts the storage of an entire database by using a symmetric key called the ..............................
42.
.............. provisions and set up data platform technologies that are on-premises and in the cloud
43.
In Azure Synapse Analytics, the ............................ improve query performance on large fact tables.
44.
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 ..................
45.
Which Integration runtime type should you recommend to import the daily inventory data from the SQL server to Azure Data Lake Storage?
46.
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?
47.
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?
48.
............................. 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.
49.
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?
50.
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?
51.
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?
52.
In Azure SQL, the virtual network rule applies at the server-level as well as at the database-level.
Are you sure, you would like to submit your responses on DP-203 Exam Questions and Answers (Part 1) and view your results?
