DP-900 Topic 1

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Relational data is stored in: - a file system as unstructured data - a hierarchical folder structure - a tabular form of rows and columns - comma-separated value (CSV) files

- a tabular form of rows and columns

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: _____ presents content defined by a query - heap - stored procedure - view - index

- view A database view is a subset of a database and is based on a query that runs on one or more database tables. Reference: https://www.ibm.com/docs/SSWT9A_7.6.0/com.ibm.mbs.doc/configur/c_views.html

Which type of database contains nodes and edges? A. graph B. key/value C. columnar D. time series

A. graph A graph database stores two types of information, nodes and edges. Edges specify relationships between nodes. Nodes and edges can have properties that provide information about that node or edge, similar to columns in a table. Edges can also have a direction indicating the nature of the relationship. Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

You need to modify a view in a relational database by adding a new column. Which statement should you use? A. MERGE B. ALTER C. INSERT D. UPDATE

B. ALTER

Which setting can only be configured during the creation of an Azure Cosmos DB account? A. geo-redundancy B. multi-region writes C. production or non-production account type D. API

D. API You must create a separate account for each API. Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-manage-database-account

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Normalizing a database increases the throughput of writing transactions Analytics systems are more normalized that transactional systems Normalizing a database results in queries that require more joins

NNY Alt: YNY Reference: https://www.sqlshack.com/what-is-database-normalization-in-sql-server

Which type of database is Azure Database for PostgreSQL? A. Platform as a service (PaaS) B. Infrastructure as a service (IaaS) C. Microsoft SQL Server D. on-premises

PaaS Reference: https://docs.microsoft.com/en-us/azure/postgresql/overview-postgres-choose-server-options

DRAG DROP - Match the types of visualizations to the appropriate descriptions. To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Visualizations: Key Influencer, Scatter, Treemap Answers: - A chart of colored, nested rectangles that displays individual data points represented by the size and color or a relative rectangle - A chart that displays the major contributors of a selected result or value - A chart that shows the relationship between two numerical values

Treemap Key Influencer Scatter

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Relational data uses _____ to enforce relationships between different tables. collections : columns : keys : partitions

keys Reference: https://teachcomputerscience.com/relational-databases/

HOTSPOT - You have the following SQL query. insert into dbo.Products (productId, productName, price, productDesc) values (1, 'Clamp', 12.48, 'Workbench clamp'); What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: Column : Database : Table : Index Answers: dbo.Products productName

table column

HOTSPOT -Select the answer that correctly completes the sentence. Hot Area: _____ is a platform as a service (PaaS) relational data service that uses massively parallel processing (MPP) - Azure SQL Database - Azure Synapse Analytics - Azure Database for MariaDB - SQL Server on Azure virtual machines

- Azure Synapse Analytics Azure Synapse Analytics is an platform as a service (PAAS) that combines data integration, warehousing, and analytics into one solution. Azure Synapse Analytics offers cloud-based, relational data warehousing services, massively parallel processing (MPP) scale-out technology, and enough computational power to efficiently manage petabytes and petabytes of data. Incorrect: * Azure Database for MariaDB is a relational database service based on the open-source MariaDB Server engine. It's a fully managed database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. * Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for your business. Reference:https://cswsolutions.com/blog/posts/2021/august/what-is-azure-synapse-analytics/ https://www.integrate.io/blog/what-is-azure-synapse-analytics/

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: _____ physically sorts the data in a table based on the values in a specified column - view - clustered index - stored procedure - nonclustered index

- clustered index A clustered index defines the order in which data is physically stored in a table. Table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column. Reference: https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: In a relational database, the _____ uniquely identifies each row in a table - foreign key - primary key - WHERE clause - nonclustered index

- primary key A primary key is a special relational database table column (or combination of columns) designated to uniquely identify each table record (row). Reference: https://www.techopedia.com/definition/5547/primary-key

You have an Azure Cosmos DB account that uses the Core (SQL) API. Which two settings can you configure at the container level? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. the throughput B. the read region C. the partition key D. the API

A. the throughput C. the partition key Reference: https://www.sqlshack.com/start-your-journey-with-azure-cosmos-db/

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SQL query. What should you create? A. an index B. a view C. a scalar function D. a table

B. a view Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views

Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition? A. Azure SQL Database B. Azure Database for MySQL C. Azure SQL Managed Instance D. an Azure SQL Database elastic pool

C. Azure SQL Managed Instance SQL Managed Instance has near 100% compatibility with the latest SQL Server (Enterprise Edition) database engine, providing a native virtual network (VNet) implementation that addresses common security concerns, and a business model favorable for existing SQL Server customers. Note: Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql

Your company is designing a data store that will contain student data. The data has the following format. StudNum StudInfo 1 Ben, Smith, Benjamin 2 Dominik, Paiha, [email protected], 98 Which type of data store should you use? A. graph B. key/value C. object D. columnar

D. columnar

DRAG DROP - Match the types of data stores to the appropriate scenarios. To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Graph : Object : Key/value Answer: - A list of application user names and, for each, the default language - A collection of medical images and their associated metadata - Employee data that shows the relationships between employees

Key/value Object Graph

DRAG DROP - Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: Locations: - An in-memory data integration tool - The CRM system - The data warehouse Answers: - Extract - Load - Transform

- The CRM system - The data warehouse - An in-memory data integration tool Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: _____ physically sorts the data in a table based on the values in a specified column - a view - a clustered index - a stored procedure - a nonclustered index

- a clustered index Reference: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: An extract, load, and transform (ELT) process requires: - a separate transformation engin - a target data store powerful enough to transform data - data that is fully processed before being loaded to the target data store - a data pipeline that includes a transformation engine

- a target data store powerful enough to transform data Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: _______ is an object associated with a table that sorts and stores the data rows in the table based on their key values - clustered index - filetable - foreign key - stored procedure

- clustered index Reference: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described?view=sql-server-ver15

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Transcribing audio files is an example of _______ analytics: - cognitive - descriptive - predictive - prescriptive

- cognitive Reference: https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: _____ is responsible for identifying which business rules must be applied to the data of the company - data analyst - data engineer - data scientist

- data analyst A data analyst's primary skill set revolves around data acquisition, handling, and processing. Incorrect: * A data engineer requires an intermediate level understanding of programming to build thorough algorithms along with a mastery of statistics and math. * A data scientist needs to be a master of both worlds. Data, stats, and math along with in-depth programming knowledge for Machine Learning and DeepLearning. Reference: https://www.edureka.co/blog/data-analyst-vs-data-engineer-vs-data-scientist/

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: An extract, transform, and load (ETL) process requires: - a matching schema in the data source and data target - a target data store powerful enough to transform data - data that is fully processed before being loaded to the target data store - that the data target be a relational database

- data that is fully processed before being loaded to the target data store Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A visualization that shows a university's current student enrollment versus the maximum capacity is an example of _____ analytics? - cognitive - descriptive - predictive - prescriptive

- descriptive Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: The massively parallel processing (MPP) engine of Azure Synapse Analytics: - distributes processing across compute nodes - distributes processing across control nodes - redirects client connections across compute nodes - redirects client connections across control nodes

- distributes processing across compute nodes

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Relational data uses _____ to enforce relationships between different tables - collections - rows - keys - partitions

- keys Reference: https://teachcomputerscience.com/relational-databases/

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: In batch processing,: - data is always inserted one row at a time - data is processed real-time - latency in delivering data processing results is acceptable - processing can only execute serially

- latency in delivering data processing results is acceptable Reference: https://www.bmc.com/blogs/what-is-batch-processing-batch-processing-explained/

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: Varying fields for each entity in a JSON document is an example of: - relational data - semi-structured data - structured data - unstructured data

- semi-structured data Reference: https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: A JSON document is an example of _____ - graph data - relational data - semi-structured data - unstructured data

- semi-structured data Reference: https://www.ibm.com/cloud/blog/structured-vs-unstructured-data

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: By default, each Azure SQL database is protected by: - network security group (NSG) - server-level firewall - Azure firewall - Azure front door

- server-level firewall When you create a new server in Azure SQL Database or Azure Synapse Analytics named mysqlserver, for example, a server-level firewall blocks all access to the public endpoint for the server Reference: https://docs.microsoft.com/en-us/azure/security/fundamentals/infrastructure-sql

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: A key/value data store is optimized for: - enforcing constraints - simple lookups - table joins

- simple lookups Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A key/value data store is optimized for: - enforcing constraints - simple lookups - table joins - transactions

- simple lookups Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A relational database must be used when: - a dynamic schema is required - data will be stored as key/value pairs - storing large images and data - strong consistency guarantees are required

- strong consistency guarantees are required

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Transparent Data Encryption (TDE) encrypts: - a column to protect data at rest and in transit - queries and their results in order to protect data in transit - the database to protect data at rest - the server to protect data at rest

- the database to protect data at rest Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?tabs=azure-portal

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: In a relational database, each row in a table has _____ - a different set of columns - a key-value pair - the same set of columns - unstructured data

- the same set of columns Reference: https://www.techopedia.com/definition/4425/database-row https://www.techtarget.com/searchdatamanagement/tip/NoSQL-database-types-explained-Key-value-store

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A relational database is appropriate for scenarios that involve a high volume of: - changes to relationships between entities - geographically distributed writes - transactional writes - writes that have varying data structures

- transactional writes Reference: https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: In an infrastructure as a service (IaaS) instance of Microsoft SQL Server on Azure, you manage the _____ that hosts SQL Server - elastic pool - MySQL server - PostgreSQL server - virtual machine

- virtual machine Reference: https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview?view=azuresql

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Descriptive analytics tells you: - what is likely to occur - what occurred in the past - which actions you can perform to affect outcomes - why something occurred in the past

- what occurred in the past Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

Which storage solution supports access control lists (ACLs) at the file and folder level? A. Azure Data Lake Storage B. Azure Queue storage C. Azure Blob storage D. Azure Cosmos DB

A. Azure Data Lake Storage Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use? A. Microsoft SQL Server Data Tools (SSDT) B. Microsoft SQL Server Management Studio (SSMS) C. Azure Databricks D. Azure Data Studio

A. Microsoft SQL Server Data Tools (SSDT) Reference: https://docs.microsoft.com/en-us/sql/ssdt/project-oriented-offline-database-development?view=sql-server-ver15

Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan? A. SELECT B. WHERE C. JOIN

A. SELECT Table hints override the default behavior of the Query Optimizer for the duration of the data manipulation language (DML) statement by specifying a locking method, one or more indexes, a query-processing operation such as a table scan or index seek, or other options. Table hints are specified in the FROM clause of the DML statement and affect only the table or view referenced in that clause. Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table

You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica? A. You need to generate reports without affecting the transactional workload. B. You need to audit the transactional application. C. You need to implement high availability in the event of a regional outage. D. You need to improve the recovery point objective (RPO).

A. You need to generate reports without affecting the transactional workload. Alt: C. You need to implement high availability in the event of a regional outage. Use read-only replicas to offload read-only query workloads. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/read-scale-out

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. access to the latest features B. complete control over backup and restore processes C. in-database machine learning services D. reduced administrative effort for managing the server infrastructure

A. access to the latest features D. reduced administrative effort for managing the server infrastructure A: Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. D: SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely? A. atomicity B. isolation C. durability D. consistency

A. atomicity The purpose of making transactions atomic is to prevent different transactions from interfering with one another. This can only happen if more than one user process is trying to access the database at the same time, as when a server allows several clients to use it concurrently. The simplest way to enforce atomicity is for the DBMS to refuse to start any transaction until the previous one has committed. Reference: https://www.sciencedirect.com/topics/computer-science/atomic-transaction

Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. ( chart that goes down, then up, then shows a spread ) Which type of analysis is shown in the fourth quarter? A. predictive B. prescriptive C. descriptive D. diagnostic

A. predictive Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

Which command-line tool can you use to query Azure SQL databases? A. sqlcmd B. bcp C. azdata D. Azure CLI

A. sqlcmd The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt. Incorrect Answers: B: The bulk copy program utility (bcp) bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. D: The Azure CLI is the defacto tool for cross-platform and command-line tools for building and managing Azure resources. Reference: https://docs.microsoft.com/en-us/sql/tools/overview-sql-tools?view=sql-server-ver15

When can you use an Azure Resource Manager template? A. to automate the creation of an interdependent group of Azure resources in a repeatable way B. to apply Azure policies for multi-tenant deployments C. to provision Azure subscriptions D. to control which services and feature administrators and developers can deploy from the Azure portal

A. to automate the creation of an interdependent group of Azure resources in a repeatable way You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources. Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview

DRAG DROP - Match the Azure SQL services to the appropriate use cases. To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match its worth one point. Select and Place: Azure SQL Database elastic pool : Azure SQL Database single database : Azure SQL Managed instance Answers: - serverless configuration - database that has the highest compatibility with on-premises Microsoft SQL Server - low-cost, low-maintenance database

Azure SQL Database single database Azure SQL Managed instance Azure SQL Database elastic pool Box 1: Azure SQL Database single database Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second. The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. Scenarios well suited for serverless compute Single databases with intermittent, unpredictable usage patterns interspersed with periods of inactivity, and lower average compute utilization over time. Single databases in the provisioned compute tier that are frequently rescaled and customers who prefer to delegate compute rescaling to the service. New single databases without usage history where compute sizing is difficult or not possible to estimate prior to deployment in SQL Database. Box 2: Azure SQL Managed Instance Azure SQL Managed Instance is the intelligent, scalable cloud database service that combines the broadest SQL Server database engine compatibility with all the benefits of a fully managed and evergreen platform as a service. Box 3: Azure SQL Database elastic pool Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview

DRAG DROP - Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy. To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Azure Storage Account : File Share : Container Answers: Azure Resource Group - _____ -- _____ --- Folders ---- Files

Azure Storage account File Share Alt: Container Reference:https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-create-file-share

You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database. Which type of authentication should you use? A. service principal authentication B. Azure Active Directory (Azure AD) authentication C. SQL authentication D. certificate authentication

B. Azure Active Directory (Azure AD) authentication Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-overview

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)? A. Azure Table storage B. Azure Data Lake Storage C. Azure Queue storage D. Azure Files

B. Azure Data Lake Storage Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database. You need to embed documents and query results into a SQL notebook. What should you use? A. Microsoft SQL Server Management Studio (SSMS) B. Azure Data Studio C. Azure CLI D. Azure PowerShell

B. Azure Data Studio Reference: https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use? A. Azure HDInsight B. Azure SQL Database C. Azure Cosmos DB D. SQL Server on Azure Virtual Machines

B. Azure SQL Database Reference: https://azure.microsoft.com/en-us/services/sql-database/#features

What are two characteristics of real-time data processing? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. Data is processed periodically B. Low latency is expected C. High latency is acceptable D. Data is processed as it is created

B. Low latency is expected D. Data is processed as it is created Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/real-time-processing

You need to query a table named Products in an Azure SQL database. Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point. A. You must be assigned the Reader role for the resource group that contains the database. B. You must have SELECT access to the Products table. C. You must have a user in the database. D. You must be assigned the Contributor role for the resource group that contains the database. E. Your IP address must be allowed to connect to the database.

B. You must have SELECT access to the Products table. C. You must have a user in the database. E. Your IP address must be allowed to connect to the database. Incorrect Answers: A, D: Resource group permissions is not required to query an Azure SQL database table. Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database? A. built-in high availability B. native support for cross-database queries and transactions C. system-initiated automatic backups D. support for encryption at rest

B. native support for cross-database queries and transactions Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/features-comparison

When you create an Azure SQL database, which account can always connect to the database? A. the Azure Active Directory (Azure AD) account that created the database B. the server admin login account of the logical server C. the Azure Active Directory (Azure AD) administrator account D. the sa account

B. the server admin login account of the logical server When you first deploy Azure SQL, you specify an admin login and an associated password for that login. This administrative account is called Server admin. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-quickstart

You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. A. zone-redundant storage (ZRS) B. read-access geo-redundant storage (RA-GRS) C. locally-redundant storage (LRS) D. geo-redundant storage (GRS)

BD D: Azure Storage offers two options for copying your data to a secondary region: ✑ Geo-redundant storage (GRS) ✑ Geo-zone-redundant storage (GZRS) B: With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access geo-redundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS). Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy#redundancy-in-a-secondary-region

DRAG DROP - Match the types of workloads to the appropriate scenarios. To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Batch : Streaming Answers: - Data for a product catalog will be loaded every 12 hours to a data warehouse - Thousands of dat sets per second for online purchases will be loaded into a data warehouse in real time - Updates to inventory data will be loaded to a data warehouse every 1 million transactions

Batch Streaming Batch Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/batch-processing

Which statement is an example of Data Manipulation Language (DML)? A. REVOKE B. DISABLE C. INSERT D. GRANT

C Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

A team of developers has computers that run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as IntelliSense. What should the developers use? A. sqlcmd B. Microsoft SQL Server Management Studio (SSMS) C. Azure Data Studio D. Azure Data Explorer

C. Azure Data Studio Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux. Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal. Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio

You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP). Which Azure service should you use to support the application? A. Azure Cosmos DB B. Azure HDInsight C. Azure SQL Database D. Azure Synapse Analytics

C. Azure SQL Database Azure SQL Database is relational database and a managed service. Incorrect Answers: A, B: Cosmos DB, HDInsight are non-relational databases. D: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing Reference: https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

You have an inventory management database that contains the following table. Prod1: 100 Prod2: 129 Prod3: 176 Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270? A. INSERT B. MERGE C. UPDATE D. CREATE

C. UPDATE Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15

You have a data store that has the structure shown in the following exhibit. Employee Sue works in Department Sales Employee Bob works for Employee Sue Employee Bob works in Department Accounts Employee Frank reports to Employee Sue Employee Frank works in Department Marketing Employee Jon reports to Employee Frank Employee Jon works in Department Marketing Which type of data store is this? A. key/value B. object data C. graph D. time series

C. graph A graph database stores two types of information, nodes and edges. Edges specify relationships between nodes. Nodes and edges can have properties that provide information about that node or edge, similar to columns in a table. Edges can also have a direction indicating the nature of the relationship. Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: _____ natively support the analysis of relationships between entities. Column family databases Document databases Graph databases Key-value stores

Column family databases Alt: Graph databases - yes use this

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: The Azure Cosmos DB _____ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB Core (SQL) : Gremlin : MongoDB : Table

Core (SQL) Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api

HOTSPOT - You have the following JSON document. "customer" : { "fname" : "Ben", "address" : { "line1" : "10 Oak", "line2" : "City" }, "social media" : [ {"service" : "twitter"}, {"service" : "linkedin"} ] } Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document. NOTE: Each correct selection is worth one point. Hot Area: nested array, nested object, root object What is: Customer, Address, Social Media

Customer: root object Address: nested object Social Media: nested array ( [ ] ) Reference: https://www.w3schools.com/js/js_json_arrays.asphttps://www.w3schools.com/js/js_json_objects.asp

Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet. What should you use? A. Azure Application Gateway B. Azure Traffic Manager C. Azure DNS D. Azure Private Link

D. Azure Private Link Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network. Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary Reference: https://techcommunity.microsoft.com/t5/azure-database-support-blog/azure-sql-db-private-link-private-endpoint-connectivity/ba-p/1235573

What is a characteristic of batch processing? A. The data ingested during batch processing must be processed as soon as the data is received. B. Large datasets must be split into batches of less than 1 GB before the data can be processed. C. There is a noticeable time delay between ingesting data and obtaining the data processing results. D. Batch processing can only process data that is structured.

D. Batch processing can only process data that is structured. Alt: C. There is a noticeable time delay between ingesting data and obtaining the data processing results. - yes use this

Which statement is an example of Data Definition Language (DDL)? A. SELECT B. JOIN C. UPDATE D. CREATE

D. CREATE Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statementsv

Which statement is an example of Data Definition Language (DDL)? A. SELECT B. INSERT C. DELETE D. DROP

D. DROP Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table? A. SET B. VALUES C. KEY D. JOIN

D. JOIN Reference: https://www.tutorialspoint.com/sql/sql-using-joins.htm

You have an e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use? A. stream processing B. batch processing C. Online Analytical Processing (OLAP) D. Online Transaction Processing (OLTP)

D. Online Transaction Processing (OLTP) OLTP is designed to serve as a persistent data store for business or front-end applications. OLTP administers day to day transaction of an organization. Reference: https://sqlwizard.blog/2020/03/15/sql-server-oltp-vs-olap/

Which statement is an example of Data Manipulation Language (DML)? A. REVOKE B. DISABLE C. CREATE D. UPDATE

D. UPDATE Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements

You have an Azure SQL database that you access directly from the Internet. You recently changed the public IP address of your computer. After changing the IP address, you can no longer access the database. You can connect to other resources in Azure. What is a possible cause of the issue? A. role-based access control (RBAC) B. Dynamic Host Configuration Protocol (DHCP) C. Domain Name Service (DNS) D. a database-level firewall

D. a database-level firewall The Azure SQL Database firewall lets you decide which IP addresses may or may not have access to either your Azure SQL Server or your Azure SQL database. When creating an Azure SQL Database, the firewall needs to be configured before anyone will be able to access the database. By default, no external access to your SQL Database will be allowed until you explicitly assign permission by creating a firewall rule. Reference: https://www.sqlshack.com/configuring-the-azure-sql-database-firewall/

You need to create an Azure resource to store data in Azure Table storage. Which command should you run? A. az storage share create B. az storage account create C. az cosmosdb create D. az storage container create

D. az storage container create Alt: B Reference: https://docs.microsoft.com/en-us/cli/azure/storage/container?view=azure-cli-latest

HOTSPOT - You are reviewing the data model shown in the following exhibit. customer product ..........sales salesPerson warehouse Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point Data Model is: transactional, star, snowflake Customer is: fact, dimension, bridge

Data model is star schema Customer is dimension Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-overview https://en.wikipedia.org/wiki/Star_schema https://en.wikipedia.org/wiki/Snowflake_schema https://azure.microsoft.com/en-us/blog/data-models-within-azure-analysis-services-and-power-bi/

DRAG DROP - Match the Azure Data Factory components to the appropriate descriptions. To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Dataset : Linked service : Mapping data flow : Pipeline Answers: - A representation of data structures within data stores - The information used to connect to external resources - A logical grouping of activities that performs a unit of work and can be scheduled

Dataset Linked service Pipeline Reference: https://k21academy.com/microsoft-azure/dp-100/datastores-and-datasets-in-azure/ https://docs.microsoft.com/en-us/azure/data-factory/concepts-linked-services https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipelines-activities

DRAG DROP - Match the types of analytics that can be used to answer the business questions. To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Cognitive : Diagnostic : Descriptive : Predictive : Prescriptive Answers: - why did sales increase last month - provide specific guidance on how to allocate current budget to buy different inventory items - detect images of the company's logo included in PDF documents

Diagnostic Prescriptive Cognitive Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

DRAG DROP - Match the types of analytics that can be used to answer the business questions. To answer, drag the appropriate analytics type from the column on the left to its question on the right. Each analytics type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Cognitive - Diagnostic - Descriptive - Predictive - Prescriptive - Why did sales increase last month? - How do I allocate my budget to buy different inventory items? - Which people are mentioned in a company's business documents?

Diagnostic Prescriptive Descriptive Generally speaking, data analytics comes in four types: ✑ Descriptive, to answer the question: What's happening? ✑ Diagnostic, to answer the question: Why's happening? ✑ Predictive, to answer the question: What will happen? ✑ Prescriptive, to answer the question: What actions should we take? Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

DRAG DROP - Match the security components to the appropriate scenarios. To answer, drag the appropriate component from the column on the left to its scenario on the right. Each component may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Authentication : Firewall : Encryption - Prevent access to an Azure SQL database from another network - Support Azure AD sign-ins to an Azure SQL database - Ensure that sensitive data never appears as plain text in an Azure SQL database

Firewall Authentication Encryption Reference: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-windows-firewall-for-database-engine-access?view=sql-server-ver15 https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-certificate-store-configure

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: _____ natively support the analysis of relationships between entities Column family databases Document databases Graph databases Key-value stores

Graph databases Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview

HOTSPOT - You plan to deploy a PostgreSQL database to Azure. Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: IaaS : PaaS : SaaS Answers - PostgreSQL on Azure VMs - Azure Database for PostgreSQL

IaaS PaaS Reference: https://azure.microsoft.com/en-us/overview/what-is-saas/ https://azure.microsoft.com/en-us/overview/what-is-paas/

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: In a SQL statement, _____ are examples of aggregate functions. FROM and WHERE GROUP BY and ORDER BY JOIN and MERGE MAX and MIN

MAX and MIN Reference: https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: You must apply operating system updates to Azure SQL databases regularly You need a MS 365 subscription to create an Azure SQL database You can use existing MS SQL Server licenses to reduce the cost of Azure SQL databases

NNY Reference: https://azure.microsoft.com/en-gb/blog/hot-patching-sql-server-engine-in-azure-sql-database/ https://azure.microsoft.com/en-us/services/sql-database/#product-overview

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: - Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems - Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system - Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.

NYN Alt: YNY - yes use this Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: If you have PaaS database in Azure, you are responsible for applying operating system updates If you have PaaS database in Azure, backups are performed automatically If you have PaaS database in Azure, you are responsible for installation of the database engine

NYN Box 1: No - Microsoft handles all patching and updating of the SQL and operating system code. You don't have to manage the underlying infrastructure. Box 2: Yes - SQL Database is a fully managed service that has built-in high availability, backups, and other common maintenance operations. Box 3: No - Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Normalization involves eliminating relationships between database tables Normalizing a database reduces data redundancy Normalization improves data integrity

NYY Reference: https://www.sqlshack.com/what-is-database-normalization-in-sql-server/

DRAG DROP - You have a table named Sales that contains the following data. You need to query the table to return the average sales amount per day. The output must produce the following results. How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. CREATE : GROUP BY : ORDER BY : SELECT _____ SalesDate, AVG(SalesAmount) FROM Sales _____ SalesDate ORDER BY SalesDate

SELECT GROUP BY Box 1: SELECT - Box 2: GROUP BY - Example: When used with a GROUP BY clause, each aggregate function produces a single value covering each group, instead of a single value covering the whole table. The following example produces summary values for each sales territory in the AdventureWorks2012 database. The summary lists the average bonus received by the sales people in each territory, and the sum of year-to-date sales for each territory. SELECT TerritoryID, AVG(Bonus) as 'Average bonus', SUM(SalesYTD) as 'YTD sales' FROM Sales.SalesPerson - GROUP BY TerritoryID; Reference: https://docs.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql

DRAG DROP - Match the tools to the appropriate descriptions. To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all. Select and Place: Azure Data Studio : MS SSDT : MS SSMS Answers: - A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks - A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or MS Excel files - A development tool for building Azure SQL databases, MS SQL Server relational databases, SSAS data models, SSIS packages, and SSRS reports

SSMS Azure Data Studio SSDT Box 1: Microsoft SQL Server Management Studio (SSMS)SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. Box 2: Azure Data Studio -Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience. Box 3: Microsoft SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio. Reference: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms https://code.visualstudio.com/docs/supporting/FAQ https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

HOTSPOT - You have the following SQL query. insert into dbo.Products (productId, productName, price, productDesc) values (1, 'Clamp', 12.48, 'Workbench clamp'); What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area: Column : Database : Table : Index Answers: dbo.Products productName

Table Column

DRAG DROP - Match the terms to the appropriate descriptions. To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: Index : View : Table Answers - A database object that holds data - A database object whose content is defined by a query - A database object that helps improve the speed of data retrieval

Table View Index Reference: https://en.wikipedia.org/wiki/Table_(database) https://en.wikipedia.org/wiki/View_(SQL)https://en.wikipedia.org/wiki/Database_index

DRAG DROP - Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process. Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place: A standalone data analysis tool : The CRM system : The data warehouse Answers: Extract Load Transform

The CRM system The data warehouse A standalone data analysis tool Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Batch processing can output data to a file store Batch processing can output data to a relational database Batch processing can output data to a NoSQL database

YNN Alt: YYY - yes, use this one Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort than infrastructure as a service (IaaS) database offerings Platform as a service (PaaS) database offerings in Azure provide end users with the ability to control and update the operating system version All relation and non-relational platform as a service (PaaS) database offerings in Azure can be paused to reduce costs

YNN Reference: https://azure.microsoft.com/en-us/overview/what-is-paas

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Azure Data Studio can be used to query and Azure SQL database from a device that runs macOS SSMS enables user to create and use SQL notebooks Azure Data Studio can be used to restore a database

YNY Box 1: Yes - Azure Data Studio is a cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux. You can use Azure Data Studio to connect to an Azure SQL Database server. You'll then run Transact-SQL (T-SQL) statements to create and query Azure SQL databases. Box 2: No - SQL Server Management Studio is for configuring, managing, and administering all components within Microsoft SQL Server, not to create SQL notebooks. Instead use Azure Data Studio to create SQL notebook. Box 3: Yes - You can use the Azure Data Studio to restore databases. Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Relational database tables contain columns and rows Indexes in a relational database describe the data types in a table A database view is a virtual table whose content is defined by a query

YNY Box 1: Yes - Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. Each row represents a unique record, and each column represents a field in the record. Box 2: No - An index is an on-disk structure associated with a table or view that speeds retrieval of rows from the table or view. Box 3: Yes - A view is a virtual table whose contents are defined by a query. Like a table, a view consists of a set of named columns and rows of data. Reference: https://docs.microsoft.com/en-us/sql/relational-databases/tables/tables https://docs.microsoft.com/en-us/sql/relational-databases/indexes/clustered-and-nonclustered-indexes-described https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: A job that processes sales data once daily is an example of a batch workload. A job that calculates a rolling average temperature reading is an example of a streaming workload. A job that calculates average revenue per product for the last month is a example of a streaming workload.

YYN Reference: https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: Azure SQL Database includes a managed backup service Azure SQL Database has built-in high availability Azure SQL Database can use Azure Defender

YYY Box 1: Yes - Box 2: Yes - Box 3: Yes - Azure Defender provides security alerts and advanced threat protection for virtual machines, SQL databases, containers, web applications, your network, and more. Azure Defender provides security alerts and advanced threat protection for virtual machines, SQL databases, containers, web applications, your network, and more. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview https://azure.microsoft.com/en-us/blog/announcing-sql-atp-and-sql-vulnerability-assessment-general-availability/ https://docs.microsoft.com/en-us/azure/security-center/azure-defender

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: PaaS database offerings in Azure provide built-in high availability PaaS database offerings in Azure provide configurable scaling options PaaS database offerings in Azure reduce the administrative overhead for managing hardware

YYY Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

HOTSPOT - For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. Hot Area: You can use Azure Data Studio to query a Microsoft SQL Server big data cluster You can use SSMS to query an Azure Synapse Analytics data warehouse You can use MySQL Workbench to query Azure Database for MariaDB databases

YYY Reference: https://docs.microsoft.com/en-us/sql/big-data-cluster/connect-to-big-data-cluster?view=sql-server-ver15 https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-query-ssms https://docs.microsoft.com/en-us/azure/mariadb/connect-workbench

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A visualization that illustrates a university's current enrollment per department is an example of _____ analytics. cognitive : descriptive : predictive : prescriptive

descriptive Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: Creating closed caption text for audio files is an example of _____ analytics. cognitive : descriptive : predictive : prescriptive

descriptive Reference: https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/ https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/ https://docs.microsoft.com/en-us/azure/media-services/previous/media-services-index-content

DRAG DROP - Match the types of data to the appropriate Azure data services. To answer, drag the appropriate data type from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place: image files : key/value pairs : relationships between employees Answers: Azure Blob storage Azure Cosmos DB Gremlin API Azure Table storage

image files relationships between employees key/value pairs Reference: https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: A block of code that runs in a database is called _____ stored procedure : table : view : index

stored procedure Reference: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver15

HOTSPOT - Select the answer that correctly completes the sentence. Hot Area: A _____ is a chart of colored rectangles. The size of the rectangles represent the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles nested within the main rectangle. line chart : matrix : scatter : treemap

treemap Reference: https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: _____ presents content defined by a query heap : stored procedure : view : index

view

HOTSPOT - To complete the sentence, select the appropriate option in the answer area. Hot Area: _____ is a virtual table that contains content defined by a query. heap : stored procedure : view : index

view Reference: https://docs.microsoft.com/en-us/sql/relational-databases/views/views