In this article i am gone to share Data Warehousing with Microsoft Azure Synapse Analytics Week 1 | Test prep Quiz Answer with you..

Enrol Link:  Data Warehousing with Microsoft Azure Synapse Analytics

Data Warehousing with Microsoft Azure Synapse Analytics Week 1 | Test prep Quiz Answer

Test prep Quiz Answer

Question 1)
Which of the following would be a valid reason for adding a staging area into the architecture of a modern data warehouse? Select all options that apply.

• Enable the ingestion of source systems based on different schedules
• To make data analytical available directly from the staging area
• To join data from different source systems
• To reduce contention on source systems

Question 2)
When ingesting raw data in batch from new data sources, which of the following data formats are natively supported by Synapse Analytics? Select all options that apply.

• Parquet
• Scala
• ORC
• CSV
• JSON

Question 3)
Processing data that arrives in real-time /near real-time is also referred to as streaming data processing. Azure offers purpose-built stream ingestion services such as Azure IoT Hub and Azure Event Hubs. To collect messages from these or similar services, and process them you can use which of the following features? Select all options that apply.

• Azure Databricks
• Azure Functions
• Azure IoT Central
• Azure Stream Analytics

Question 4)
Which technology is typically used as a staging area in a modern data warehousing architecture?

• Azure Synapse SQL Pools
• Azure Synapse Spark Pools.
• Azure Data Lake

Question 5)
Which of the following is a Big Data Solution that stores data in a relational table format with columnar storage?

• Azure Synapse SQL Pools
• Azure Synapse Spark Pools

Question 6)
Which component enables you to perform code free transformations in Azure Synapse Analytics?

• Synapse Copy activity
• Synapse Studio
• Synapse Mapping data flow

Question 7)
Which transformation in the Mapping Data Flow is used to routes data rows to different streams based on matching conditions?

• Lookup
• Conditional Split
• GetMetadata activity

Question 8)
Which transformation is used to load data into a destination data store or compute resource?

• Source
• Sink
• Window

Question 9)
True or False

When data is stored in Data Lake Storage Gen2, the file size, number of files, and folder structure can have an impact on performance.

• True
• False

Question 10)
When working with Data Lake Storage Gen2 many small files can negatively affect performance. The recommended file size for Data Lake Storage Gen2 is between which of the following sizes?

• 256MB to 1GB
• 256MB to 100GB
• 10GB to 100GB
• 1GB to 10GB