View text definitions are stored in which system table?
syscomments
Correct Answer!
sysobjects
syscolumns
sysviews
Show Answer!
Which of the following cannot be done by a SQL profiler?
Users monitoring
Batch Execution
Correct Answer!
To find the Stored procedures triggered
Error tracking
Performance monitoring
Show Answer!
Which of the command below undo the current transaction
ROLLBACK
Correct Answer!
COMMIT
SAVEPOINT
UNDO
Show Answer!
SQL is a language for
Relational database management system
Correct Answer!
Developing system programs
Business applications only
None of these
Show Answer!
DML stands for
Data Manipulation Language
Correct Answer!
Digital Manipulation Language
Discrete Manipulation Language
Data Modifying Language
Show Answer!
A database is said to be in 2nd Normal Form if:
It is in 1st normal form and each attribute that is not a primary key is dependent on the primary key
Correct Answer!
It...
Which of the following is not a valid aggregate function
COMPUTE
Correct Answer!
COUNT
SUM
MIN
Show Answer!
How is Performance Load Balancing performed in Azure?
Traffic is routed via DNS to the "closest" endpoint based on the lowest latency between the client and the Azure Data Center hosting the...
What is Round Robin Load Balancing?
Each traffic request is directed to the next endpoint in the list of endpoints so traffic is evenly distributed across all endpoints.
Correct Answer!
...
What is Failover Load Balancing in Azure?
Traffic is directed to Healthy endpoints as the result of monitoring, so that traffic is not directed to a server that is in a...
How is Traffic Manager implemented to route Web App traffic to an appropriate website endpoint?
It's configured at the DNS level, so that DNS resolution directs which endpoint to route traffic to.
Correct Answer!
It acts as a Proxy...
Once an App Service Web App has been created, how can the VM Size (CPU and Memory) be changed for the VM’s that host...
Change the Pricing Tier for the Web App to the one with the desired CPU/Memory resources.
Correct Answer!
The Web App must be deleted,...
Which performance metrics are supported for triggering Web App Auto-Scaling?
All of the options
Correct Answer!
CPU Percentage
Memory Percentage
Data Out
Disk Queue Length
HTTP Queue Length
Data In
Show Answer!
Azure guarantees an SLA of 99.9% for all Web Apps hosted, regardless of the number of instances.
True
Correct Answer!
False
Show Answer!