1.
A company is designing a hybrid solution to synchronize data and on-premises Microsoft SQL Server database to Azure SQL Database. You must perform an assessment of databases to determine whether data will move without compatibility issues. You need to perform the assessment. Which tool should you use?
2.
.................... is a cloud-based data platform that brings together enterprise data warehousing and Big Data analytics.
3.
In Azure Synapse Analytics, To balance the parallel processing in distrusted table, select a distribution column that:
4.
.................. provides the fastest query performance for small tables.
5.
Which T-SQL Statement loads data directly from Azure Storage and inserts it into a table within the SQL Pool??
6.
.................. can deliver the highest query performance for joins and aggregations on large tables.
7.
A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization. Customer organizations have peak usage at different periods during the year. you need to implement the Azure SQL Database elastic pool to minimize cost. Which option or options should you configure?
8.
Which Statements are correct about the Fact Table
9.
Processing skew means the data is not distributed evenly across the distributions
10.
A distributed table appears as a single table, but the rows are actually stored across ............ distributions.
11.
In Azure Synapse, Which workload influences the order in which a request gets access to resources?
12.
In Azure Synapse, When a table is created, by default the data structure has no indexes and is called a .........
13.
.................. is the default distribution created for a table and delivers fast performance when used for loading data.
14.
Which Stream Analytics window group events that arrive at similar times, filtering out periods of time where there is no data.
15.
A quick way to check for data skew is to use ...............
16.
All Stream Analytics windowing operations output results at the ............... of the window.
17.
Which Stream Analytics window groups events that have the same timestamp, and you can apply this window by adding System.Timestamp() to the GROUP BY clause.
18.
Azure SQL Database supports structures such as relational data and unstructured formats such as spatial and XML data
19.
In Azure Data Factory, Which transformation is used to load data into a data store or compute resource?
20.
Which Statements are not correct about the Dimension Table
21.
Azure Event Hubs doesn't provide big-data streaming services
22.
Which Stream Analytics window hop forward in time by a fixed period, and can overlap and be emitted more often than the window size.
23.
In Synapse Analytics, which distribution provides good read performance for a large table
24.
What is the difference between a star schema and a snowflake schema?
25.
While there are many ways to classify data warehousing workloads, the simplest and most common classification is
26.
In Synapse Analytics, when first exploring dedicated SQL Pools for loading data, it's better to
27.
You are evaluating data storage solutions to support a new application. You need to recommend a data storage solution that represents data by using nodes and relationships in graph structures. Which data storage solution should you recommend?
28.
Which statements describe the Round-robin distributed tables?
29.
In Azure Data Factory, Schedule trigger supports Retry capability, and Concurrency.
30.
A company plans to use Azure SQL Database to support a mission-critical application. The application must be highly available without performance degradation during maintenance windows. You need to implement the solution. Which three technologies should you implement?
31.
A ........................... routes data rows to different streams based on matching conditions.
32.
When you choose a distribution column, you can use .................. to re-create the table with a different distribution column.
33.
Data skew means that some distributions take longer than others when running parallel queries
34.
Materialized views are supported in by serverless SQL pools.
35.
In Synapse Analytics Studio, you can access the data flows from the Integrate hub.
36.
Which Stream Analytics window used to segment a data stream into distinct time segments and perform a function against them, and it repeats, do not overlap, and an event cannot belong to more than one window
37.
In Azure Data Factory, Tumbling window trigger supports any-to-many relationships. Multiple triggers can kick off a single pipeline. A single trigger can kick off multiple pipelines.
38.
Azure Synapse Analytics uses the .................... approach for bulk data.
39.
When data is loaded into Synapse Analytics dedicated SQL pools, the datasets are broken up and dispersed among the compute nodes for processing, and then written to a decoupled and scalable storage layer. This action is termed .......................
40.
In Azure Synapse, Which workload assigns maximum and minimum usage values for varying resources under load.
41.
In Synapse, you have foreign keys and unique value constraints like you do in SQL Server.
42.
A ............................. is a set of normalized tables for a single business entity.
43.
Which statements describe the Hash-distributed tables?
44.
Which Stream Analytics window output events only for points in time when the content of the window actually changes, can overlap and events can belong to more than one window.
Are you sure, you would like to submit your responses on DP-203 Exam Questions and Answers (Part 3) and view your results?
