
DP 300 KNOWLEDGE QUIZ
Quiz
•
Education
•
University
•
Practice Problem
•
Medium
Ofentse Neo Moleko
Used 2+ times
FREE Resource
Enhance your content in a minute
8 questions
Show all answers
1.
FILL IN THE BLANK QUESTION
15 mins • 2 pts
The _ database stores the information about logins in SQL Server
2.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Which role allows you to create users within a database?
db_securityadmin
db_datareader
db_accessadmin
3.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Which feature allows you to connect to Azure SQL Database using a private endpoint?
Access Link
Private Link
Virtual Network
Network Endpoint
4.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Which database object can be granted insert access?
Procedures
Tables
Functions
Schemas
5.
MULTIPLE CHOICE QUESTION
15 mins • 2 pts
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.
Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.
You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.
What should you include in the recommendation?
Azure Backup
Windows Server Failover Cluster
Azure Site Recovery
6.
MULTIPLE CHOICE QUESTION
15 mins • 2 pts
You create five Azure SQL Database instances on the same logical server. In each database, you create a user for an Azure Active Directory (Azure AD) user named User1.User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error. You need to ensure that when User1 connects to the logical server by using Azure Data Studio, User1 can see all the databases. What should you do? You create five Azure SQL Database instances on the same logical server.
In each database, you create a user for an Azure Active Directory (Azure AD) user named User1.
User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error.
You need to ensure that when User1 connects to the logical server by using Azure Data Studio, User1 can see all the databases.
What should you do?
Assign User1 the db_datareader role for the databases that User1 creates.
Create User1 in the master database.
Grant SELECT on sys.databases to public in the master database.
7.
MULTIPLE CHOICE QUESTION
15 mins • 1 pt
Which of the following threats is analyzed by Advanced Threat Protection?
Open Firewall Rules
SQL Injection
Weak Passwords
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Quizizz Litbang Net 2024
Quiz
•
University
10 questions
KONFIGURASI WEB SERVER CMS
Quiz
•
University
10 questions
MetaTexis: how much do you know?
Quiz
•
University
11 questions
LabSeguridad-G1
Quiz
•
University
8 questions
Introduction to Information Systems
Quiz
•
University
10 questions
Internet of Things - Mod 1
Quiz
•
University
10 questions
Library Quiz: Quality and Operations Management
Quiz
•
University
10 questions
Sistem Informasi Manajemen
Quiz
•
University
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
