HomeMicrosoft Exams PracticeDP-203 Exam Questions and Answers (P4) DP-203 Exam Questions and Answers (P4) Welcome to your DP-203 Exam Questions and Answers (Part 4) Please, provide your Full Name and Email to get started! Please, enter your Full Name Please, enter your Email 1. ........................... provides you with personalized messages that provide information on best practices to optimize the setup of your Azure services.Azure AssistantAzure AssessmentAzure Advisor2. ............... tables are ideal for small star-schema dimension tables.Hash-distributedRound-robinReplicated3. The Stream Analytics windowing functions are used in .............. clause.WHEREORDER BYUSINGGroup By4. Which Integration runtime in Azure Data Factory can be provisioned in either public network or private network.Azure integration runtimeAzure-SSIS integration runtimeSelf-hosted integration runtime5. Which Index Type offers the highest level of data compression?HeapColumnStoreNon-clustered indexRowstore6. ............. is an open-source platform that's used to compose data pipelines. It offers message queue functionality, which allows users to publish or subscribe to real-time data streams.KafkaHBaseStorm7. What Transact-SQL function is used to perform a HyperLogLog function?COUNT_DISTINCT_APPROXAPPROX_DISTINCT_COUNTAPPROX_COUNT_DISTINCTDISTINCT_COUNT_APPROX8. Azure HDInsight is a high-cost cloud solution that provides technologies to help you ingest, process, and analyze big data.TrueFalse9. A company manages several on-premises Microsoft SQL Server databases. You need to migrate the databases to Microsoft Azure by using a backup process of Microsoft SQL Server. Which data technology should you use?Azure SQL Database elastic poolsAzure SQL Database HyperscaleAzure SQL Data WarehouseAzure SQL Database Managed Instance10. In what language can the Azure Synapse Apache Spark to Synapse SQL connector be used?ScalaSQLPythonC#11. ............. is a distributed real-time streaming analytics solution.HBaseStormKafka12. Which ALTER DATABASE statement parameter allows a dedicated SQL pool to scale?AlertChangeModifyScale13. In Azure Blob Storage, Data in the archive access tier is stored online.FalseTrue14. .............................. provide a programmatic experience for monitoring the Azure Synapse Analytics SQL pool activity by using the Transact-SQL languageDynamic SQL ViewsStatic Management ViewsDynamic Management Views15. ............. is a NoSQL database built on Hadoop. It's commonly used for search engines, and offers automatic failover.KafkaHBaseStorm16. In Azure Synapse Analytics SQL pools, All logins to your data warehouse are logged tosys.dm_pdw_exec_sessionssys.dm_pdw_dms_workerssys.dm_pdw_exec_requests17. To make a Hopping window the same as a Tumbling window, specify ...................The hop size to be smaller than the window size.The hop size to be not equal the window size.The hop size to be the same as the window size.The hop size to be greater than the window size.18. Stream Analytics supports Azure Blob storage and Azure SQL Database as the storage layer for Reference DataFalseTrue19. In Azure Blob Storage, the ...................... is optimized for storing data that is rarely accessed and stored for at least 180 days with flexible latency requirements, on the order of hours.Hot TierCool TierArchive Tier20. You are the data engineer for your company. An application uses a NoSQL database to store data. The database uses the key-value and wide-column NoSQL database type. Developers need to access data in the database using an API. You need to determine which API to use for the database model and type? Table API MongoDB API Gremlin API Cassandra API21. Which language can be used to define Spark job definitions?T-SQLScalaPythonBySpark22. ...................... is a cross-platform tool to connect and query on-premise and cloud data platforms on windows, macOS, and Linux.SQL Management StudioAzure Data StudioDAX Studio23. CETAS stands forCreate External Tables As SelectCreate External Tables As InsertCreate External Tables As Sort24. In Azure Blob Storage, the ...................... is optimized for storing data that is accessed frequentlyHot TierArchive TierCool Tier25. Dynamic Management Views (DMV) only contains ............ rows of data.5,00010,00020,00015,00026. Only CLUSTERED COLUMNSTORE INDEX is supported by materialized view.TrueFalse27. In this example, if LOCATION='/webdata/', a serverless SQL pool query, will return rows from mydata.txt, mydata2.txt and mydata3.txtmydata.txtmydata.txt and mydata2.txtmydata.txt and _hidden.txt28. ..................... is a finite data set that is static or slowly changing in nature, used to perform a lookup or to augment your data streams.Reference dataAnalytics dataStream data29. In Azure Blob Storage, the ...................... is optimized for storing data that is infrequently accessed and stored for at least 30 days.Archive TierCool TierHot Tier30. In Azure Synapse Analytics SQL pools, All queries executed on SQL pool are logged tosys.dm_pdw_exec_requestssys.dm_pdw_exec_sessionssys.dm_pwd_exec_connections31. Azure Advisor recommendations are not freeTrueFalse32. White space in column name is supported for Parquet filesTrueFalse33. Which Dynamic Management View allows you to monitor data movement in the dedicated SQL poolsys.dm_pdw_exec_requestsDBCC PDW_SHOWEXECUTIONPLANsys.dm_pdw_dms_workers34. How do column statistics improve query performance?By keeping track of which columns are being queried.By keeping track of how much data exists between ranges in columns.By caching column values for queries.35. Azure Advisor recommendations are checked every ............. hours486122436. APPROX_COUNT_DISTINCT returns a result with a ........... accuracy of true cardinality on average.5%10%3%2%37. Which workload management feature influences the order in which a request gets access to resources?Workload importanceWorkload isolationWorkload classification38. You need to output files from Azure Data Factory. Which file format should you use for columnar formatTXTGIZPParquetAvro39. What Transact-SQL function extract a scalar value from a JSON string?JSON_EXTRACTISJSONJSON_VALUEJSON_QUERY40. Azure Data Factory supports the following file formats: Parquet GIZP Avro TXT Binary41. Integration runtimes can be created in the Azure Data Factory UX via the ........................Management hubMonitor hubDevelop hub42. You have an Azure Storage account and a data warehouse in Azure Synapse Analytics in the UK South region. You need to copy blob data from the storage account to the data warehouse by using Azure Data Factory. The solution must ensure that the data remains in the UK South region at all times, and minimize administrative effort. Which type of integration runtime should you use?Self-hosted integration runtimeAzure-SSIS integration runtimeAzure integration runtime43. You have an Azure Stream Analytics job that receives clickstream data from an Azure event hub. You need to define a query in the Stream Analytics job. The query must count the number of clicks within each 10-second window based on the country of a visitor, and ensure that each click is NOT counted more than once. How should you define the Query?SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, TumblingWindow(second, 10)SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SlidingWindow(second, 10)SELECT Country, Avg(*) AS Average FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, HoppingWindow(second, 10, 2)SELECT Country, Count(*) AS Count FROM ClickStream TIMESTAMP BY CreatedAt GROUP BY Country, SessionWindow(second, 5, 10)44. Which Integration runtime in Azure Data Factory is capable of Running copy activity between a cloud data stores and a data store in private network.Self-hosted integration runtimeAzure-SSIS integration runtimeAzure integration runtime12 out of 11Are you sure, you would like to submit your responses on DP-203 Exam Questions and Answers (Part 4) and view your results? Time is Up! Related