Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DP900 - Haris > DP900 Questions Dump > Flashcards

DP900 Questions Dump Flashcards

1
Q

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

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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.

A

Answer: BCE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Which command-line tool can you use to query Azure SQL databases?

A. sqlcmd
B. bcp
C. azdata
D. Azure CLI

A

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

You have a transactional application that stores data in an Azure SQL managed instance. In which of the following circumstances would you need to 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

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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 SA account
C. The server admin login account of the logical server
D. The Azure Active Directory (Azure AD) administrator account.

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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. Role-based access control (RBAC)
B. Dynamic Host Configuration Protocol (DHCP)
C. Domain Name Service (DNS)
D. A database-level firewall

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A. Azure SQL Database Hyperscale
B. Azure SQL managed instance
C. Azure SQL Database serverless
D. Azure SQL Database elastic pod

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

By default, each Azure SQL database is protected by:

A. A network security group (NSG)
B. A server-level firewall
C. Azure Firewall
D. Azure Front Door

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

A relational database must be used when:

A. A dynamic schema is required.
B. Data will be stored as key/value pairs.
C. Storing large images and videos.
D. Strong consistency guarantees are required.

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

A relational database is appropriate for scenarios that involve a high volume of:

A. Changes to relationships between entities
B. Geographically distributed writes
C. Transactional writes
D. Writes that have varying data structures

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

Transparent Data Encryption (TDE) encrypts:

A. A column to protect data at rest and in transit
B. Queries and their results in order to protect data in transit
C. The database to protect data at rest
D. The server to protect data at rest

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

  1. Azure SQL Database includes a fully managed backup service
  2. Azure SQL Database has built-in high availability
  3. Azure SQL Database can use Azure Advanced Threat Protection (ATP)
A

Answer: 1:Yes, 2:Yes, 3:Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

  1. You must apply patches to Azure SQL databases regularly
  2. You need a Microsoft 365 subscription to create an Azure SQL database
  3. You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases
A

Answer: 1:No, 2:No, 3:Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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.

Components:

A. Authentication
B. Firewall
C. Encryption

Answer Area:

D. Prevent access to an Azure SQL Database from another network.
E. Support Azure AD sign-ins to an Azure SQL database.
F. Ensure that sensitive data never appears as plain text in an Azure SQL database.

A

Answer: BD, AE, CF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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?

A. Stream processing
B. Batch processing
C. Online Analytical Processing (OLAP)
D. Online Transaction Processing (OLTP)

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A. Online Transaction Processing (OLTP)
B. Batch processing
C. Stream processing
D. Online Analytical Processing (OLAP)

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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. Online Analytical Processing (OLAP)
B. Batch Processing
C. Stream processing
D. Online Transaction Processing (OLTP)

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A. Denormalized data
B. Heavy writes and moderate reads
C. Light writes and heavy reads
D. Schema on write
E. Schema on read
F. Normalized data
A

Answer: BDF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

In a data warehousing workload, data:

A. from a single source is distributed to multiple locations
B. from multiple sources is combined in a single location
C. is added to a queue for multiple systems to process
D. is used to train machine learning models

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

Answer: AD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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. SQL Synapse Analytics

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. PaaS database offerings in Azure provide built-in high availability
B. PaaS database offerings in Azure provide configurable scaling options
C. PaaS database offerings in Azure. reduce the administrative overhead for managing hardware

A

Answer: A:Yes, B:Yes, C:Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. If you have a PaaS database in Azure, you are responsible for applying operating system updates.
B. If you have a PaaS database in Azure, backups are performed automatically
C. If you have a PaaS database in Azure, you are responsible for upgrading the database engine

A

Answer: A:No, B:Yes, C:No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. PaaS database offerings in Azure require less setup and configuration effort than IaaS database offerings
B. PaaS database offerings in Azure provide administrators with the ability to control and update the operating system version
C. All PaaS database offerings in Azure can be paused to reduce costs.

A

Answer: A:Yes. B:No, C:No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

What are two uses of data visualization? Each correct answer presents a complete solution.
NOTE: Each correct answer selection is worth one point.

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

A

Answer: AC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

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:

Visualization:

A. Key influencer
B. Scatter
C. Treemap

Answer Area:

D. A chart of colored, nested rectangles that displays individual data points, represented by the size and color of a relative rectangle
E. A chart that displays major contributors of a selected result or value
F. A chart that shows the relationship between two numerical values

A

Answer: CD, AE, BF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. Azure Data Bricks can consume data from Azure SQL Database
B. Azure Data Bricks can consume data from Azure Event Hubs
C. Azure Data Bricks can consume data from Azure Cosmos DB

A

Answer: A:Yes, B:Yes, C:Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

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.

A. Database
B. Item
C. Container
D. SQL Partition

A

Answer: AC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

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

A. Provides resiliency if an Azure region fails
B. Supports partitioning
C. Provides a higher storage capacity
D. Supports a multi-master model

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

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

Answer: AC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

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

A. Multi-master replication
B. Availability zones
C. The strong consistency level
D. Automatic failover

A

Answer: B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

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

A. Database
B. Partition
C. Collection
D. Account

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

You can query a graph database in Azure Cosmos DB…

A. as a JSON document by using a SQL-like language.
B. as a partitioned row store by using Cassandra Query Language (CQL).
C. as a partitioned row store by using Language-Integrated. Query. (LINQ).
D. as nodes and edges by using the Gremlin language.

A

Answer: A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account.
B. Partition keys are used in Azure Cosmos DB to optimize queries.
C. Items contained in the same Azure Cosmos DB logical partition can have different partition keys.

A

Answer: A:No, B:Yes. C:No

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. Azure Table storage supports multiple read replicas
B. Azure Table storage supports multiple write regions
C. The Azure Cosmos DB Table API supports multiple read replicas
D. The Azure Cosmos DB Table API supports multiple write regions

A

Answer: A:Yes, B:No, C:Yes, D:Yes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

Match the datastore services to the appropriate descriptions. To answer, drag the appropriate service from the column on the left to its description on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Select and Place:

Services:

A. Azure Blob storage
B. Azure Cosmos DB
C. Azure Files
D. Azure Table storage

Answer Area:

E. Enables the use of SQL queries against data stored in JSON documents
F. Enables users to access data by using the Server Message Block (SMB) version 3 protocol.

A

Answer: BE, CF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

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.

A. Azure Time Series Insights
B. Azure HDInsight
C. Azure Databricks
D. Azure Log Analytics

A

Answer: BC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

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

A

Answer: BD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

Which scenario is an example of a streaming workload?

A. Sending transactions that are older than a month to an archive
B. Sending transactions daily from point of sale (POS) devices
C. Sending telemetry data from edge devices
D. Sending cloud infrastructure metadata every 30 minutes

A

Answer: C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

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

A. Online Transaction Processing (OLTP)
B. Batch processing
C. Massively Parallel Processing (MPP)
D. Streaming

A

Answer: D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

Batch workloads

A. process data in memory, row-by-row.
B. collect and process data at most one a day.
C. process data as new data is received in near real-time.
D. collect data and then process the data when a condition is met.

A

Answer: D

45
Q

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:

Workload Types:

A. Batch
B. Streaming

Answer Area:

C. Analyzing web traffic from the past year
D. Classifying images that were uploaded last month.
E. Tracking how many people are currently using a website

A

Answer: AC, AD, BE

46
Q

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:

Workload Types:

A. Batch
B. Streaming

Answer Area:

C. Data for a product catalog will be loaded every 12 hours to a data warehouse
D. Data for online purchases will be loaded to a data warehouse as the purchase occurs
E. Updates to inventory data will be loaded to a data warehouse every 1,000 transactions

A

Answer: AC, BD, AE

47
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

A. Processing salary payments once a month is an example of a batch workload
B. A wind turbine that sends 50 sensor readings per second is an example of a streaming workload
C. A home electricity meter that sends readings once a day to an energy provider is an example of a streaming workload

A

Answer: A:Yes, B:Yes, C:No

48
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

In batch processing

A. data is always inserted one row at a time
B. data is processed in real-time
C. latency is expected
D. processing can only execute serially

A

Answer: C

49
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. Batch processing can output data to a file store
B. Batch processing can output data to a relational database
C. Batch processing can output data to a NoSQL database

A

Answer: A:Yes, B:Yes, C:Yes

50
Q

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)

A

Answer: BD

51
Q

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 of the following service within an Azure storage account could you use for this purpose?

A. Queue
B. Blob
C. File
D. Table

A

Answer: C

52
Q

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

A. Azure Files
B. Azure Blob storage
C. Azure Cosmos DB
D. Azure Table storage

A

Answer: A

53
Q

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

A. Azure Disk Storage
B. Azure Data Lake Storage
C. Azure Blob storage
D. Azure Queue storage

A

Answer: B

54
Q

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?

A. Archive
B. Hot
C. Cool

A

Answer: A

55
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

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

A. enable the hierarchical namespace
B. set Account kind to BlobStorage
C. set Performance to Premium
D. set Replication to Read-access geo-redundant storage (RA-GRS)

A

Answer: A

56
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

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

A. graph
B. table
C. partition key
D. document

A

Answer: A

57
Q

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:

Data Store Types:

A. Graph
B. Object
C. Key/Value

Answer Area:

D. Application users and their default language
E. Medical images and their associated metadata
F. Employee data that shows the relationships between employees

A

Answer: AF, BE, CD

58
Q

Match the Azure Cosmos DB APIs to the appropriate data structures. To answer, drag the appropriate API from the column on the left to its data structure on the right. Each API may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Select and Place:

APIs:

A. Cassandra API
B. Gremlin API
C. MongoDB API
D. Table API

Answer Area:

E. Graph data
F. JSON documents
G. Key/value data

A

Answer: BE, CF, DG

59
Q

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:

Data Types:

A. Image files
B. Key/value pairs
C. Relationships between employees

Answer Area:

D. Azure Blob storage
E. Azure Cosmos DB Gremlin API
F. Azure Table storage

A

Answer: AD, BF, CE

60
Q

Which of the following is required for an extract, load and transform (ELT) process?

A. A data pipeline that includes a transformation engine
B. A separate transformation engine
C. A target data store powerful enough to transform the data
D. Data that is fully processed before being loaded to the target data store

A

Answer: C

61
Q

To complete the sentence, select the appropriate option in the answer area

Answer Area:

An extract, transform, and load (ETL) process requires…

A. a matching schema in the data source and the data target
B. a target data store powerful enough to transform data
C. data that is fully processed before being loaded to the target data store
D. that the data target be a relational database

A

Answer: C

62
Q

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.
NOTE: Each correct match is worth one point.

Select and Place:

Locations:

A. An in-memory data integration tool
B. The CRM system
C. The data warehouse

Answer Area:

D. Extract
E. Load
F. Transform

A

Answer: AF, BD, CE

63
Q

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

Answer: A

64
Q

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

A

Answer: B

65
Q

A set of developers have computers that run Windows 10 and Ubuntu Desktop. They need to connect and query an Azure SQL database from their computer. The developers require code assistance features such as IntelliSense. Which of the following can be used for this requirement?

A. Azure Data Studio
B. SSMS
C. Azure Data Explorer

A

Answer: A

66
Q

Which is not a tool to access DB?

A. Query Editor
B. Data Studio
C. Storage Explorer
D. VS Code

A

Answer: C

Explanation: All others can be used to access DB

67
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS.
B. Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks.
C. Azure Data Studio can be used to restore a database.

A

Answer: A:Yes, B:No, C:Yes

68
Q

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:

Tools:

A. Azure Data Studio
B. Microsoft SQL Server Data Tools (SSDT)
C. Microsoft SQL Server Mgmt Studio (SSMS)
D. Microsoft Visual Studio Code

Answer Area:

E. A graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management and administration tasks.

F. A lightweight source code editor with an mssql extension that supports connections to SQL Server and a rich editing experience for T-SQL

G. A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files.

H. A development tool for building Azure SQL databases, Microsoft SQL Server relational databases, SQL Server Analysis Services (SSAS) data models, SQL Server Integration Services (SSIS) packages, and SQL Server Reporting Services (SSRS) reports.

A

Answer: CE, DF, AG, BH

69
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. You can use Azure Data Studio to query a Microsoft SQL Server big data cluster
B. You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse
C. You can use MySQL Workbench to query Azure Database for MariaDB databases

A

Answer: A:Yes, B:Yes, C:Yes

70
Q

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

A. A linked service
B. An integration runtime
C. A control flow
D. A pipeline

A

Answer: B

71
Q

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

A. A control flow
B. A trigger
C. A parameter
D. An activity

A

Answer: B

72
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

In Azure Data Factory, you can use…

A. a control flow
B. a dataset
C. a linked service
D. an integration runtime

…to orchestrate pipeline activities that depend on the output of other pipeline activities.

A

Answer: A

73
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. Azure Databricks is an Apache Spark-based collaborative analytics platform
B. Azure Analysis Services is used for transactional workloads
C. Azure Data Factory orchestrates data integration workflows

A

A:Yes, B:No, C:Yes

Explanation: Azure Analysis Services is used for Data Warehousing

74
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Answer Area:

A. A pipeline is a representation of a data structure within Azure Data Factory
B. Azure Data Factory pipelines can execute other pipelines
C. A processing step within an Azure Data Factory pipeline is an activity

A

Answer: A:No, B:Yes, C:Yes

Explanation: Datasets represents a data structure in Azure Data Factory

75
Q

Match the Azure services to the appropriate requirements. To answer, drag the appropriate service from the column on the left to its requirement on the right. Each service may be used once, more than once, or not at all.

Select and Place:

Services:

A. Azure Data Factory
B. Azure Data Lake Storage
C. Azure SQL Database
D. Azure Synapse Analytics

Answer Area:

E. Output data to Parquet format
F. Store data that is in Parquet format
G. Persist a tabular representation of data that is stored in Parquet format

A

Answer: AE, BF, DG

76
Q

Match the types of activities to the appropriate Azure Data Factory activities. To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Select and Place:

Activity Types:

A. Control
B. Data movement
C. Data transformation

Answer Area:

D. Copy
E. Mapping data flow
F. Until

A

Answer: AF, BD, CE

77
Q

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:

Components:

A. Dataset
B. Linked service
C. Mapping data flow
D. Pipeline

Answer Area:

E. A representation of data structures within data stores
F. The information used to connect to external resources
G. A logical grouping of activities that performs a unit of work and can be scheduled

A

Answer: AE, BF, DG,

78
Q

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?

A. Key/value
B. Columnar
C. Object
D. Document

A

Answer: C

79
Q

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?

A. Columnar
B. Key/value
C. Document
D. Graph

A

Answer: B

Explanation: In key/value stores schema values must be defined by the application

80
Q

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

A. Document
B. Columnar
C. Graph
D. Time series

A

Answer: A

Explanation: Schema is flexible and not application-defined

81
Q

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?

A. Key/value
B. Graph
C. Columnar
D. Document

A

Answer: C

Explanation: Column family stores have high throughput with low latency

82
Q

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?

A. Relational
B. Time series
C. Graph
D. Columnar

A

Answer: B

83
Q

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

A. Graph
B. Key/value
C. Document
D. Columnar

A

Answer: A

Explanation: Performs queries across nodes and edges and analyzes network of relationships

84
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

A key/value data store is optimized for…

A. enforcing constraints
B. simple lookups
C. table joins
D. transactions

A

Answer: B

85
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Answer Area:

A. When ingesting data from Azure Data Lake Storage across Azure regions, you will incur costs for bandwidth
B. You can use blob, table, and file storage in the same Azure Storage account
C. You implement Azure Data Lake Storage by creating an Azure Storage account

A

Answer: A:Yes, B:Yes, C:Yes

86
Q

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

A. Descriptive
B. Diagnostic
C. Predictive
D. Prescriptive

A

Answer: B

87
Q

I have a car showroom and I am thinking to open a new branch of my showroom. I want to find out where I should open my new showroom based on sales data. Which analytics will tell me that?

A. Descriptive
B. Diagnostic
C. Predictive
D. Prescriptive

A

Answer: A

88
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

Transcribing audio files is an example of…

A. cognitive
B. descriptive
C. predictive
D. prescriptive

analytics.

A

Answer: A

89
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

Descriptive analytics tells you…

A. what is most likely to occur in the future
B. what occurred in the past
C. which actions you can perform to affect outcomes
D. why something occurred in the past

A

Answer: B

90
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

A visualization that shows a university’s current student enrollment versus the maximum capacity is an example of…

A. cognitive
B. descriptive
C. predictive
D. prescriptive

analytics.

A

Answer: B

91
Q

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:

Analytics Types:

A. Cognitive
B. Diagnostic
C. Descriptive
D. Predictive
E. Prescriptive

Answer Area:

F. Why did sales increase last month?
G. How do I allocate my budget to buy different inventory items?
H. Which people are mentioned in a company’s business documents?

A

Answer: BF, EG, CH

92
Q

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

A. Scale down the data warehouse units (DWUs)
B. Pause the pool
C. Create a user-defined restore point
D. Delete the pool

A

Answer: B

Explanation: Azure SA provides the ability to pause the pools that hosts your DWs

93
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

Answer Area:

A. Azure SA scales storage and compute independently
B. Azure SA can be paused to reduce compute costs
C. An Azure SA data warehouse has a fixed storage capacity

A

Answer: A:Yes, B:Yes, C:No

94
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

The massively parallel processing (MPP) engine of Azure Synapse Analytics…

A. distributes processing across compute nodes
B. distributes processing across control nodes
C. redirects client connections across compute nodes
D. redirects client connections across control nodes

A

Answer: A

95
Q

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

A. SELECT
B. JOIN
C. MERGE
D. CREATE

A

Answer: D

96
Q

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

A. REVOKE
B. DISABLE
C. INSERT
D. GRANT

A

Answer: C

97
Q

You have designed 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. An index
B. A view
C. A scalar function
D. A table

A

Answer: B

98
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

Relational data uses…

A. collections
B. columns
C. keys
D. partitions

to enforce relationships between different tables.

A

Answer: C

99
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

A. A clustered index
B. A FileTable
C. A foreign key
D. A stored procedure

…is an object associated with a table that sorts and stores the data rows in the table based on their key values.

A

Answer: A

100
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

A. A heap
B. A stored procedure
C. A view
D. An index

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

A

Answer: C

101
Q

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:

Terms:

A. Index
B. View
C. Table

Answer Area:

D. A database object that holds data
E. A database object whose content is defined by a query
F. A database object that helps improve the speed of data retrieval

A

Answer: AF, BE, DC

102
Q

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

A. Charticulator
B. Power BI Desktop
C. Power BI Service
D. Power BI Report Builder

A

Answer: D

103
Q

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

A. Report and dashboard creation
B. Data modeling
C. Report sharing and distribution
D. Data acquisition and preparation

A

Answer: AC

104
Q

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

A. A dashboard
B. A report
C. A dataflow
D. Microsoft Power Apps

A

Answer: B

105
Q

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. A report page
B. A Microsoft PowerPoint slide
C. A visualization from a report
D. A dataflow
E. A text box
A

Answer: ACE

106
Q

To complete the sentence, select the appropriate option in the answer area.

Answer Area:

A Microsoft Power BI…

A. dashboard
B. interactive report
C. paginated report
D. subscription

enables users to create highly formatted, fixed-layout documents optimized for printing and archiving.

A

Answer: C

107
Q

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

A. A Microsoft Power BI dashboard is associated with a single workspace
B. A MS Power BI dashboard can only display visualizations from a single dataset
C. A MS Power BI dashboard can display visualizations from a MS Excel workbook

A

Answer: A:Yes, B:No, C:Yes

Explanation: Reports can only use one dataset but dashboards can use multiple

108
Q

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

A. Azure Functions
B. Microsoft SQL Server Integration Services (SSIS)
C. PolyBase
D. Azure Data Factory

A

Answer: C

Explanation: Easy for use and query T-SQL data with PolyBase

109
Q

Which of the following is an Azure storage solution that provides native support for POSIX-compliant access control lists?

A. Azure Queue storage
B. Azure Data Lake Storage
C. Azure Table Storage
D. Azure Files

A

Answer: B

Explanation: Implements an access control model

DP900 - Haris (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions