Quiz
DP-900
Este quiz tem tipos de pergunta que abrem no player de sempre.
Perguntas do quiz (200)
1Descritpive analytics tells you _____________
- Awhat is most likely to occur in the future
- Bwhat occurred in the past
- Cwhich actions you can perform to affect outcomes
- Dwhy something occurred in the past
2Normalization involves eliminating relationships between databases [blank_start]yes[blank_end]
Normalizing a database reduces data redundancy [blank_start]yes[blank_end]
Normalization improves data integrity [blank_start]yes[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
3In batch processing, _______________
- Adata is always inserted one row at a time
- Bdata is processed in real-time
- Clatency in delivering data processing results is acceptable
- Dprocessing can only execute serially
4Transcribing audio files si an example of [blank_start]cognitive[blank_end] analytics
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
5Match 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.
- ACognitive
- BDiagnostic
- CDescriptive
- DPredictive
- EPrescriptive
- FCognitive
- GDiagnostic
- HDescriptive
- IPredictive
- JPrescriptive
- KCognitive
- LDiagnostic
- MDescriptive
- NPredictive
- OPrescriptive
6You have this JSON.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
Customer is [blank_start]a nested array[blank_end]
Address is a [blank_start]nested array[blank_end]
Social media is a [blank_start]nested array[blank_end]
- Aa nested array
- Ba nested object
- Ca root object
- Dnested array
- Eroot object
- Fnested object
- Gnested array
- Hnested object
- Iroot object
7An extract, transform, and load (ETL) process requires __________
- AA matching schema in the data source and the data target.
- BA target data store powerful enough to transform data.
- CData that is fully processed before being loaded to the target data store.
- DThat the data target be a relational database.
8You are reviewing the data model shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
The data model is a [blank_start][answer choice][blank_end].
Customer is a [blank_start][answer choice][blank_end] table.
- Atransactional model
- Bstar schema
- Csnowflake schema
- Dfact
- Edimension
- Fbridge
9The massively parallel processing (MPP) engine of Azure Synapse Analytics __________
- Adistributes processing across compute nodes.
- Bdistributes processing across control nodes.
- Credirects client connections across compute nodes.
- Dredirects client connections across control nodes.
10_______________ is an object associated with a table that sorts and stores the data rows in the table based on their key values.
- AA clustered index
- BA FileTable.
- CA foreign key
- DA stored procedure
11A relational database is appropiate for scenarios that involve a high volume of _____________
- Achanges to relationships between entities.
- Bgeographically distributed writes.
- Ctransactional writes.
- Dwrites that have varying data strctures.
12For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Batch processing can output data to a file store [blank_start]_____[blank_end]
Batch processing can output data to a relational database [blank_start]_______[blank_end]
Batch processing can output data to a NoSQL database [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
13Your 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. You may need to drag the split bar between panes or scroll to view content.
- AAn in-memory data integration tool
- BThe CRM system
- CThe data warehouse
- DAn in-memory data integration tool
- EThe CRM system
- FThe data warehouse
- GAn in-memory data integration tool
- HThe CRM system
- IThe data warehouse
14A visualization that shows a university's current student enrollment versus the maximum capacity is an example of [blank_start]_________[blank_end] analytics.
- Acognitive
- Bdescriptive
- Cpredictive
- Dprescriptive
15Match 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.
- AKey influencer
- BScatter
- CTreemap
- DKey influencer
- EScatter
- FTreemap
- GKey influencer
- HScatter
- ITreemap
16You 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.- AA. zone-redundant storage (ZRS)
- BB. read-access geo-redundant storage (RA-GRS)
- CC. locally-redundant storage (LRS)
- DD. geo-redundant storage (GRS)
17For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Platform as a service (PaaS) database offerings in Azure require less setup and configuration effort that infrastructure as a service (IaaS) database offerings. [blank_start]____[blank_end]
Platform as a service (PaaS) database offerings in Azure provide end users with the ability to control and update the operating system version. [blank_start]____[blank_end]
All relation and non-relational platform as a service (PaaS) database offerings in Azure can be paused to reduce costs. [blank_start]____[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
18Which statement is an example of Data Manipulation Language (DML)?
- AA. REVOKE
- BB. DISABLE
- CC. INSERT
- DD. GRANT
19You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to create a database object that would allow other users to rerun the same SQL query.
What should you create?- AA. an index
- BB. a view
- CC. a scalar function
- DD. a table
20A key/value data store is optimized for [blank_start]______[blank_end]
- Aenforcing constraints
- Bsimple lookups
- Ctable joins
- Dtransactions
21Match 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.
- AImage files
- BKey/value pairs
- CRelationships between employees
- DImage files
- EKey/value pairs
- FRelationships between employees
- GImage files
- HKay/value pairs
- IRelationships between employees
22Match the Azure Data Lake Storage Gen2 terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
- AAzure Storage account
- BFile share
- CContainer
- DAzure Storage account
- EFile share
- FContainer
23What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
- AA. Data is processed periodically
- BB. Low latency is expected
- CC. High latency is acceptable
- DD. Data is processed as it is created
24Match 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.
- ADataset
- BLinked service
- CMapping data flow
- DPipeline
- EDataset
- FLinked service
- GMapping data flow
- HPipeline
- IDataset
- JLinked service
- KMapping data flow
- LPipeline
25Match 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.
- ABatch
- BStreaming
- CBatch
- DStreaming
- EBatch
- FStreaming
26Your 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. You may need to drag the split bar between panes or scroll to view content.
- AA standalone data analysis tool
- BThe CRM system
- CThe data warehouse
- DA standalone data analysis tool
- EThe CRM system
- FThe data warehouse
- GA standalone data analysis tool
- HThe CRM system
- IThe data warehouse
27Your company recently reported sales from the third quarter.
You have the chart shown in the following exhibit.
Which type of analysis is shown in the fourth quarter?
- AA. predictive
- BB. prescriptive
- CC. descriptive
- DD. diagnostic
28Which statement is an example of Data Manipulation Language (DML)?
- AA. REVOKE
- BB. DISABLE
- CC. CREATE
- DD. UPDATE
29Creating closed caption text for audio files is an example of [blank_start]_______[blank_end] analytics.
- ACognitive
- BDescriptive
- CPredictive
- DPrescriptive
30A visualization that illustrates a university's current student enrollment per department is an example of [blank_start]______[blank_end] analytics.
- ACognitive
- BDescriptive
- CPredictive
- DPrescriptive
31An extract, load, and transform (ELT) process requires _______
- AA separate transformation engine.
- BA target data store powerful enough to transform data.
- CData that is fully processed before being loaded to the target data store.
- DA data pipeline that includes a transformation engine.
32You need to create an Azure resource to store data in Azure Table storage.
Which command should you run?- AA. az storage share create
- BB. az storage account create
- CC. az cosmosdb create
- DD. az storage container create
33The Azure Cosmos DB [blank_start]_________[blank_end] API enables the use of SELECT statements to retrieve documents from Azure Cosmos DB.
- ACore (SQL)
- BGremlin
- CMongoDB
- DTable
34You need to modify a view in a relational database by adding a new column.
Which statement should you use?- AA. MERGE
- BB. ALTER
- CC. INSERT
- DD. UPDATE
35Extract, transform, and load (ETL) can reduce the transfer of sensitive data to destination systems. [blank_start]_____[blank_end]
Extract, load, and transform (ETL) transforms data by using a compute resource independent of a source system and destination system. [blank_start]________[blank_end]
Extract, load, and transform (ETL) minimizes the time it takes to copy large volumes of data to destination systems. [blank_start]_________[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
36You plan to deploy a PostgreSQL database to Azure.
Which hosting model corresponds to the available deployment options? To answer, select the appropriate options in the answer area.
PostgreSQL on Azure VMs: [blank_start]__________[blank_end]
Azure Database for PostgreSQL: [blank_start]_________[blank_end]- AInfrastructure as a service (IaaS)
- BPlatform as a service (PaaS)
- CSoftware as a service (SaaS)
- DInfrastructure as a service (IaaS)
- EPlatform as a service (PaaS)
- FSoftware as a service (SaaS)
37To complete the sentence, select the appropriate option in the answer area.
- AColumn family databases
- BDocument databases
- CGraph databases
- DKey-value stores
38Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
- AA. Azure Table storage
- BB. Azure Data Lake Storage
- CC. Azure Queue storage
- DD. Azure Files
39To complete the sentence, select the appropriate option in the answer area.
- AA file system as a unstructured data.
- BA hierarchal folder structure.
- CA tabular form of rows and columns.
- DComma-separated value (CSV) files.
40To complete the sentence, select the appropriate option in the answer area.
- AA view
- BA clustered index
- CA stored procedure
- DA nonclustered index
41To complete the sentence, select the appropriate option in the answer area.
- AA stored procedure
- BA table
- CA view
- DAn index
42Match 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.
- ACognitive
- BDiagnostic
- CDescriptive
- DPredictive
- EPrescriptive
- FCognitive
- GDiagnostic
- HDescriptive
- IPredictive
- JPrescriptive
- KCognitive
- LDiagnostic
- MDescriptive
- NPredictive
- OPrescriptive
43To complete the sentence, select the appropriate option in the answer area.
- AA heap
- BA stored procedure
- CA view
- DAn index
44Which type of database is Azure Database for PostgreSQL?
- APlatform as a service (PaaS)
- BInfrastructure as a service (IaaS)
- CMicrosoft SQL Server
- Don-premises
45Which storage solution supports access control lists (ACLs) at the file and folder level?
- AAzure Data Lake Storage
- BAzure Queue storage
- CAzure Blob storage
- DAzure Cosmos DB
46Select the answer that correctly completes the sentence.
- Aline chart
- Bmatrix
- Cscatter
- Dtreemap
47What is a characteristic of batch processing?
- AThe data ingested during batch processing must be processed as soon as the data is received.
- BLarge datasets must be split into batches of less than 1 GB before the data can be processed.
- CThere is a noticeable time delay between ingesting data and obtaining the data processing results.
- DBatch processing can only process data that is structured.
48Select the answer that correctly completes the sentence.
- AFROM and WHERE
- BGROUP BY and ORDER BY
- CJOIN and MERGE
- DMAX and MIN
49For each of the following statements, select Yes if the statement is true. Otherwise, select No.
A job that processes sales data once daily is an example of a batch workload. [blank_start]_______[blank_end]
A job that calculates a rolling average temperature reading is an example of a streaming workload. [blank_start]____[blank_end]
A job that calculates average revenue per product for the last month is an example of a streaming workload. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
50Select the answer that correctly completes the sentence.
- Aa different set of columns
- Ba key-value pair
- Cthe same set of columns
- Dunstructured data
51For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Normalizing a database increases the throughput of writing transactions. [blank_start]_________[blank_end]
Analytics systems are more normalized than transactional systems. [blank_start]_________[blank_end]
Normalizing a database results in queries that require more joins. [blank_start]_________[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
52Select the answer that correctly completes the sentence.
- AColumn family databases
- BDocument databases
- CGraph databases
- DKey-value stores
53Select the answer that correctly completes the sentence.
- Aenforcing constraints.
- Bsimple lookups.
- Ctable joins.
54Select the answer that correctly completes the sentence.
- Arelational data.
- Bsemi-structured data.
- Cstructured data.
- Dunstructured data.
55Select the answer that correctly completes the sentence.
- Agraph data.
- Brelational data.
- Csemi-structured data.
- Dunstructured data.
56Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
- Aatomicity
- Bisolation
- Cdurability
- Dconsistency
57You have a data store that has the structure shown in the following exhibit.
Which type of data store is this?
- Akey/value
- Bobject data
- Cgraph
- Dtime series
58Which type of database contains nodes and edges?
- Agraph
- Bkey/value
- Ccolumnar
- Dtime series
59Select the answer that correctly completes the sentence.
- AA data analyst
- BA data engineer
- CA data scientist
60To complete the sentence, select the appropriate option in the answer area.
- Acollections
- Brows
- Ckeys
- Dpartitions
61You have an inventory management database that contains the following table.
Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?
- AINSERT
- BMERGE
- CUPDATE
- DCREATE
62Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?- AAzure HDInsight
- BAzure SQL Database
- CAzure Cosmos DB
- DSQL Server on Azure Virtual Machines
63You 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?- AMicrosoft SQL Server Management Studio (SSMS)
- BAzure Data Studio
- CAzure CLI
- DAzure PowerShell
64Match 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.
- AIndex
- BView
- CTable
- DIndex
- EView
- FTable
- GIndex
- HView
- ITable
65You have an e-commerce application that reads and writes data to an Azure SQL database.
Which type of processing does the application use?- Astream processing
- Bbatch processing
- COnline Analytical Processing (OLAP)
- DOnline Transaction Processing (OLTP)
66When can you use an Azure Resource Manager template?
- Ato automate the creation of an interdependent group of Azure resources in a repeatable way
- Bto apply Azure policies for multi-tenant deployments
- Cto provision Azure subscriptions
- Dto control which services and feature administrators and developers can deploy from the Azure portal
67You have an Azure SQL database that you access directly from the Internet.
You recently changed the public IP address of your computer.
After changing the IP address, you can no longer access the database. You can connect to other resources in Azure.
What is a possible cause of the issue?- Arole-based access control (RBAC)
- BDynamic Host Configuration Protocol (DHCP)
- CDomain Name Service (DNS)
- Da database-level firewall
68Match 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:
- AAzure Data Studio
- BMicrosoft SQL Server Data Tools (SSDT)
- CMicrosoftSQLServerManagementStudio(SSMS)
- DAzure Data Studio
- EMicrosoft SQL Server Data Tools (SSDT)
- FMicrosoftSQLServerManagementStudio(SSMS)
- GAzure Data Studio
- HMicrosoft SQL Server Data Tools (SSDT)
- IMicrosoftSQLServerManagementStudio(SSMS)
69For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Relational database tables contain columns and rows. [blank_start]_______[blank_end]
Indexes in a relational database describe the data types in a table. [blank_start]_______[blank_end]
A database view is a virtual table whose conten is defined by a query. [blank_start]_______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
70Which command-line tool can you use to query Azure SQL databases?
- Asqlcmd
- Bbcp
- Cazdata
- DAzure CLI
71For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Azure SQL Database includes a managed backup service. [blank_start]______[blank_end]
Azure SQL Database has built-in high availability. [blank_start]_______[blank_end]
Azure SQL Database can use Azure Defender. [blank_start]_______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
72For each of the following statements, select Yes if the statement is true. Otherwise, select No.
You can use Azure Data Studio to query a Microsoft SQL Server big data cluster. [blank_start]_____[blank_end]
You can use Microsoft SQL Server Management Studio (SSMS) to query an Azure Synapse Analytics data warehouse. [blank_start]____[blank_end]
You can use MySQL WorkBench to query Azure Database for MariaDB databases. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
73You have the following SQL query.
"INSERT INTO dbo.Products (ProductID, ProductName, Price, ProductDescription)
VALUES (1, 'Clamp' 12.48, 'Workbench clamp');"
What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.
- AA column
- BA database
- CA table
- DAn index
- EA column
- FA database
- GA table
- HAn index
74For each of the following statements, select Yes if the statement is true. Otherwise, select No.
You must apply operating system updates to Azure SQL databases regularly. [blank_start]______[blank_end]
You need a Microsoft 365 subscription to create an Azure SQL database. [blank_start]______[blank_end]
You can use existing Microsoft SQL Server licenses to reduce the cost of Azure SQL databases. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
75Which statement is an example of Data Definition Language (DDL)?
- ASELECT
- BJOIN
- CUPDATE
- DCREATE
76For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Azure Data Studio can be used to query an Azure SQL database from a device that runs macOS. [blank_start]______[blank_end]
Microsoft SQL Server Management Studio (SSMS) enables users to create and use SQL notebooks. [blank_start]_______[blank_end]
Azure Data Studio can be used to restore a database. [blank_start]_______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
77You 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?- AAzure Cosmos DB
- BAzure HDInsight
- CAzure SQL Database
- DAzure Synapse Analytics
78What 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.
- Aaccess to the latest features
- Bcomplete control over backup and restore processes
- Cin-database machine learning services
- Dreduced administrative effort for managing the server infrastructure
79For each of the following statements, select Yes if the statement is true. Otherwise, select No.
If you have a platform as a service (PaaS) database in Azure, you are responsible for applying operating system updates. [blank_start]_____[blank_end]
If you have a platform as a service (PaaS) database in Azure, backups are performed automatically. [blank_start]_____[blank_end]
If you have a platform as a service (PaaS) database in Azure, you are responsible for installation of the database engine. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
80You have a table named Sales that contains the following data.
- ACREATE
- BGROUP BY
- CORDER BY
- DSELECT
- ECREATE
- FORDER BY
- GGROUP BY
- HSELECT
81When you create an Azure SQL database, which account can always connect to the database?
- Athe Azure Active Directory (Azure AD) account that created the database
- Bthe server admin login account of the logical server
- Cthe Azure Active Directory (Azure AD) administrator account
- Dthe sa account
82Which statement is an example of Data Definition Language (DDL)?
- ASELECT
- BINSERT
- CDELETE
- DDROP
83A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers. The developers require code assistance features such as
IntelliSense.
What should the developers use?- Asqlcmd
- BMicrosoft SQL Server Management Studio (SSMS)
- CAzure Data Studio
- DAzure Data Explorer
84To complete the sentence, select the appropriate option in the answer area.
- Acolumn to protect data at rest and...
- Bqueries and their results in order to ..
- Cdatabase to protect data at rest.
- Dthe server to protect data at rest.
85You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL database.
Which type of authentication should you use?- Aservice principal authentication
- BAzure Active Directory (Azure AD) authentication
- CSQL authentication
- Dcertificate authentication
86What is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?
- Abuilt-in high availability
- Bnative support for cross-database queries and transactions
- Csystem-initiated automatic backups
- Dsupport for encryption at rest
87To complete the sentence, select the appropriate option in the answer area.
- Aa network security group (NSG).
- Ba server-level firewall
- CAzure Firewall
- DAzure Front Door
88You need to design and model a database by using a graphical tool that supports project-oriented offline database development.
What should you use?- AMicrosoft SQL Server Data Tools (SSDT)
- BMicrosoft SQL Server Management Studio (SSMS)
- CAzure Databricks
- DAzure Data Studio
89Match 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.
- AAuthentication
- BFirewall
- CEncryption
- DAuthentication
- EFirewall
- FEncryption
- GAuthentication
- HFirewall
- IEncryption
90You have a transactional application that stores data in an Azure SQL managed instance.
When should you implement a read-only database replica?- AYou need to generate reports without affecting the transactional workload.
- BYou need to audit the transactional application.
- CYou need to implement high availability in the event of a regional outage.
- DYou need to improve the recovery point objective (RPO).
91To complete the sentence, select the appropriate option in the answer area.
- Aa dynamic schema is required.
- Bdata will be stored as key/value pairs.
- Cstoring large images and videos.
- DstrongConsistencyGuarantees are required
92To complete the sentence, select the appropriate option in the answer area.
- Acollections
- Bcolumns
- Ckeys
- Dpartitions
93To complete the sentence, select the appropriate option in the answer area.
- AA heap
- BA stored procedure
- CA view
- DAn index
94You 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.- AYou must be assigned the Reader role for the resource group that contains the database.
- BYou must have SELECT access to the Products table.
- CYou must have a user in the database.
- DYou must be assigned the Contributor role for the resource group that contains the database.
- EYour IP address must be allowed to connect to the database.
95Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
- ASET
- BVALUES
- CKEY
- DJOIN
96Your 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?- AAzure Application Gateway
- BAzure Traffic Manager
- CAzure DNS
- DAzure Private Link
97Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
- AAzure SQL Database elastic pool
- BAzure SQL Database single database
- CAzure SQL Managed instance
- DAzure SQL Database elastic pool
- EAzure SQL Database single database
- FAzure SQL Managed instance
- GAzure SQL Database elastic pool
- HAzure SQL Database single database
- IAzure SQL Managed instance
98Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
- ASELECT
- BWHERE
- CJOIN
99Select the answer that correctly completes the sentence.
- AAzure SQL Database
- BAzure Synapse Analytics
- CAzure Database for MariaDB
- DSQL Server on Azure virtual machines
100Select the answer that correctly completes the sentence.
- AA view
- BA clustered index
- CA stored procedure
- DA nonclustered index
101You have the following SQL query.
- AA column
- BA database
- CA table
- DAn index
- EA column
- FA database
- GA table
- HAn index
102Select the answer that correctly completes the sentence.
- Aforeign key
- Bprimary key
- CWHERE clause
- Dnonclustered index
103Select the answer that correctly completes the sentence.
- AA heap
- BA stored procedure
- CA view
- DAn index
104Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
- AAzure SQL Database
- BAzure Database for MySQL
- CAzure SQL Managed Instance
- Dan Azure SQL Database elastic pool
105Which setting can only be configured during the creation of an Azure Cosmos DB account?
- Ageo-redundancy
- Bmulti-region writes
- Cproduction or non-production account type
- DAPI
106Match 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.
- AGraph
- BObject
- CKey/value
- DGraph
- EObject
- FKey/value
- GGraph
- HObject
- IKey/value
107You 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.- Athe throughput
- Bthe read region
- Cthe partition key
- Dthe API
108Your 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?
- Agraph
- Bkey/value
- Cobject
- Dcolumnar
109Which storage solution supports role-based access control (RBAC) at the file and folder level?
- AAzure Disk Storage
- BAzure Data Lake Storage
- CAzure Blob storage
- DAzure Queue storage
110You 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?- AArchive
- BHot
- CCool
111Which 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?
- Adocument
- Bcolumnar
- Cgraph
- Dtime series
112Match 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.
- ACassandra API
- BGremlin API
- CMongoDB API
- DTable API
- ECassandra API
- FGremlin API
- GMongoDB API
- HTable API
- ICassandra API
- JGremlin API
- KMongoDB API
- LTable API
113To complete the sentence, select the appropriate option in the answer area.
- Aenable the hierarchical namespace.
- Bset Account kind to BlobStorage.
- Cset Performance to Premium
- DsetReplicationToRead-access ...
114To complete the sentence, select the appropriate option in the answer area.
- Aas a JSON document by using a SQL-like..
- Bas a partionedRowStore by using (CQL)
- Cas a partionedRowStore by using (LINQ)
- Das nodes and edges by using Gremlin lang
115When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
- Amulti-master replication
- BAvailability Zones
- Cthe strong consistency level
- Dautomatic failover
116What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?
- Aprovides resiliency if an Azure region fails
- Bsupports partitioning
- Cprovides a higher storage capacity
- Dsupports a multi-master model
117Your 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?- Agraph
- Bkey/value
- Cdocument
- Dcolumnar
118For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Azure Databricks can consume data from Azure SQL Database. [blank_start]_______[blank_end]
Azure Databricks can consume data from Azure Event Hubs. [blank_start]_______[blank_end]
Azure Databricks can consume data from Azure Cosmos DB. [blank_start]_______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
119Match 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.
- AAzure Blob storage
- BAzure Cosmos DB
- CAzure Files
- DAzure Table storage
- EAzure Blob storage
- FAzure Cosmos DB
- GAzure Files
- HAzure Table storage
120To complete the sentence, select the appropriate option in the answer area.
- Aaccount
- Bcontainer
- Cdatabase
- Ditem
121You need to store data by using Azure Table storage.
What should you create first?- Aan Azure Cosmos DB instance
- Ba storage account
- Ca blob container
- Da table
122You need to recommend a data store service that meets the following requirements:
✑ Native SQL API access
✑ Configurable indexes
What should you recommend?- AAzure Files
- BAzure Blob storage
- CAzure Table storage
- DAzure Cosmos DB
123For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Azure Table storage within a single Azure Storage account supports multiple concurrent reads in different Azure regions. [blank_start]______[blank_end]
Azure Table storage within a single Azure Storage account supports multiple concurrent writes in different Azure regions. [blank_start]______[blank_end]
An Azure Cosmos DB account that uses the Table API supports multiple concurrent reads in different Azure regions. [blank_start]______[blank_end]
An Azure Cosmos DB account that uses the Table API supports multiple concurrent writes in different Azure regions. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
- Gyes
- Hno
124To complete the sentence, select the appropriate option in the answer area.
- Aenable the hierarchical namespace
- Bset Account kind to BlobStorage
- Cset Performance to Premium
- Dset Replication to (RA-GRS)
125Your 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?- Agraph
- Bkey/value
- Cdocument
- Dcolumnar
126You 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?- Aqueue
- Bblob
- Cfile
- Dtable
127Your 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?- Akey/value
- Bgraph
- Ccolumnar
- Ddocument
128You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?- AAzure Files
- BAzure Blob storage
- CAzure Cosmos DB
- DAzure Table storage
129For each of the following statements, select Yes if the statement is true. Otherwise, select No.
The Azure Cosmos DB API is configured separately for each database in an Azure Cosmos DB account. [blank_start]_______[blank_end]
Partition keys are used in Azure Cosmos DB to optimize queries. [blank_start]______[blank_end]
Items contained in the same Azure Cosmos DB logical partition can have different partition keys. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
130Your 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- Acolumnar
- Bkey/value
- Cdocument
- Dgraph
131You 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?- Akey/value
- Bcolumnar
- Cobject
- Ddocument
132Your 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?- Arelational
- Btime series
- Cgraph
- Dcolumnar
133For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Copying data to Azure Data Lake Storage from another Azure region results in extra cost. [blank_start]______[blank_end]
You can use blob, table, and file storage in the same Azure Storage account. [blank_start]_______[blank_end]
You implement Azure Data Lake Storage by creating an Azure Storage account. [blank_start]_______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
134To complete the sentence, select the appropriate option in the answer area.
- Agraph.
- Btable.
- Cpartition key.
- Ddocument.
135At which two levels can you set the throughput for an Azure Cosmos DB account? Each correct answer presents a complete solution.
- Adatabase
- Bitem
- Ccontainer
- Dpartition
136For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Azure Table storage supports multiple read replicas. [blank_start]______[blank_end]
Azure table storage supports multiple write regions. [blank_start]______[blank_end]
The Azure Cosmos DB Table API supports multiple read replicas. [blank_start]______[blank_end]
The Azure Cosmo DB Table API supports multiple write regions. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
- Gyes
- Hno
137What is a characteristic of non-relational data?
- Ano indexes
- Bself-describing entities
- Ca well-defined schema
- Dno unique key values
138To complete the sentence, select the appropriate option in the answer area.
- AA hierarchical namespace
- BAzure Synapse Link
- CPolyBase
- DThe Data Movement Service (DMS)
139You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?- AOnline Transaction Processing (OLTP
- Bbatch
- Cmassively parallel processing (MPP)
- Dstreaming
140You 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?- AScale down the data warehouse units (DWUs).
- BPause the pool.
- CCreate a user-defined restore point.
- DDelete the pool
141Which Azure Data Factory component initiates the execution of a pipeline?
- Aa control flow
- Ba trigger
- Ca parameter
- Dan activity
142Your 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?- Astream processing
- Bbatch processing
- COnline Analytical Processing (OLAP)
- DOnline Transaction Processing (OLTP)
143Match 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 type may be used once, more than once, or not at all.
- AControl
- BData movement
- CData transformation
- DControl
- EData movement
- FData transformation
- GControl
- HData movement
- IData transformation
144What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
- Adenormalized data
- Bheavy writes and moderate reads
- Clight writes and heavy reads
- Dschema on write
- Eschema on read
- Fnormalized data
145Which 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.
- Areport and dashboard creation
- Breport sharing and distribution
- Cdata modeling
- Ddata acquisition and preparation
146To complete the sentence, select the appropriate option in the answer area.
- Aa control flow
- Ba dataset
- Ca linked service
- Dan integration runtime
147You 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?- Aa view
- Ba report
- Ca dataflow
- DMicrosoft Power Apps
148Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution.
- AAzure Time Series Insights
- BAzure HDInsight
- CAzure Databricks
- DAzure Log Analytics
149You have a quality assurance application that reads data from a data warehouse.
Which type of processing does the application use?- AOnline Transaction Processing (OLTP)
- Bbatch processing
- COnline Analytical Processing (OLAP)
- Dstream processing
150Which three objects can be added to a Microsoft Power BI dashboard? Each correct answer presents a complete solution.
- Aa report page
- Ba Microsoft PowerPoint slide
- Ca visualization from a report
- Da dataflow
- Ea text box
151For each of the following statements, select Yes if the statement is true. Otherwise, select No.
A Microsoft Power BI dashboard is associated with a single workspace. [blank_start]_____[blank_end]
A Microsoft Power BI dashboard can only display visualizations from a single dataset. [blank_start]______[blank_end]
A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
152Which Azure Data Factory component provides the compute environment for activities?
- ASSIS packages
- Ban integration runtime
- Ca control flow
- Da pipeline
153To complete the sentence, select the appropriate option in the answer area.
- Adashboard
- Binteractive report
- Cpaginated report
- Dsubscription
154What are two uses of data visualization? Each correct answer presents a complete solution.
- ARepresent trends and patterns over time
- BImplement machine learning to predict future values
- CCommunicate the significance of data
- DEnforce business logic across reports
155You 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?- AAzure Functions
- BMicrosoft SQL Server Integration Services (SSIS)
- CPolyBase
- DAzure Data Factory
156For each of the following statements, select Yes if the statement is true. Otherwise, select No.
You can copy a dashboard between Microsoft Power BI workspaces. [blank_start]______[blank_end]
A Microsoft Power BI dashboard can only display visualization from a single dataset. [blank_start]______[blank_end]
A Microsoft Power BI dashboard can display visualizations from a Microsoft Excel workbook. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
157What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
- Adenormalized data
- Bheavy writes and moderate reads
- Clight writes and heavy reads
- Dschema defined in a database
- Eschema defined when reading unstructured data from a database
- Fnormalized data
158What is the primary purpose of a data warehouse?
- Ato provide answers to complex queries that rely on data from multiple sources
- Bto provide transformation services between source and target data stores
- Cto provide read-only storage of relational and non-relational historical data
- Dto provide storage for transactional line-of-business (LOB) applications
159Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
- AAzure Cognitive Search
- BAzure Data Catalog
- CAzure Data Factory
- DAzure Synapse Analytics
- EAzure Cognitive Search
- FAzure Data Catalog
- GAzure Data Factory
- HAzure Synapse Analytics
160Match 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.
- ABatch
- BStreaming
- CBatch
- DStreaming
- EBatch
- FStreaming
161To complete the sentence, select the appropriate option in the answer area.
- Afrom a single source is distributed...
- Bfrom multiple sources is combined...
- Cis added to a queue for multiple...
- Dis used to train machine learning...
162For each of the following statements, select Yes if the statement is true. Otherwise, select No.
A pipeline is a representation of a data structure within Azure Data Factory. [blank_start]______[blank_end]
Azure Data Factory pipelines can execute other pipelines. [blank_start]______[blank_end]
A processing step within an Azure Data Factory pipeline is an activity. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
163Match 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.
- AAzure Data Lake Storage
- BAzure SQL Database
- CAzure Synapse Analytics
- DAzure Data Lake Storage
- EAzure SQL Database
- FAzure Synapse Analytics
- GAzure Data Lake Storage
- HAzure SQL Database
- IAzure Synapse Analytics
164For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Azure Synapse Analytics scales storage and compute independently. [blank_start]_______[blank_end]
Azure Synapse ANalytics can be paused to reduce compute costs. [blank_start]______[blank_end]
An Azure Synapse Analytics data warehouse has a fixed storage capacity. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
165What should you use to build a Microsoft Power BI paginated report?
- ACharticulator
- BPower BI Desktop
- Cthe Power BI service
- DPower BI Report Builder
166Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
- AAzure Analysis Services
- BAzure Data Factory
- CAzure Table storage
- DAzure Cosmos DB
- EAzure Synapse Analytics
- FAzure Analysis Services
- GAzure Data Factory
- HAzure Table storage
- IAzure Cosmos DB
- JAzure Synapse Analytics
167For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Azure Databricks is an Apache Spark-based analytics platform. [blank_start]________[blank_end]
Azure Analysis Services is used for transactional workloads. [blank_start]______[blank_end]
Azure Data Factory orchestrates data integration workflows. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
168Which scenario is an example of a streaming workload?
- Asending transactions that are older than a month to an archive
- Bsending transactions daily from point of sale (POS) devices
- Csending telemetry data from edge devices
- Dsending cloud infrastructure metadata every 30 minutes
169To complete the sentence, select the appropriate option in the answer area.
- Aprocess data in memory, row-by-row
- Bcollect and process data at mostOnceADay
- Cprocess data as new data is received...
- Dcollect data and then process the data..
170For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Processing salary payments once a month is an example of a batch workload. [blank_start]_______[blank_end]
A wind turbine that sends 50 sensor readings per secong is an example of a streaming workload. [blank_start]_____[blank_end]
A home electricity meter that sends readings once a day to an enegy provider is an example of a streaming workload. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
171A bar chart showing year-to-date sales by region is an example of which type of analytics?
- Apredictive
- Bprescriptive
- Cdescriptive
- Ddiagnostic
172For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Stream processing has access to the most recent data received or data within a rolling rime window. [blank_start]_______[blank_end]
Batch processing must occur inmmediately and hace latency in the order of seconds or miliseconds. [blank_start]_______[blank_end]
Stream processing is used for simple response functions, aggregates, or calculations such as rolling averages. [blank_start]______[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
173You 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?- ASynapse pipelines
- Ba Synapse SQL pool
- CSynapse Link
- DSynapse Studio
174You 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
- Aa waterfall chart
- Ba ribbon chart
- Ca bar chart
- Da decomposition tree
175Select the answer that correctly completes the sentence.
- Agraph
- Btable
- Cpartition key
- Ddocument
176You have the following two tables of customer data.
Which type of data do the tables contain?
- Astructured
- Bnon-relational
- Csemi-structured
- Dunstructured
177Select the answer that correctly completes the sentence.
- Aas nodes and edges by using Gremlin...
- Bas partioned row store by usingCassandra
- Cas partioned row store by using (LINQ)
178Which Azure Blob Storage feature enables you to sync a Blob Storage account to an external cache?
- Athe Hot access tier
- Bchange feed
- Csnapshots
- Dversioning
179You have an on-premises Microsoft SQL Server database.
You need to migrate the database to the cloud. The solution must meet the following requirements:
* Minimize maintenance effort.
* Support the Database Mail and Service Broker features.
What should you include in the solution?- AAzure SQL Database single database
- Ban Azure SQL Database elastic pool
- CAzure SQL Managed instance
- DSQL Server on Azure virtual machines
180Select the answer that correctly completes the sentence.
- Aa matching schema in the data...
- Ba target data store powerful...
- Cdata that is fully processed before...
- Dthat the data target be a relational...
181Select the answer that correctly completes the sentence.
- Aalways process data in memory,row-by-row
- Bcollect and process data at most once...
- Cprocess data as new data is received...
- Dcollect data and then process the data..
182Your 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. You may need to drag the split bar between panes or scroll to view content.
- AA standalone data analysis
- BThe CRM system
- CThe data warehouse
- DA standalone data analysis tool
- EThe CRM system
- FThe data warehouse
- GA standalone data analysis tool
- HThe CRM system
- IThe data warehouse
183Select the answer that correctly completes the sentence.
- Awhat is most likely to occur in the...
- Bwhat occurred in the past
- Cwhich actions you can perform...
- Dwhy something occurred in the past
184What is a function of a modern data warehouse?
- Asupports batch processing only
- Bsupports real-time and batch processing
- Cprovides built-in or native online analytical processing
- Dstores raw data only
185Select the answer that correctly completes the sentence.
- ABlob soft delete
- BHierarchical namespace
- CLarge file shares
- DVersioning
186What can be used with native notebook support to query and visualize data by using a web-based interface?
- AAzure Databricks
- BpgAdmin
- CMicrosoft Power BI
187You have data saved in the following format.
Which format was used?
- AXML
- BHTML
- CYAML
- DJSON
188You have data saved in the following format.
Which format was used?
- AJSON
- BYAML
- CHTML
- DXML
189Which database transaction property ensures that transactional changes to a database are preserved during unexpected operating system restarts?
- Aconsistency
- Batomicity
- Cdurability
- Disolation
190Select the answer that correctly completes the sentence.
- Aa dynamic schema is required.
- Bdata will be stored as key/value pairs.
- Cstoring large images and videos.
- Dstrong consistency guarantees are requir
191Select the answer that correctly completes the sentence.
- Aa file system as unstructured data.
- Ba hierarchal folder structure.
- Ca tabular form of rows and columns.
- Dcomma-separated value (CSV) files.
192Which database transaction property ensures that individual transactions are executed only once and either succeed in their entirety or roll back?
- Aatomicity
- Bdurability
- Cisolation
- Dconsistency
193Select the answer that correctly completes the sentence.
- AA clustered index
- BA FileTable
- CA foreign key
- DA stored procedure
194Which Azure Storage service implements the key/value model?
- AAzure Queue
- BAzure Files
- CAzure Table
- DAzure Blob
195Select the answer that correctly completes the sentence.
- Asemi-structured data.
- Bstructured data.
- Cunstructured data.
196Select the answer that correctly completes the sentence.
- Afrom a single source is distributed...
- Bfrom multiple sources is combined...
- Cis added to a queue for multiple...
- Dis used to train machine learning...
197Select the answer that correctly completes the sentence.
- Adata is always inserted one row at a...
- Bdata is processed in real-time
- Cdelay in delivering data processing...
- Dprocessing can only execute serially.
198You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes.
What should you include in the solution?- AAzure Blob storage
- BAzure Files
- CAzure Table storage
- DAzure Cosmos DB
199Select the answer that correctly completes the sentence.
- Aimposes a fixed schema on data
- Bstore entities without a unique key...
- Cstores data in relational tables
- Dstores data without a fixed schema
200For each of the following statements, select Yes if the statement is true. Otherwise, select No.
In a transactional database that guarantees atomicity, all statements in a transaction must complete successfully or the transaction must roll back. [blank_start]__________[blank_end]
In a transactional database that guarantees consistency, all data changes will be logged and accounted for. [blank_start]__________[blank_end]
In a transactional database that guarantees isolation, processes can see only data in a consistent state. [blank_start]________[blank_end]- Ayes
- Bno
- Cyes
- Dno
- Eyes
- Fno
Informações
- Descrição
- Analista DP-900 Quiz sobre DP-900 , criado por Dan Or em 01-02-2023.
- Autor
- Dan Or
- Idioma
- Español
- Visualizações
- 49
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz