Quiz
251- 300
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (53)
1251. In a relational database, each row in a table has ...............
- Aa different set of columns
- Ba key-value pair
- Cthe same set of columns
- Dunstructured data
2252. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ano, no, yes
- Byes, no, yes
- Cyes, yes , no
- Dno, no, no
3253. ............. natively support the analysis of relationships between entities.
- AColumn family databases
- BDocument databases
- CGraph databases
- DKey-value stores
4254. A key/value data store is optimized for ..............
- Aenforcing constraints
- Bsimple lookups
- Ctable joins
5255. In an infrastructure as a service (IaaS) instance of Microsoft SQL Server SQL on Azure, you manage the ............. that hosts SQL Server.
- AElastic pool
- BMySQL server
- CPostgreSQL server
- Dvirtual machine
6256. Varying fields for each entity in a JSON document is an example of ..........
- Arelational data
- Bsemi-structured data
- Cstructured data
- Dunstructured data
7257. A JSON document is an example of
- Agraph data
- Brelational data
- Csemi-structured data
- Dunstructured data
8258. Which 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
9259. You 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
10260. Which type of database contains nodes and edges?
- Agraph
- Bkey/value
- Ccolumnar
- Dtime series
11261. 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.
- AWhy did sales increase last month?->Descriptive
How do I allocate my budget to buy different inventory items?->Predictive
Which people are mentioned in a company's business documents?->Cognitive - BWhy did sales increase last month?->Diagnostic
How do I allocate my budget to buy different inventory items?->Descriptive
Which people are mentioned in a company's business documents?->Cognitive - CWhy did sales increase last month?->Diagnostic
How do I allocate my budget to buy different inventory items?->Prescriptive
Which people are mentioned in a company's business documents?->Cognitive
- AWhy did sales increase last month?->Descriptive
12262. ............ is responsible for identifying which business rules must be applied to the data of a company.
- AA data analyst
- BA data engineer
- CA data scientist
13263. You 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
14264. Your 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
15265. 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.- AMicrosoft SQL Server Management Studio (SSMS)
- BAzure Data Studio
- CAzure CLI
- DAzure PowerShell
16266. 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.
- AA database object that holds data->Table
A database object whose content is defined by a query->Index
A database object that helps improve the speed of data retrieval->View - BA database object that holds data->Table
A database object whose content is defined by a query->View
A database object that helps improve the speed of data retrieval->Index - CA database object that holds data->View
A database object whose content is defined by a query->Table
A database object that helps improve the speed of data retrieval->Index
- AA database object that holds data->Table
17267. You 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)
18268. When 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
19269. Question 269
You 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
20270. 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:
- AA graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks. -> Microsoft SQL Server Data Tools (SSDT)
A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files. -> Azure Data Studio
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. -> Microsoft SQL Server Management Studio (SSMS) - BA graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks. -> Microsoft SQL Server Management Studio (SSMS)
A lightweight editor that can run on-demand SQL queries and view and save results as text, JSON, or Microsoft Excel files. -> Azure Data Studio
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. -> Microsoft SQL Server Data Tools (SSDT)
- AA graphical tool for managing SQL Server or Azure SQL databases that supports access, configuration, management, and administration tasks. -> Microsoft SQL Server Data Tools (SSDT)
21271. You have the following JSON document.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the JSON document.
NOTE: Each correct selection is worth one point.
Customer is .....
Address is ......
Social media is ......
- Aa root object
a nested object
a nested array - Ba root object
a nested array
a nested object - Ca nested object
a root object
a nested array
- Aa root object
22272. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ayes, yes, no
- Byes, no, no
- Cyes, no, yes
23273. Which command-line tool can you use to query Azure SQL databases?
- Asqlcmd
- Bbcp
- Cazdata
- DAzure CLI
24274. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ayes, yes, yes
- Byes, no, no
- Cno, no, no
- Dyes, no, yes
25275. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ano, yes, no
- Byes, yes, yes
- Cno, no, yes
26276. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ayes, no, no
- Byes, no, yes
- Cyes, yes, yes
- Dno, no ,no
27277. You have the following SQL query.
What are dbo.Products and ProductName? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Dbo.Products: -A column
-A database
-A table
-An index
ProductName: -A column
-A database
-A table
-An index
- AA table
A table - BA table
An index - CAn index
A column - DA table
A column
- AA table
28278. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ayes, no, yes
- Bno, no, yes
- Cyes, yes, yes
- Dno, yes, yes
29279. Which statement is an example of Data Definition Language (DDL)?
- ASELECT
- BJOIN
- CUPDATE
- DCREATE
30280. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ayes, no, no
- Bno, no, yes
- Cyes, no, yes
31281. 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?- AAzure Cosmos DB
- BAzure HDInsight
- CAzure SQL Database
- DAzure Synapse Analytics
32282. You 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.
NOTE: Each correct selection is worth one point
The data model is a ....
-transactional model
-star schema
snowflake schema
Customer is a ....... table.
-fact
-dimension
-bridge
- Astar schema
fact - Bstar schema
dimension - Ctransactional model
dimension - Dstar schema
bridge
- Astar schema
33283. 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.- 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
34284. For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
- Ano, yes, no
- Bno, no, no
- Cyes, yes, no
- Dyes, no, yes
35285. You have a table named Sales that contains the following data.
You need to query the table to return the average sales amount per day. The output must produce the following results.
How should you complete the query? To answer, drag the appropriate values to the correct targets. Each value 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.
NOTE: Each correct selection is worth one point.
- ASELECT
ORDER BY - BSELECT
GROUP BY - CCREATE
GRUOP BY
- ASELECT
36286. When 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
37287. Which statement is an example of Data Definition Language (DDL)?
- ASELECT
- BINSERT
- CDELETE
- DDROP
38288. A 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
39289. Transparent Data Encryption (TDE) encrypts:
- Aa column to protect data at rest and in transit
- Bqueries and their results in order to protect data in transit
- Cthe database to protect data at rest
- Dthe server to protect data at rest
40290. 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?- Aservice principal authentication
- BAzure Active Directory (Azure AD) authentication
- CSQL authentication
- Dcertificate authentication
41291. What 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
42292. By default, each Azure SQL database is protected by
- Aa network security group (NGS)
- Ba server-level firewall
- CAzure Firewall
- DAzure Front Door
43293. The 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
44294. You 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
45295. 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.
- APrevent access to an Azure SQL database from another network. -> Firewall
Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database. -> Authentication
Ensure that sensitive data never appears as plain text in an Azure SQL database. -> Encryption - BPrevent access to an Azure SQL database from another network. -> Firewall
Support Azure Active Directory (Azure AD) sign-ins to an Azure SQL database. -> Encryption
Ensure that sensitive data never appears as plain text in an Azure SQL database. -> Authentication
- APrevent access to an Azure SQL database from another network. -> Firewall
46296. You 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).
47297. A relational database must be used when .....
- Aa dynamic schema is required
- Bdata will be stored as key/value pairs
- Cstoring large images and videos
- Dstrong consistency guarantees are required
48298. Relational data uses ....... to enforce relationships between different tables
- Acollections
- Bcolumns
- Ckeys
- Dpartitions
49299. ............is a virtual table that contains content content defined by a query
- AA heap
- BA stored procedure
- CA view
- DAn index
50300. 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.- 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.
51301. Which clause should you use in a SELECT statement to combine rows in one table with rows in another table?
- ASET
- BVALUES
- CKEY
- DJOIN
52302. Your company needs to ensure that an Azure virtual machine can connect to Azure SQL databases without exposing the databases to the internet.
What should you use?- AAzure Application Gateway
- BAzure Traffic Manager
- CAzure DNS
- DAzure Private Link
53303. Match 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.
NOTE: Each correct match its worth one point.
- AAzure SQL Database single database -> A serverless configuration
Azure SQL Managed Instance -> A low-cost, low-maintenance database
Azure SQL Database elastic pool -> A database that has the highest compatibility with on-premises Microsoft SQL Server - BAzure SQL Database single database -> A serverless configuration
Azure SQL Managed Instance -> A database that has the highest compatibility with on-premises Microsoft SQL Server
Azure SQL Database elastic pool -> A low-cost, low-maintenance database
- AAzure SQL Database single database -> A serverless configuration
Information
- Description
- Quiz on 251- 300, created by Cristiana Ioana on 22/10/2025.
- Author
- Cristiana Ioana
- Language
- English
- Views
- 34
- Rating
- No ratings yet Rate this quiz