README.md

A Microsoft Power BI [...] enables users to create highly formatted, fixed-layout documents archiving.

• dashboard.
• interactive report.
• paginated report.
• subscription.

Platform as a service (PaaS) database offerings in Azure provide built-in high availability.

• Yes.
• No.

Platform as a service (PaaS) database offerings in Azure provite configuration scaling options.

• Yes.
• No.

Platform as a service (PaaS) database offerings in Azure reduce the administrative overhead for managing hardware.

• Yes.
• No.

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.

Stream processing has access to the most recent data received or data within a rolling time window.

• Yes.
• No.

Batch processing must occur immediately and have latency in the order of second or milliseconds.

• Yes.
• No.

Stream processing in used for simple response functions, aggregates, or calculations such as rolling averages.

• Yes.
• no.

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 Cosmos D3.
• Azure Synapse Analytics.
• Azure HCMmtghi.
• Azure SQL Database.

Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems.

• Yes.
• No.

Extract, load, and transform (ELT) transforms data by using a compute resource independent of the source system and destination system.

• Yes.
• No.

Extract, load, and transform (ELT) minimizes the time it takes to copy large volumes of data to destination systems.

• Yes.
• No.

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

• Azure FilesB.
• Azure Blob storageC.
• Azure Table storageD.
• Azure Cosmos DB.

Batch processing can output data to a file store.

• Yes.
• No.

Batch processing can output data to a relational database.

• Yes.
• No.

Batch processing can output data to a NoSQL database.

• Yes.
• No.

What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

• Native support for cross-database queries and transactions.
• Built-in high availability.
• System-Initiated automatic backups.
• Support for encryption at rest.

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense. What should the developers use?

• Azure Data Studio.
• Sq1cmdC.
• Microsoft SQL Server Management Studio (SSMS).
• Azure Data Explorer.

Batch workloads [...].

• process data in memory, row-by-row.
• collect and process data at most once a day.
• process data as new data is received in near real-time.
• collect data and then process the data when a condition is met.

A block of code that runs In a database Is callea [...].

• a stored procedure.
• a table.
• a view.
• an index.

Match the types of activities to the appropriate Azure Data Factory activities.

• Copy: Data movement. Mapping data flow: Data transformation. Until: Control.
• Copy: Data transformation. Mapping data flow: Data movement. Until: Control.
• Copy: Data movement. Mapping data flow: Control. Until: Data transformation.
• Copy: Data transformation. Mapping data flow: Control. Until: Data movement.

You have the following SQL query. INSERT INTO dbo.Products (ProductID, ProductName, Price, ProductDescription) Values (1,'Calmp',12.48,'Workbench clamp');

• Dbo.Products: A table. ProductName: A column.
• Dbo.Products: A table. ProductName: An index.
• Dbo.Products: An index. ProductName: A database.
• Dbo.Products: A database. ProductName: A table.

Relational data is stored in [...].

• A file system as unstructured data.
• A hierarchal folder structure.
• A tabular form of rows and columns.
• Comma-separated value (CSV) files.

A key/value data store is optimized for [...].

• Enforcing constraints.
• Simple lookups.
• Table joins.
• Transactions..

Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS.

• Yes.
• No.

Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks.

• Yes.
• No.

Azure Data Studio can be used to restore a database.

• Yes.
• No.

Which command should you run?

• Az scorage share create.
• Az scorage account creace.
• Az cosmosdb creace.
• Az scorage concainer creace.

Which Azure service should you use?

• Azure Cosmos DB.
• Azure Table storage.
• Azure Files.
• Azure Blob Storage.

At which two levels can you set the throughput for an Azure Cosmos DB account?

• Container.
• Item.
• Database.
• Partition.

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?

• A waterfall chart.
• A ribbon chart
• A bar chart.
• A decomposition tree.

Physically sorts the data in a table based on the values in specified column [...].

• A view.
• A clustered index.
• A stored procedure.
• A nonclustered index.

In an object associated with a table that sorts and stores the data rows in the table based on their ket values [...].

• A clustered index.
• A FileTable.
• A foreing key.
• A stored procedure.

A job that processes sales data once daily in na example of a batch workload.

• Yes.
• No.

A job that calculates a rolling average temperature readling in an example of a streaming workload.

• Yes.
• No.

A job that calculates average revenue per product for the last month in an example pf a streaming workload.

• Yes.
• No.

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

• Online Transaction Processing (OLTP)
• Batch processing.
• Online Analytical Processing (OLAP).
• Stream processing.

Your company needs to design a database 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?

• Key/value.
• Graph.
• Documentd.
• Columnar.

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.

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

• Enable the hierarchical namespace.
• Set Account kind to BlobStorage.
• Set Performance to Premium.
• Set Replication to Read-access geo-redundant storage (RA-GRS).

Match the security components to the appropriate scenarios.

• Prevent access to an Azure SQL database from another network: Encryption. Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database: Firewall. Ensure that sensitive data never appears as plain text in an Azure SQL database: Authentication.
• Prevent access to an Azure SQL database from another network: Authentication. Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database: Firewall. Ensure that sensitive data never appears as plain text in an Azure SQL database: Encryption.
• Prevent access to an Azure SQL database from another network: Firewall. Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database: Authentication. Ensure that sensitive data never appears as plain text in an Azure SQL database: Encryption.
• Prevent access to an Azure SQL database from another network: Authentication. Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database: Encryption. Ensure that sensitive data never appears as plain text in an Azure SQL database: Firewall.

You can use Azure Data Studio to query a Microsoft SQL Server big data cluster.

• You.
• No.

You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse.

• Yes
• No.

You can use MySQL Workbench to query Azure Database for MariaDB databases.

• Yes.
• No.

A relational database is appropriate for scenarios that involve a high volume of [...].

• changes to realtionships between entites.
• geographically distributed writes.
• transactional writes.
• writes that have varying data structures.

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

• Yes.
• No.

Partition keys are used in Azure Cosmos DB to opyimize queries.

• Yes.
• No.

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

• Yes.
• No.

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

• Online Transaction Processing (OLTP).
• Batch.
• Massively parallel processing (MPP).
• Streaming.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

• INSERT.
• MERGE.
• UPDATE.
• CREATE.

Match the types of data stores to the appropriate scenarios. [...] Application users and their and default language.

• Graph.
• Object.
• Key/value.

Match the types of data stores to the appropriate scenarios. [...] Medical images and their associated metadata.

• Graph.
• Object.
• Key/value.

Match the types of data stores to the appropriate scenarios. [...] Employee data that shows the realtionships between employees.

• Graph.
• Object.
• Key/value.

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?

• Document.
• Columnar.
• Graph.
• Time series.

Azure Table storage supports multiple read replicas.

• Yes.
• No.

Azure Table storage supports multiple write regions.

• Yes.
• No.

The Azure Cosmos DB Table API supports multiple read replicas.

• Yes.
• No.

The Azure Cosmos DB Table API supports multiple write regions.

• Yes.
• No.

Match the types of workloads the appropriate scenario. [...] Data for a product catalog vail be loaded every 12 hours to a data warehouse.

• Batch.
• Micro-batch
• Streaming.

Match the types of workloads the appropriate scenario. [...] Data for online purchases will be loaded to a Gata warehouse as the purchases occur.

• Batch.
• Micro-batch
• Streaming.

Match the types of workloads the appropriate scenario. Updates to inventory data will be loaded to adata warehouse every 1,000 transactions.

• Batch.
• Micro-batch
• Streaming.

Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance. Which Azure service should you use?

• Azure HDInsight.
• Azure SQL Database.
• Azure Cosmos DB.
• SQL Server on Azure virtual machines.

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

• Azure SQL Database Hyperscale.
• Azure SQL managed instance.
• Azure SQL Database serveless.
• Azure SQL Database elastic pod.

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

• Control flow.
• Linked services.
• Datasets.
• The integration runtime.

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?

• Microsoft SQL Server Management Studio (SSMS).
• Azure Data Studio.
• Azure CLID.
• Azure PowerShell.

What are three characteristics of an Online Transaction Processing (OLTP) workload?

• Denormalized data.
• Heavy writes and moderate reads.
• Light writes and heavy reads.
• Schema on write.
• Schema on read.
• Normalized data.

What are two uses of data visualization?

• Represent trends and patterns over time.
• Communicate the significance of data.
• Implement machine learning to predict future values.
• Consistently implement business logic across reports.

Your company recently reported sales from the third quarter. You have the chart shown in the following exhibit. Which type of analysis is shown for the fourth quarter?

• Predictive.
• Prescription.
• Descriptive.
• Diagnostic

Which three actions are used when performing diagnostic analytics?

• Identify data anomalies. Collect anomaly-related data. Discover relationships and trends that explain anomalies.
• Identify data anomalies. Predict when anomalies are likely to recur. Use analytical tools such as decision trees and regression.
• Apply serf-learning loops to draw inferences from anomalies. Predict when anomalies are likely to recur. Use analytical tools such as decision trees and regression.
• Identify data anomalies. Use machine learning to find patterns in large datasets. Discover relationships and trends that explain anomalies.

Platform as a service (PaaS) database offerings in Azure require less seup and configuration effort than infrastructure as a service (IaaS) database offering [...].

• Yes.
• No.

Platform as a service (PaaS) database offerings in Azure provide administrators with the ability to control adn update the operating system version [...].

• Yes.
• No.

All platform as a service (PaaS) database offerings in Azure can be paused to reduce version [...].

• Yes.
• No.

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 pipelines.
• A Synapse SQL pool.
• Synapse Link.
• Synapse Studio.

A [...] in a chcat 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 nest within the main rectangle.

• line chart.
• matrix.
• scatter.
• treemap.

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

• Microsoft SQL Server Data Tools (SSDT).
• Microsoft SQL Server Management Studio (SSMS).
• Azure Databricks.
• Azure Data Studio.

What are two benefits of platform as a service (PaaS) relational database offerings in Azure, such as Azure SQL Database?

• Complete control over backup and restore processes.
• Access to the latest features.
• In-database machine learning services.
• Reduced administrative effort for managing the server infrastructure.

Which statement is an example of Data Definition Language (DDL)?

• SELECT.
• INSERT.
• DELETE.
• DROP.

Azure Databricks is an Apache Spark-based collaborative analytics platform.

• Yes.
• No.

Azure Analysis Services is used for transactional workloads.

• Yes.
• No.

Azure Data Factory orchestrates data integration workflows.

• Yes.
• No.

Which statement is an example of Data Manipulation Language (DML)?

• REVOKE.
• DISABLE.
• CREATE.
• UPDATE.

Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?

• Azure Queue storage.
• Azure Data Lake Storage.
• Azure table storage.
• Azure Files.

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

• Geo-redundancy.
• Multi-region writes.
• Production or non-reduction account type.
• API.

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

• Azure Files.
• Azure Table storage.
• Azure Cosmos DB.
• Azure Blob Storage.

[...] is a virtual table that contains content definey by a querty.

• A heap.
• A stored procedure.
• A view.
• An index.

What is the primary purpose of a data warehouse?

• To provide answers to complex queries that rely on data from multiple sources.
• To provide transformation services between source and target data stores.
• To provide read-only storage of relational and non-relational historical data.
• To provide storage for transactional line-of-business (LOB) applications.

Which storage solution supports access control lists (ACLs) at the file and folder level?

• Azure Data Lake Storage.
• Azure Cosmos DB.
• Azure Queue storage.
• Azure Blob storage.

Azure SQL managed instance supports cross-database queries.

• Yes.
• No.

Azure SQL managed instance supports user-created backups.

• Yes.
• No.

Azure SQL managed instance databases can be restored to SQL Server on a Azure virtual machine.

• Yes.
• No.

Match the Azure data factory components to the appropriate descriptions.

• A representation of data structures within data stores: Dataset. The information used to connect to external resources: Linked service. A logical grouping of activities that performs a unit of work and can be scheduled: Pipeline.
• A representation of data structures within data stores: Linked service. The information used to connect to external resources: Dataset. A logical grouping of activities that performs a unit of work and can be scheduled: Mapping data flow.
• A representation of data structures within data stores: Pipeline. The information used to connect to external resources: Mapping data flow. A logical grouping of activities that performs a unit of work and can be scheduled: Dataset.
• A representation of data structures within data stores: Mapping data flow. The information used to connect to external resources: Pipeline. A logical grouping of activities that performs a unit of work and can be scheduled: Linked services.

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

• A linked service.
• An integration runtime.
• A control flow.
• A pipeline.

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

• Azure Files.
• Azure Blob storage.
• Azure Cosmos DB.
• Azure Table storage.

Match the types of analytics that can be used to answer the business questions.

• Why did sales increase last month?: Cognitive. How do I allocate my budget to buy different inventory items?: Predictive. Which people are mentioned in a company's business documents?: Prescriptive.
• Why did sales increase last month?: Diagnostic. How do I allocate my budget to buy different inventory items?: Predictive. Which people are mentioned in a company's business documents?: Cognitive.
• Why did sales increase last month?: Descriptive. How do I allocate my budget to buy different inventory items?: Prescriptive. Which people are mentioned in a company's business documents?: Predictive.
• Why did sales increase last month?: Predictive. How do I allocate my budget to buy different inventory items?: Prescriptive. Which people are mentioned in a company's business documents?: Diagnostic.

Match the Azure services to the appropriate locations in the architecture.

• Ingest: Azure Data Factory. Preprocess & model: Azure Synapse Analytics.
• Ingest: Azure Data Factory. Preprocess & model: Azure Cognitive Search.
• Ingest: Azure Synapse Analytics. Preprocess & model: Azure Cognitive Search.
• Ingest: Azure Cognitive Search. Preprocess & model: Azure Synapse Analytics.

You must apply patches to Azure SQL databases 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 databases.

• Yes.
• No.

If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates.

• Yes.
• No.

If you have a platform as a service (PaaS) database in Azure, backups are performed automatically.

• Yes.
• No.

If you have a platform as a service (PaaS) database in Azure, you are responsible for upgrading the database engine.

• Yes.
• No.

A visualization that shows a university's current student enrollment versus the maximum capacity is an example of [...] analytics.

• cognitive.
• descriptive.
• predictive.
• prescriptive.

Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.

• Box 1: File system. Box 2: File share.
• Box 1: Azure Storage account. Box 2: File system.
• Box 1: File share. Box 2: File system.
• Box 1: Azure Storage account. Box 2: File share.

You can copy a dashboard between Microsoft Power BI workspaces.

• Yes.
• No.

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

• Yes.
• No.

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

• Yes.
• No.

You can query a graph database in Azure Cosmos DB [...].

• 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 by using the Gremlin language.

At which level in Azure Cosmos DB can you configure multiple write regions and read regions?

• database.
• partition.
• collection.
• account.

Extract Trandform Load (ETL).

• Azure Analysis Services.
• Azure Data Factory.
• Azure Table storage.
• Azure Cosmos DB.
• Azure Synapse Analytics.

Data warehouse.

• Azure Analysis Services.
• Azure Data Factory.
• Azure Table storage.
• Azure Cosmos DB.
• Azure Synapse Analytics.

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

• Azure Disk Storage.
• Azure Data Lake Storage.
• Azure Blob storage.
• Azure Queue storage.

What should you use in Microsoft Power BI?

• A dashboard.
• Microsoft Power Apps.
• A dataflow.
• A report.

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.

An extract, transform, and load (ETL) process requires [...].

• a matching schema in the data source and the 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.

Which two Azure services can be used to provision Apache Spark clusters?

• Azure Time Series Insights.
• Azure HDInsight.
• Azure Databricks.
• Azure Log Analytics.

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.

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

• Multi-master replication.
• Availability Zones.
• Automatic failover.
• The strong consistency level.

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

• JOIN.
• VALUES.
• Set.
• KEY.

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

• Power BI report Builder.
• Power BI Desktop.
• Charticulator.
• The Power BI service.

You need to modify a view in a relational database by adding a new column. Which statement should you use?

• MERGE.
• ALTER.
• INSERT.
• UPDATE.

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.

Transcribing audio files is an example of [...] analytics.

• Cognitive.
• Descriptive.
• Predictive.
• Prescriptive.

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?

• key/value.
• graph.
• columnar.
• document.

Which two Azure services can be used to provision Spark clusters?

• Azure Databricks.
• Azure Log Analytics.
• Azure Time Series Insights.
• Azure HDinsight.

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file. What should the developers use?

• Azure Data Studio.
• sq1cmd.
• Microsoft SQL Server Management Studio (SSMS).
• Azure Data Explorer.

You need to recommend a non-relational data store that is optimized for storing and retrieving files, videos, audio stream, 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?

• document.
• key/value.
• object.
• columnar.

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

• Graph data: Cassandra API. JSON documents: Table API. Key/value data: MongoDB API.
• Graph data: Gremlin API. JSON documents: MongoDB API. Key/value data: Table API.
• Graph data: Table API. JSON documents: Gremlin API. Key/value data: Cassandra API.
• Graph data: Gremlin API. JSON documents: MongoDB API. Key/value data: Table API.

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.
• key/value.
• document.
• columnar.

Which type of data store should you recommend?

• Document.
• Key/value.
• Object.
• Columnar.

When ingesting data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth.

• 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.

You have an Azure SQL database that you access directly from the internet. You recently changed your external IP address. 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.
• Role-based access control (RSAC).
• Dynamic Host Configuration Protocol (DHCP).
• Domain Name Service (DNS).

A pipeline is a representation of a data structure 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.

A bar chart showing year-to date sales by regionis an example of which type of analytics?

• Descriptive.
• Diagnostic.
• Predictive.
• Prescriptiv.

Azure Databricks can consume data from Azure SQL Databate.

• Yes.
• No.

Azure Databricks can consume data from Azure Event Hubs.

• Yes.
• No.

Azure Databricks can consume data from Azure Cosmos DB.

• Yes.
• No.

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

• A control flow.
• A trigger.
• A parameter.
• An activity.

Relational database tables contain columns and rows.

• Yes.
• No.

Indexes in a relational database describe the data types in a table.

• Yes.
• No.

A database view is a virtual table whose content is defined by a query.

• Yes.
• No.

Which three requirements must be met to query the table from the internet?

• You must be assigned the Reader role for the resource group that contains the database.
• 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.

When can you use an Azure Resource Manager template?

• To automate the creation of an interdependent group of Azure resources in a repeatable way.
• To automate the creation of an interdependent and develop can deploy from the Azure portal.
• To provision Azure subscriptions and apply policies for multi-tenant deployments.
• To set complex permissions automatically on existing objects in an Azure subscription.

Which three objects can be added to a Microsoft Power BI dashboard?

• A report page.
• A Microsoft PowerPoint slide.
• A visualization from a report.
• A dataflow.
• A text box.

Which two activities can be performed entirely by using the Microsoft Power BI service?

• Report and dashboard creation.
• Report sharing and distribution.
• Data modeling.
• Data acquisition and preparation.

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

• graph.
• table.
• partition key.
• document.

You are reviewing the data model shown in the following exhibit.

• The data model is a: transactional model. Customer is a [...] table: dimension.
• The data model is a: star schema. Customer is a [...] table: bridge.
• The data model is a: snowflake schema. Customer is a [...] table: dimension.
• The data model is a: snowflake schema. Customer is a [...] table: fact.

A bar chart showing year-to date sales by region is an example of which type of analytics?

• descriptive.
• diagnostic.
• predictive.
• prescriptive.

Match the types of workloads the appropriate scenario.

• Data for a product catalog will be loaded every 12 hours to a data warehouse: Batch. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Streaming. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Micro-batch.
• Data for a product catalog will be loaded every 12 hours to a data warehouse: Micro-batch. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Streaming. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Batch.
• Data for a product catalog will be loaded every 12 hours to a data warehouse: Micro-batch. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Streaming. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Batch.
• Data for a product catalog will be loaded every 12 hours to a data warehouse: Batch. Data for online purchases will be loaded to a Gata warehouse as the purchases occur: Micro-batch. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions: Streaming.

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?

• Extract: The data warehouse. Load: An in-memory data integration tool. Transform: The CRM system.
• Extract: The data warehouse. Load: The CRM system. Transform: An in-memory data integration tool.
• Extract: The CRM system. Load: The data warehouse. Transform: An in-memory data integration tool.
• Extract: The CRM system. Load: An in-memory data integration tool. Transform: The data warehouse.

You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to persist the SQL query so that other users can use the query. What should you create?

• a table.
• an index.
• scalar function.
• a view.

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

• relational.
• columnar.
• graph.
• time series.

In Azure Data Factory, you can use [...] to orchestrate pipeline ctivities that depend on the output of other pipeline activities.

• acontrol flow.
• a dataset.
• a linked service.
• an integration runtime.

Match the Azure services to the appropriate locations in the architecture.

• Extract Transform Load (ETL): Azure Data Factory. Data warehouse: Azure Cosmos DB.
• Extract Transform Load (ETL): Azure Table storage. Data warehouse: Azure Cosmos DB.
• Extract Transform Load (ETL): Azure Data Factory. Data warehouse: Azure Synapse Analytics.
• Extract Transform Load (ETL): Azure Synapse Analytics. Data warehouse: Azure Table storage.