Worksheetssesi 35
Total questions: 30
Worksheet time: 12mins
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
Azure enables businesses to implement some scenarios about their data. For analysis purposes, the data can be left in its raw, ingested format, or the data can be processed. The following are the most common options for processing data in Azure, except:
Azure Databricks
Azure Data Factory
Azure Data Lake
Azure Data Drive
DTUs and vCores determine the performance of your Azure SQL Database. What are DTUs?
DTU stands for Database Transaction Unit, an in-memory data-store for returning data extremely vast but is also extremely volatile
DTU stands for Database Transaction Unit, that can run many open-source Big Data engines for doing data transformations for streaming, ETL/ELT.
DTU stands for Database Transaction Unit, and is a combined measure of compute, storage, and IO resources.
DTU stands for Data Transfer Unit, a shared-file system for organizations
When can you use an Azure Resource Manager template?
to automate the creation of an interdependent group of Azure resources in a repeatable way
to apply Azure policies for multi-tenant deployments
to provision Azure subscriptions
to control which services and feature administrators and developers can deploy from the Azure portal
What has to be typed before doing a command to create, update, delete, view and manage Azure resources in an Azure CLI?
Az
AZ
Azr
az
Denial of service (DoS) attacks are reduced by a SQL Database gateway service. What is the name of this service?
anti-DoS
DoSGuard
Azure Key Vault
Azure DNS
Which of the following should be accessed to see for any known outages that occurred during the time during which the errors were reported by the application?
Azure Portal
Azure CLI
Azure Service Dashboard
Azure Key Vault
When the connection to Azure SQL Database fails, you receive error messages. Which of the following is not a possible connection problem that may cause this?
Azure SQL Database reconfiguration
Connection time-out
Maximum limit reached on some Azure SQL Database resources
Accessing Azure Service Dashboard
What is Azure Data Studio?
a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
An application used to explore data within Azure Storage Accounts
import or export TB of data via hard drive you mail into Azure Datacenters
A third-party provider partnered with Azure specializing in Apache Spark to provide very fast ELT jobs, as well as ML and streaming
Which of the following statements between DDL and DML is not true?
DDL does not use WHERE clause in its statement. While DML uses WHERE clause in its statement.
Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc. BASIC command present in DML are UPDATE, INSERT, MERGE etc.
DDL is Data Definition Language which is used to define data structures. DML is Data Manipulation Language which is used to manipulate data itself.
DDL is a Data Drive Language which is used to define data structures. DML is Data Migrating Language which is used to decrypt data itself.
Which of the following SQL Query should be done in order to modify a certain value of a database?
Run a DELETE query
Run a SELECT query
Run a UPDATE query
Run an INSERT query
Can both DDL and DML be used to create a database schema and to be used to define some constraints as well?
No, DML is able to
Yes, both DDL and DML are able to
No, only DDL is able to
No, both are not able to
Is the following statement true: ‘DML stands for Data Manipulating Language, it is used to add, retrieve or update the data.’ ?
No, DDL is only able to add, retrieve or update the data as well. DML is used to create a database schema.
No, DML stands for Data Migrating Language
Yes, the statement is true
No, DML is used for SQL queries
Which of the following SQL query allows a user to delete a certain value/row/column in a database?
Run INSERT query
Run DELETE query
Run UPDATE query
Run SELECT query
If you want to Build applications with guaranteed low latency and high availability anywhere at any scale, which of the following database products do you need to use?
Azure Cosmos DB
Azure Database Migration Service
Azure SQL Database
Azure SQL Managed Instance
Relational database contains structures, that are index and view. An index helps you search for data in a table, and some relational database management systems also support clustered indexes. What do the clustered indexes work on?
Re-organizes a table by the index key
Help to find the corresponding data in the underlying table
List the orders for a specific product
Automatically filter the specific product of index key
A view is a virtual table based on the result set of a query. The following statements are the function of view, except?
List the orders for a specific product
Finds the details of customers
Finds all orders for a specific product
Help to find the corresponding data in the underlying table
Which of the following approaches is best for migrations and applications requiring operating system-level access?
Infrastructure-as-a-Service (IaaS)
Platform-as-a-Service (PaaS)
Software-as-a-Service (SaaS)
Networking-as-a-Service (NaaS)
Which of the following is not the benefit of using PaaS solutions for relational databases?
Specify the resources that you require
Not restricted to any specific database management system
Automatically creates the necessary virtual machines, networks, and other devices for you
Allows you to scale up or down quickly
Which of the following is the key component of a big data solution in Azure Synapse Analytics?
PolyBas
Data Warehousing
Hadoop/ Spark
Columnar storage
Which of the following below is not a data store type that is found in a Non-Relational Data?
Document data stores
Columnar data stores
Key/Value data stores
Visual data stores
