sesi 35

Which of the following statements is not true regarding the differences between batch and streaming data?

• Batch processing can process all the data in the dataset

• Stream processing is intended for individual records

• Batch processing is used for performing complex analytics

• The latency for stream processing is typically a few hours

You are looking to use Azure for analytics, but have a number of conditions: 1) Large volumes of data can be processed at a convenient time, 2) It can be scheduled to run at a time when computers or systems might otherwise be idle, such as overnight, or during off-peak hours. Based on the conditions, which service do you need to use?

• Azure Batch Processing

• Azure Streaming Data

• Azure Micro Batches

• Azure Data Explorer

In a relational database, you model collections of entities from the real world as tables. The following are the main characteristics of a relational database, except:

• All data is tabular

• Have a primary key that each row of table can share the same primary key with

• Have a foreign key that references rows in another, related table

• All rows in the same table have the same set of columns

In creating a relational database, there is the process called normalization. What is normalization?

• Use the SQL to create tables

• Split an entity into more than one table

• Creating data model of entities

• Use 1-to-many relationship

Azure Data Explorer integrates with various visualization tools. Azure Data Explorer provides the capability to connect to Power BI using the following methods, except:

• SQL Query

• Built-in Native Power BI Connector

• Query Import

• Open Database Connectivity

To be able to visualize (tables, pie charts and bar charts) with the capabilities to detect and forecast, which of the following application should be used?

• Batch API

• Kusto Query Language

• Power Automate

• Sync Kusto

Data analytics comes in four types. If you want to know if there are any anomalies that require immediate attention, which type do you need to use?

• Descriptive

• Diagnostic

• Predictive

• Prescriptive

Data analytics comes in four types. If you want to know why some machines produce more defective parts than the others, which type do you need to use?

• Descriptive

• Diagnostic

• Predictive

• Prescriptive

Which of the following statements is not true regarding ETL and ELT?

• The transformation work in ETL takes place in a specialized engine

• The transformation work in ELT occurs in the target data store

• ETL only works well when the target system is powerful enough to transform the data efficiently

• Typical use cases for ELT fall within the big data realm

The advantage of using ELT is:

• No need to use a separate transformation engine

• Run in parallel to save time

• Can works well even when the target system is low

• Use a specialized engine