Month: February 2022

SQL DBA latest interview -Anil

1) What is database?
2)what is Primary key?
3)what is clusterindex?
4) What is row versioning?Which isolation level will
create the issue?
5)what is covering index?
6)what is asyn statistics?
7)what is Numa?
8)what is 1117 and 1118 trace flags explain the
usage?
9)tempdb is full how to check trough DMV?
10)how to check memory usage trough DMV?
11)in AG secondaty replica log full and no space in
disk how to resolve?
12 How to read profiler trace flag?
13 Query running very slow?
14)Full backup running @8pm and tranaction log
backups alos running at the same time@7.30
onwards
the current running transactions going to full or tlog?
15)successful logins and unsuccessful logins how to
capture in sql logs through traceflag?
16)What is buffer pool?what it contains?
17Commaonly used Dmv’s at lease five?
18 what is cardinality in sql?
19)what is primary key and clustered index?
20 what is vlf?
21tempdb architecture?
22)what is readqueue in AG?
23) statistics frequency?
24)what challenges your faced in your environment?

AZURE INTERVIEW QUESTIONS

  1. How you can restore VM/SQL Backup from Azure recovery service vault
  2. Diff b/w Load balner and Traffic manager
  3. What is Horizantal scaling and vertical scaling
  4. How do you increase the VM sku size
  5. How do you patch servers using update Management and where it was located.
  6. Do you have any knowledge in powershell scripting,
  7. how do you automate powershell script in azure
  8. Do you have any experence in creating VM’s
  9. What is NSG
  10. What is the availability set
  11. I have one availability set and 2 servers are in different region is it possible to configure the 2 serevers in one availability set
  12. What is the VNET
  13. which IP you are using in environment to create the VM.
  14. What is pearing
  15. Do you have any experience in ssl certificate renewal
  16. how do you grant db read access in SQL
  17. SQL Job is running longer than expected time, how you can resolve
  18. How do you identify SQL Blockings
  19. Do you have experience in on-premise to Azure migration.
  20. I need to grant access to the user to Start/stop the VM in Azure, which role you can grant the access to the user.
  21. Types of storage accounts.
  22. What are the storage account replications available in azure and explain each one.