You plan to deploy app. The app requires a nonrelational data service that Will provides latency guarantees of les tan 10-ms for read ans writes. What should you include in the solution?	Azure Cosmos DB
In a SQL statement, ______ are examples of aggregate functions	MAX and MIN
You have the following SQL query “INSERT INTO dbo.Products (ProductID, ProductName, Price, ProductDescription) VALUES (1,’Clamp’, 12.48, ‘Workbench clamp’);” What are dbo.Products and ProductName	Dbo.Products: A table, ProductName: A columna
Which Azure Data Factory component provides the compute environment for activities?	an integration runtime
You need to modify a view in a relational database by adding a new column. Which statement should you use?	ALTER
Match the types of workloads to the appropriate scenarios. Streaming , Batch, Batch	Batch \| Data for a product catalog will be loaded every 12 hours toa data warehouse. Streaming \| Data for onlines purchases will be loaded to a data warehouse as the puchases occur. Batch \| Updates to inventory data will be loaded to a data warehouse every 10,000 transactions.
Whit two Azure services can be used to provision Apache Spark clusters?	Azure HDInsight and Azure Data bricks
Which propriety of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?	Atomicity
A relational data base is appropriate for scenarios that involve a high volume of	transactional writes.
Macht the types of visualizations of appropriate descriptions. Scatter , Key Influencer, Treemap	Treemap \| A chart o colored, nested rectangles that displays individual data point represented by the size and color of a relative rectangle. Key Influencer \| A chart that displays the major contributors of a selected result or value. Scatter \| A chart that shows the relationship between two numerical values
Which storage solution support role-based access control (RBAC) at the file and folder level?	Azure Data Lake Storage
Which storage solution supports access control list (ACLs) at the file and folder level?	Azure Data Lake Storage
Match the datastore services to the appropriate descriptions. Azure Files, Azure Cosmos DB	Azure Cosmos DB \| Enables the use SQL queries against data stores in JSON documents. Azure Files \| Enables users to access data by using the Server Message Block (SMB) version 3 protocol.
What are the characteristics of an Online Transaction Processing (OLTP) workload?	Heavy writes and moderate read, schema on write or schema defined in database, normalized data
A bar char showing year-to-date sales by region is an example of which type of analytics?	Descriptive
Match the tools to the appropriate descriptions. Azure Data Studio, Microsoft SQL Data Tools (SSDT), Microsoft VIsual Stusio, Microsoft SQL Server Management Stusio (SSMS)	(SSMS) \| A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks. Visual Studio Code \| A lightweight source code editor while an mssql extension that supports connections to SQL Server and a rich editing experience for T-SQL. Azure Data Studio \| A lightweight editor that ca run on-demand SQL queries and view and save results as text, JSON or Excel. SSDT \| A development tool for building Azure SQL databases
Match each tool to its task. Power Automate, Power Automate, Power Apps	Atomate workflow \| Power Automate. Trigger actions form an event \| Power Automate. Create a custom mobile data entry screen \| Power Apps
Which Azure SQL offering provides near-100 percent compatibility with on-premises Microsoft Server instances, while providing automated updates, backups, and maintenance tasks?	Azure SQL Managed Instance
HOSTPOT- For each of the following statements, select Yes if the statement is true.	Image
For each of the following statements, select Yes if the statement is true	Image
DRAG DROP – Macht the security components to the appropriate scenarios	Image
Relational data uses ____ to enforces relationships between different tables	Keys
You have an inventory management database that contains the following table. Wich statement should you use in a SQL query to change the inventory quantity of Product1 to 270	UPDATE
Your company need to implement a relations database in Azure, The solution must minimize ongoing maintenance. Which Azure services should you use?	Azure SQL Database
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 use?	Azure Data Studio
Match the terms to the appropriate descriptions	Image
You have a e-commerce application that reads and writes data to an Azure SQL database. Which type of processing does the application use?	Online Transactions Processing (OLTP)
When can you use an Azure Resource Manager template?	to atomate the creation of an interdependent group or Azure resources in repeatable way
You have an Azure SQL database that you access directly from the Internet. You recently change 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 database-level firewall
For each of the following statement, select Yes if the statement if true	Image
Which command-line tool can you use to query Azure SQL databases?	sqlcmd
For each of the following statement, select Yes if the statement if true	Image
For each of the following statement, select Yes if the statement if true	Image
For each of the following statement, select Yes if the statement if true	Image
Descriptive Analytics tell you ___	what occurred in the past
For each of the following statements, select Yes if the statement if true	Image
An extract, transform, and loas (ETL) process requires	data that is fully processed before being loaded to the target data store
In batch processing ,	latency in delivering data processing results is acceptable.
Transcribing audio files ins an example of _____ analytics	Cognitive
Match the types of analytics that can be used to answer the business questions	Image
You have the following JSON document. Image	Image
You are reviewing the data model shown in the following exhibit. Image	Image
The massively parallel processing (MPP) engine of Azure Synapse Analytics	distributes processing across compute nodes
___ is an object associated with a table that sorts and stores the data rows int eh table base on their key values	A clustered index
A relational database is appropriate for scenarios that involve a high volume of	transactional writes
A visualization that shows a university’s current stident enrollment versus the maximum capacity is an example of ___ analytics	descriptive
You need to create an Azure Storage Account. Data in the account must replicate outside the Azure region automatically. Which two types of replications con you use for the storage count?	read-access geo-redundant storate (RA-GRS) and geo-redundant storage (GRS)
Which statement is an example of Data Manipulation Language (DML)	INSERT
You have a SQL query that combines customer data and order data. Ther query includes calculated columns. You need to create database object that would allow other users to rerun the same SQL query. What should you create?	a view
A key-value data store is optimized for	simple lookups
Match the types of data to the appropriate Azure data services	Image
Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.	Image
What are two characteristics of real-time data processing?	Low latency is expected, and Data is processed as it is created
Match the Azure Data Factory components to the appropriate descriptions.	Image
Match the types of workloads to the appropriate scenarios.	Image
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?	Image
Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. IMAGE	Predictive
Which statement is an example of Data Manipulation Language (DML)?	UPDATE
Creating closed caption text for audio files is an example of ___ analytics	Cognitive
A visualization that illustrates a university’s current student enrollment per department is an example of ___ analytics	Descriptive
You need to create an Azure resource to store data in Azure Table storage. Which command should you run?	az storage container create
The Azure Cosmos DB ___ API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB	Core (SQL)
You need to modify a view in a relational database by adding a new column. Which statement should you use?	ALTER
For Each of the following statements, select Yes if the statement if true	Image
You plan to deploy PostgreSQL database to Azure. Which hosting model correspond to the available deployment options?	Image
___ natively support the analysis of relationships between entities	Column family databases
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?	Azure Data Lake Storage
Relational data in stored in	a tabular form of rows and columns
___ physically sorts the data in a table base on the values in a specified columns	A clustered index
A block of code that runs in a database is called	a stored procedure
Match the types of analytics that can be used to answer the business questions	Image
__ presents content defined by a query	A view
Which type of database is Azure Database for PostgreSQL?	Platform as a service (PaaS)
Which storage solution supports access control list (ACLs) at the file and folder level?	Azure Data Lake Storage
A __ is a chart of colored rectangles. The size of the rectangles represents the relative value of each item. The chart can be hierarchical, displaying data as a set of rectangles nested within the main rectangle	treemap
What is a characteristic of a batch prossesing?	Batch processing can be only process data that is structured
For Each of the following statements, select Yes if the statement if true	Image
In a relational database, each row in a table has	the same set of columns
For Each of the following statements, select Yes if the statement if true	Image
__ natively support the analysis of relationships between entities	Graph databases
In an infrastructure as a service (IaaS) instance of Microsoft SQL Server on Azure, you manage the __ that hosts SQL Server	Virtual Machine
Varying field for each entity in a JSON document is an example of	semi-structured data
A JSON document is an example of	semi-structured data
You have a data store that has the structure shown in the following exhibit. Which type of data store is this? Image	Graph
Which type of database contains nodes and edges?	Graph
___ is responsible for identifying which business rules must be applied to the data of a company	A data analyst.
Relational data uses __ to enforce relationships between different tables	keys
A data engineer is responsible for which task?	Implement policies, tools and processes for backup and recovery plans.
You have the following two tables of customer data. Which type of data do the tables contain? Image	Unstructured.
Which file format has defined names and data types for each column and uses compressed columnar storage?	Apache parquet
You have structured data in a tabular format. What represents an individual instance of a data entity?	A row
Wicht T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?	SELECT
Drag and drop appropriate Azure Services to the suitable locations in the architecture	Image
Which three objects can be added to a Microsoft Power BI dashboard?	A report page, A DataFlow and A text box
Backing up and restoring data are the responsibility of a	data engineer
Online analytical processing (OLAP) systems are particularly suitable for analytical workloads because data is	optimized for transactions
You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics. What should you use?	Synapse Link
You need to create a visualization of running sales totals per quarter as shown in the following exhibit. What should you create in Power BI Desktop? Image	A waterfall chart
Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?	JOIN
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?	Azure Private Link
What should you use to automatically delete blobs from Azure Blob Storage?	a lifecycle management policy
A bar chart showing year-to-date sales by region is an example of which type of analytics?	Diagnostic
Which setting can only be configured during the creation of an Azure Cosmos DB account?	API
For each of the following statements, select Yes if the statement is true	Image
To configure an Azure Storage account to support access control list that have object-level permissions,	enable the hierarchical namespace
You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?	Online Transaciton Processing (OLTP)
For each of the following statements, select Yes if the statement is true	Image
___ is responsible for creating visual and charts that help a company makes informed decisions	A data engineer
A relational database must be usen when	strong consistency guarantees are required
You need to store event log data that is semi-structured and received as the logs occur. What should you use?	Azure Files
What is a characteristic of a non-relational database?	self-describing entities
When using the Azure Cosmos DB Gremlin API, container resource type is projected as a	graph
When provisioning an Azure Cosmos DB ____, you need to specify which type API you will use	account
When you create an Azure SQL database, which account can always connect to the database?	The server admin login account of the logical server
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?	Availability zones
What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?	Supports a multi-master model
Your company needs to design a database that illustrates the relationships between utilization levels of individual network devices across a local area network. Which type of data store should you use?	Graph
You need to recommend a data store service that meets the following requirements: Native SQL API access, Configurable indexes. What should you recommend?	Azure Cosmos DB
What are three characteristics of an Online Transaction Processing (OLTP) workload?	Heavy writes and moderate read, Schema defined a database and Normalized data
What is the primary purpose of a data warehouse?	To provide read-only storage of relational and non-relational historical data
What are two uses of data visualization?	Represent trends and patterns over time, Communicate the significance of data
Which statement is an example of Data Definition Language (DDL)?	DROP
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?	Azure Data Studio
You need to store data by using Azure Table storage. What should you create first?	A Storage Account
___ is responsible for managing the security of the data in a database	A database administrator.
The __ clause can be used in Data Manipulation Language (DML) statement to specify the criteria that rows must match	WHERE
You have data saved in the following format. Which format was used? Image	XML
What is a primary characteristic of a relational database?	Data is queried and manipulated by using a variant of the SQL language
Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?	Atomicity
The __ format is used to store delimited data separates data files by using commas, and terminate rows by using a carriage return	CSV
The __ file format uses a hierarchical documents schema to define data entities that have multiple attributes	JSON
For each of the following statements, select Yes if the statement is true.	Image
__ is an example of a Data Manipulation Language (DML) statement	UPDATE
In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?	Fact
Which Azure Cosmos DB API should you use for a graph database?	Azure Cosmos DB for Apache Gremlin
For each of the following statements, select Yes if the statement is true	Image
Match the types of data to the appropriate Azure data services	Image
In a fully denormalized database, how is data read and written for a single entity?	Data is read for a single table and written to a single table
You have a banking application that transfers money in to and out of accounts. Of which type of solution is this is an example?	Online Transactions Processing (OLTP)
For each of the following statements, select Yes if the statement is true	Image
What should you use to build a Microsoft Power BI paginated report?	Power BI Report Build
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?	Azure SQL Database
What are two benefits of platform as a service (PaaS) relational database offering in Azure, such as Azure SQL Database?	Access to the last features, reduced administrative effort for managing the server infrastructure
For each of the following statements, select Yes if the statement is true.	Image
For each of the following statements, select Yes if the statement is true.	Image
A Microsoft Power BI __ enables user to create highly formatted, fixed-layout documents optimized for printing and archiving.	Paginated Report
__ are responsible for the availability, performance, and optimizations of databases	Database Administrators
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? Image	Image
For each of the following statements, select Yes if the statement is true	Image
___ provides a full range of Power BI data modeling an report editing features	Microsoft Power BI Desktop
___ can be used as part of a lift-and-shift solutions for migrates an on-premises application to the cloud with minimal changes	An instance of SQL Server on Azure Virtual Machine
Match the Azure services to the appropriate locations in the architecture	Image
For each of the following statements, select Yes	Image. Yes, Yes, No
For each of the following statements, select Yes if the statement is true	Image
You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse. What should you use to query the files?	Azure Data Factory
To configure an Azure Storage account to supports both security at the folder level and atomic directory manipulation	enable the hierarchical namespace
You can query a graph database in Azure Cosmos DB	as a JSON document by using a SQL-like language
For each of the following statements, select Yes if the statement is true	Image
For each of the following statements, select Yes if the statement is true	Image
Batch workloads	collect data and the process the data when a conditions is met
Match the Azure services to the appropriate requirements	Image
Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?	Durability
For each of the following statements, select Yes if the statement is true	Image
In azure data Factory, you can use __ to orchestrate pipeline activities that depend on the output of other pipelines activities	control flow
For each of the following statements, select Yes if the statement is true.	Image
In a data warehousing workload, data	form multiple resources is combined in a single locations
Match the job roles to the appropriate tasks. Image	Image
Match the database normalization terms to the appropriate descriptions. Image	Image