Font size
Worksheetstry it
Total questions: 74
Worksheet time: 39mins
Which command-line tool can you use to query Azure SQL databases?
sqlcmd
bcp
azdata
Azure CLI
Azure SQL Database includes a fully managed backup service
Yes
No
Azure SQL Database has built in high availability
Yes
No
Azure SQL Database can use Azure Advanced Threat Protection(ATP)
Yes
No
You can use Azure Data Studio to query a microsoft SQL Server Big Data Cluster
Yes
No
You can use SSAS to query an Azure synapse Analytics Data warehouse
yes
no
You can use MYSQL workbench to query Azure Database for Maria DB database
yes
no
you must apply patches to Azure SQL datbases regularly
yes
no
you need a microsoft 365 subscription to create an Azure SQL database
yes
no
You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL db
yes
no
Which statement is an exampe of DDL ?
SELECT
JOIN
. MERGE
CREATE
If you have a platform as a service (Paas) db in Azure, you are responsible for applying operating system updates
yes
no
If you have Paas db in Azure, backups are performed automatically
yes
no
If you have Paas db in Azure, you are responsible for upgrading the db engine
yes
no
You manage an application that stores data in a shared folder on a Windows server. You need to move the shared folder to Azure Storage. Which type of Azure Storage should you use?
queue
blob
file
table
What should you use in Microsoft Power BI?
report
view
create
delete
when using the azure cosmos db gremlin api the container resource type is projected as a
graph
table
document
partition key
At which two levels can you set the throughput for an Azure Cosmos DB account?
database
container
item
partition
You have an Azure Cosmos DB account that uses the core API. Which two settings can you configure at the container level?
the throughput
the read region
the partition key
the API
You need to store data in Azure Blob storage for seven years to meet your company's compliance requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.Which storage tier should you use?
Archive
Hot
Cool
A relational db is appropriate for scenarios that involve a high volume of
transactinal writes
transactinal read
A bar chart showing year to date sales by region is an example of which type of analytics?
predictive
prescriptive
descriptive
diagnostic
A visualization that shows a university's current student enrollment versus the maximum capacity is an example of descriptive analytics
descriptive analytics
reguler analytics
Which type of processing does the application use?
Online Transaction Processing (OLTP)
batch processing
Online Analytical Processing (OLAP)
stream processing
A microsoft power BI dashboard is associated with a single workspace
yes
no
a micorosoft power BI dashboard can only visualization from a single dataset
yes
no
a microsoft power BI dashboard can display visualization from a Microsoft Excel workbook?
yes
no
Which azure data factory component provides the compute environment for activities?
a linked service
an integration runtime
a control flow
a pipeline
Azure databricks is an Apache Spark based collaboratove analytics platform
yes
no
Azure Analytics Service is used for transactional workloads
yes
no
Azure data factory orchestrates data integration workflows
yes
no
To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation
enable the heirarchical namespace
set Account kind to Blobstorage
set Performance to Premium
set Replication to Read-access geo-redundant storage (RA-GRS)
You can query a graph db in azure cosmos BD
as a JSON document by using a SQL-like language
. as a partitioned row store by using Cassandra Query Language (CQL)
as a partitioned row store by using Language-Integrated query (LINQ)
as nodes and edges using the Gremlin language
Azure Dtaabrics can consume data from Azure SQL db
yes
no
Azure databricks can consume data form Azure Event Hubs
yes
no
Azure databricks can consume data form Azure Cosmos DB
yes
no
A pipeline is a representation of a data structive within Azure Data Factory
yes
No
Azure Data factory pipelines can execute other pipelines
yes
no
A processing step within an Azure Data Factory pipeline is an activity
yes
no
Azure sypnase Analytics scales storage and compute independently
yes
no
Azure sypnase Analytics can be paused to reduce compute costs
yes
no
Azure sypnase Analytics data warehouse has a fixed storage capacity
yes
no
What should you use to build a Microsoft Power BI paginated report?
Charticulator
Power BI Desktop
the Power BI service
Power BI Report Builder
which scenario is an example of a streaming workload
sending transactions that are older than a month to an archive
sending transactions daily from point of sale (POS) devices
sending telemetry data from edge devices
sending cloud infrastructure metadata every 30 minutes
processing salary payments once a month is an example of a batch workload
yes
no
a wind turbine that send 50 sensor readings per seconds is an example of a streaming workload
yes
no
Transparent data encryption (TDE) encrypts the database to protect data at rest
yes
no
A relational db must be used when
strong consisntency guarantees are required
noo
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. (Choose three.)NOTE: Each correct selection is worth one point.
You must have SELECT access to the Products table.
You must have a user in the database.
You must be assigned the Contributor role for the resource group that contains the database.
Your IP address must be allowed to connect to the database.
A key value data store is optimized for
simple lookups
detail lookups
what are two characterictics of real time data processing?
Data is processed periodically
Low latency is expected
High latency is acceptable
Data is processed as it is created
Azure data studio can be used to query an Azure SQL db from a device that runs macOS
yes
no
Microsoft SSMS enables users to create and use SQL notebooks
yes
no
Azure data studio can be used to resstore a db
yes
no
your company needs to design a db that shows how changes traffic in one area of a network affect other components on the network. Which type of data store should you use?
coloumn
doucment
graph
key
Which two azure services can be used to provision spark clusters
Azure HDInsight
Azure log analytics
Azure Time series Insights
Azure Databricks
which storage solution supports role base access control (RBAC) at the file and folder?
Azure Queue Storage
Azure Blob Storage
Azure Disk Storage
Azure Data Lake
Which command line tool can you use to query Azure SQL db?
sqlcmd
Az data
bcp
Azure CLI
you are deploying a software as a SSAS application that requires a relational db for OLTP. Which azure service should you use to support the application?
azure cosmos DB
Azure sql db
Azure HCM
Azure synapse analytics
which two activities can be performed entirely by using the Microsoft Power BI service?
report sharing an distribution
Data acquisition and preparation
data modelling
report and dashboard creation
your company is designing an application that will write a high volume of JSON data and will have an application defined schema
key
document
graph
column
in azure data factory you can use ... to orchestrate pipeline activities that depend on the output of other pipeline actovities
a control flow
a linked serviice
a dataset
an integration runtime
At which two level can you set the throughput for an Azure Cosmos DB account?
container
item
partition
databse
you need to ensure that users use multi factor aunthentication (MFA) when connectong to an Azure SQL db. Which type of authentication should you use?
SQL authentication
Service principal autjentication
certificate authenticatio
Azure active directory authenticatio
when investigating data from Azure Data Lake storage across Azure region, you will include cost or badnwith
yes
no
you can use blob, table, and file storage in the same Azure Storage account
yes
no
you implement Azure Data Lake Storage by creating an Azure Storage account
yes
no
which azure SQL offering supports automatic db scaling and automatic parsing of the db during inactive periods?
Azure SQL managed instance
Azure SQL db serverless
Azure SQL db hyperscale
Azure SQL db elastic pod
you have an application that nums on Windows and requires acess to a mapped drive. Which azure service should you use?
azure file
azure blob storage
azure cosmos DB
azure table
what is the benefit of the azure cosmos DB table API a compared to azure table storage?
supports partitioning
provieds resiliency if
supports a multimaster model
provied a higher storage capacity
you have a qa application that needs data form a data warehouse. which type of processing does the application use?
online transaction processing (OLTP)
Batch processing
Online Analytical Processing (OLAP)
stream processing
whwn you create an Azure db, which account can always connect to the db?
the azure active director
the server admin login account
the azure active directly
the sa account
you have a transactional application that stem data in azure sql managed instance. When should you implement a reda only db replica?
You need to generate reports without affecting the transactional workload.
You need to audit the transactional application.
You need to implement high availability in the event of a regional outage.
You need to improve the recovery point objective (RPO).
Which statement is an example of Data Manipulation Language(DML)?
insert
disable
alter
drop
