By default, each Azure SQL database is protected by

You need to design and model a database by using a graphical tool that supports project-oriented offline database development. What should you use?

Prevent access to an Azure SQL database from another network.

Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database

Ensure that sensitive data never appears as plain text in an Azure SQL database

You have a transactional application that stores data in an Azure SQL managed instance. When should you implement a read-only database replica?

A relational database must be used when

Relational data uses _____ to enforce relationships between different tables.

____ is a virtual table that contains content defined by a query.

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.

Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?

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?

Which setting can only be configured during the creation of an Azure Cosmos DB account?

identify the type of data stores appropriate to the scenario below.

Application users and their default language.

identify the type of data stores appropriate to the scenario below.

Medical images and their associated metadata

identify the type of data stores appropriate to the scenario below.

Employee data that shows the relationship between employees

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.

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

Which storage solution supports role-based access control (RBAC) at the file and folder level?

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?

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

identify the Azure Cosmos DB APIs to the appropriate data structures.

Graph data

identify the Azure Cosmos DB APIs to the appropriate data structures.

JSON documents

identify the Azure Cosmos DB APIs to the appropriate data structures.

Key/value data

To configure an Azure Storage account to support both security at the folder level and atomic directory manipulation.

You can query a graph database Azure Cosmos DB

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

Your company needs to design a database that shows how changes in network traffic in one area of a network affect network traffic in other areas of the network. Which type of data store should you use?

Azure Databricks can consume data from Azure SQL Database

Azure Databricks can consume data from Azure Event Hubs

Azure Databricks can consume data from Azure Cosmos DB

Enables the use of SQL queries against data stored in JSON documents

Enables users to access data by using the Server Message Block (SMB) version 3 protocol

When provisioning an Azure Cosmos DB ____, you need to specify which type of API you will use.

You need to store data by using Azure Table storage. What should you create first?

You need to recommend a data store service that meets the following requirements:✑ Native SQL API access✑ Configurable indexes.

What should you recommend?

Azure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions.

Azure Table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions.

An Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different Azure regions.

An Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different Azure regions.

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?

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?

Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart. Which type of data store will provide the lowest latency to retrieve the data?

You have an application that runs on Windows and requires access to a mapped drive.Which Azure service should you use?

The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account.

Partition keys are used in Azure Cosmos DB to optimize queries

Items contained in the same Azure Cosmos DB partition can have different partition keys.

Your company is designing an application that will write a high volume of JSON data and will have an application-defined schema. Which type of data store should you use?

You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file. Which type of data store should you recommend?

Your company is designing a data store for internet-connected temperature sensors. The collected data will be used to analyze temperature trends. Which type of data store should you use?

Copying data to Azure Data Lake Storage from another region results in extra cost.

You can use blob, table, and file storage in the same Azure Storage account.

You implement Azure Data Lake Storage by creating an Azure Storage account.

When using the Azure Cosmos DB Gremlin API, the container resource type is projected as a

At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Azure Table storage supports multiple read replicas.

Azure Table storage supports multiple write replicas.

The Azure Cosmos DB Table API supports multiple read replicas.

The Azure Cosmos DB Table API supports multiple write replicas.

____ is an Azure Synapse Analytics feature that retrieves data from Azure Blob Storage by using Transact-SQL queries.

You need to gather real-time telemetry data from a mobile application. Which type of workload describes this scenario?

You have a dedicated SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours. You need to minimize the cost of the dedicated SQL pool as much as possible during idle times. The solution must ensure that the data remains intact. What should you do on the dedicated SQL pool?

Which Azure Data Factory component initiates the execution of a pipeline?

Your company has a reporting solution that has paginated reports. The reports query a dimensional model in a data warehouse.Which type of processing does the reporting solution use?

Identify the type of activities to the appropriate Azure Data Factory activity below.

Copy

Identify the type of activities to the appropriate Azure Data Factory activity below.

Mapping of data flow

Identify the type of activities to the appropriate Azure Data Factory activity below.

Lookup

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Which two activities can be performed entirely by using the Microsoft Power BI service without relying on Power BI Desktop? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

In Azure Data Factory, you can use ____ to orchestrate pipeline activities that depend on the output of other pipeline activities

You need to develop a solution to provide data to executives. The solution must provide an interactive graphical interface, depict various key performance indicators, and support data exploration by using drill down. What should you use in Microsoft Power BI?

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.NOTE: Each correct selection is worth one point.

You have a quality assurance application that reads data from a data warehouse. Which type of processing does the application use?

Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

A Microsoft Power BI dashboard is associated with a single workspace.

A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook.

Which Azure Data Factory component provides the compute environment for activities?

What are two uses of data visualization? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You need to use Transact-SQL to query files in Azure Data Lake Storage Gen 2 from an Azure Synapse Analytics data warehouse.What should you use to query the files?

You can copy a dashboard between Microsoft Power BI workspaces.

A Microsoft Power BI dashboard can only display visualizations from a single dataset.

A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook.

What is the primary purpose of a data warehouse?

In data warehousing workload, data

A pipeline is a representation of a data structure within Azure Data Factory

Azure Data Factory can execute other pipelines

A processing step within Azure Data Factory is an activity

Output data to Parquet format

Store data that is in Parquet format

Persist a tabular representation of data that is stored in parquet format

Azure Synapse Analytics scales storage and compute independently

Azure Synapse Analytics can be paused to reduce compute costs

Am Azure Synapse Analytics data warehouse has a fixed storage capacity

What should you use to build a Microsoft Power BI paginated report?

Azure Databricks is an Apache Spark-based analytics

Azure Analysis Services is used for transactional workloads

Azure Data Factory orchestrates data integration workflows

Which scenario is an example of a streaming workload?

Batch workloads

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?

Which T-SQL command is use in index?