HomeMicrosoft Exams PracticeDP-203 Exam Questions and Answers (P9) DP-203 Exam Questions and Answers (P9) Welcome to your DP-203 Exam Questions and Answers (Part 9) Please, provide your Full Name and Email to get started! Please, enter your Full Name Please, enter your Email 1. Which Window type segment a data stream into a contiguous series of fixed-size, non-overlapping time segments and operate against them?SessionSlidingSnapshotTumblingHopping2. A company is designing a solution that uses Azure Databricks. The solution must be resilient to regional Azure datacenter outages. You need to recommend the redundancy type for the solution. What should you recommend?Locally-redundant storageZone-redundant storageGeo-redundant storage3. Which Window type generate events for points in time when the content of the window actually changed?SnapshotSlidingHoppingSessionTumbling4. Which role works with Azure Cognitive Services, Cognitive Search, and the Bot Framework?An AI engineerA data engineerA data scientist5. ........................... provides an ingestion point for data streaming in an event processing solution that uses static data as a source.Azure Blob StorageAzure Date LakeAzure Event HubsAzure IoT Hub6. You are designing the security for an Azure SQL database. You have an Azure Active Directory (Azure AD) group named Group1. You need to recommend a solution to provide Group1 with read access to the database only. What should you include in the recommendation?Shared access signatureContained database userRBAC role7. Semi-structured data is also referred to as non-relational or NoSQL data.FalseTrue8. ELT stands forEnhance, load, and transformExtract, load, and transferExtract, load, and transform9. ETL stands forEnhance, transform, and loadExtract, transform, and loadExtract, transfer, and load10. Which Window type groups events by identical timestamp values?TumblingSlidingHoppingSessionSnapshot11. An entity that reads data from the Event Hubs is called a ..................PublisherConsumer or a SupplierConsumer or a subscriber12. If you don't specify a pricing tier for Azure Event Hubs, the default will be ........................DedicatedStandardBasic13. An entity that sends data to the Event Hubs is called a ..................PublisherSubscriberSupplierConsumer14. A disadvantage of the ETL approach is that .................The extract stage can take a long timeThe transformation stage can take a long timeThe load stage can take a long time15. What is the maximum size for a single publication (individual or batch) that is allowed by Azure Event Hub?2 MB1 MB3 MB1 KB16. Which of the following services is a valid output for an Azure Stream Analytics job?Blob storageAzure Event HubsAzure Cosmos DB17. Which Azure data platform is commonly used to process data in an ELT framework?Azure Data Lake StorageAzure Data FactoryAzure Databricks18. Which of the following technologies typically provide an ingestion point for data streaming in an event processing solution that uses streaming data as a source?Azure Blob storageAzure Date LakeAzure IoT Hub19. You have a line-of-business (LOB) app that reads files from and writes files to Azure Blob storage in an Azure Storage account. You need to recommend changes to the storage account to meet the following requirements: Provide the highest possible availability. Minimize potential data loss. Which three changes should you recommend? From the storage account, enable read-access geo-redundancy storage (RA-GRS). From the storage account, enable soft deletes. From the storage account, enable a time-based retention policy. From the app, query the LastSyncTime of the storage account. From the app, add retry logic to the storage account interactions.20. You have an on-premises MySQL database that is 800 GB in size. You need to migrate a MySQL database to Azure Database for MySQL. You must minimize service interruption to live sites or applications that use the database. What should you recommend?Dump and restoreImport and exportAzure Database Migration Service21. Which Window type model scheduled overlapping windows, jumping forward in time by a fixed period?SlidingHoppingTumblingSnapshotSession22. Which Window type cluster together events that arrive at similar times, filtering out periods of time where there is no data?TumblingSnapshotSessionHoppingSliding23. Scalability in cloud systems is complicated and time-consumingFalseTrue24. You are developing a solution that performs real-time analysis of IoT data in the cloud. The solution must remain available during Azure service updates. You need to recommend a solution. Which two actions should you recommend? Monitor jobs in the primary region for failure. Monitor jobs in both regions for failure. Deploy an Azure Stream Analytics job to each region in a paired region. Deploy an Azure Stream Analytics job to one region in a paired region.25. You plan to implement an Azure Data Lake Gen2 storage account. You need to ensure that the data lake will remain available if a data center fails in the primary Azure region. The solution must minimize costs. Which type of replication should you use for the storage account?locally-redundant storagegeo-redundant storagegeo-zone-redundant storagezone-redundant storage26. Where you can view your Event Hub activity?Azure Data FactoryAzure PortalAzure Data Studio27. Which of the following services is a valid input for an Azure Stream Analytics job? Azure Cosmos DB Blob storage Azure Event Hubs28. ..................... is data that adheres to a strict schema, so all of the data has the same fields or properties.Unstructured dataSemi-structured dataStructured data29. Non-Structured data is straightforward in that it's easy to enter, query, and analyzeFalseTrue30. To deploy Azure Event Hubs, you must configure an Event Hubs namespace, and then configure the Event Hub itselfTrueFalse31. A company is developing a solution to manage inventory data for a group of automotive repair shops. The solution will use Azure Synapse Analytics as the data store. Shops will upload data every 10 days. Data corruption checks must run each time data is uploaded. If corruption is detected, the corrupted data must be removed. You need to ensure that upload processes and data corruption checks do not impact reporting and analytics processes that use the data warehouse. Which solution should you do?Create a user-defined restore point before data is uploaded. Delete the restore point after data corruption checks complete.Configure database-level auditing in Azure Synapse Analytics and set retention to 10 days.Insert data from shops and perform the data corruption check in a transaction. Rollback transfer if corruption is detected.32. Below is a list of key benefits of using Azure Stream Analytics to process streaming data. Which of the following statements is incorrect?The ability to write and test transformation queries in the Azure portalIntegration with Azure Blob storageBeing able to rapidly deploy queries into production by creating and starting an Azure Stream Analytics job33. A company has many applications. Each application is supported by separate on-premises databases. You must migrate the databases to Azure SQL Database. You have to organize databases into groups based on database usage, and Define the maximum resource limit available for each group of databases. You need to recommend technologies to scale the databases to support expected increases in demand. What should you recommend?Read scale-outElastic poolsDatabase shardingManaged instances34. You have an Azure Data Lake Storage account that has a virtual network service endpoint configured. You plan to use Azure Data Factory to extract data from the Data Lake Storage account. The data will then be loaded to a data warehouse in Azure Synapse Analytics by using PolyBase. Which authentication method should you use to access Data Lake Storage?Service principal authenticationShared access key authenticationManaged identity authentication35. ................. is a platform-as-a-service (PaaS) event processing engine.Azure Storage ExplorerAzure Date LakeAzure Data FactoryAzure Stream Analytics36. By default, how many partitions will a new Event Hub have?142337. Which tool provides a platform for visualizing and analyzing aggregated data in a near-real-time analytics pipeline?SSMSAzure Data StudioAzure Storage ExplorerPower BI38. ........................... is a big data streaming platform and event ingestion service, which you can use to feed events from event producers into Azure Stream Analytics.Azure Blob storageAzure Date LakeAzure Event Hubs39. A company is developing a mission-critical line of business app that uses Azure SQL Database Managed Instance. You must design a disaster recovery strategy for the solution/ You need to ensure that the database automatically recovers when full or partial loss of the Azure SQL Database service occurs in the primary region. What should you recommend?Failover-groupActive geo-replicationSQL Replication40. You have an Azure Data Lake Storage Gen2 account named adls1 that is protected by a virtual network. You are designing a SQL pool in Azure Synapse that will use adls1 as a source. What should you use to authenticate to adls1?Azure Active Directory UserShared access signatureManaged identity41. A company is evaluating data storage solutions. You need to recommend a data storage solution that meets Minimize costs for storing blob objects, Optimize access for data that is infrequently accessed, Data must be stored for at least 30 days, and Data availability must be at least 99 percent. What should you recommend?PremiumColdHotArchive42. You are designing an Azure Databricks cluster that runs user-defined local processes. You need to recommend a cluster configuration that Minimize query latency, Reduce overall costs without compromising other requirements, and Maximize the number of users that can run queries on the cluster at the same time. Which cluster type should you recommend?High Concurrency with AutoscalingStandard with Auto TerminationStandard with AutoscalingHigh Concurrency with Auto Termination43. .................... is flexible and can express complex data easily. However, it tends to be more verbose making it larger to store, process, or pass over a network.JSONXMLYAML44. ..................... is less organized than structured data, and is not stored in a relational format, as the fields do not neatly fit into tables, rows, and columns.Semi-structured dataNon-structured data12 out of 11Are you sure, you would like to submit your responses on DP-203 Exam Questions and Answers (Part 9) and view your results? Time is Up! Related