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