Db sql - Study guides, Class notes & Summaries

How can you enable globally distributed users to work with their own local replica of a Cosmos DB database? -Create an Azure Cosmos DB account in each region where you have users. -Use the API for Table to copy data to Azure Table Storage in each region where you have users. -Enable multi-region writes and add the regions where you have users. - Enable multi-region writes and add the regions where you have users. -You can enable multi-region writes in the regions where you want users to w...

AWS Solutions Architect Associate Test Questions and Answers Solved 100%Correct. Amazon SWF is designed to help users: a. Manage user identification and authorization b. Coordinate synchronous and asynchronous tasks c. Secure their VPCs d. Help users store file based objects Correct Answer: b In RDS, what is the maximum value I can set for my backup retention period? a. 15 days b. 30 days c. 35 days d. 45 days Correct Answer: c True or False. Automated backups are enabled by default f...

DB Administrator - correct answer Secures the database from un-authencated access. DB Designer - correct answer Determines the format and the structure of the database DB Programmer - correct answer Develops programs or applications that will use the database DB Users - correct answer Consumers of the data no the Database. Can access the DB through the app or query the database directly. Transactions - correct answer - Ensures transaction are process completely or not at al...

What is a broad definition of data? Raw facts that are captured on printed or digital media What are data? Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? It does not follow a data model. Which is true about flat files? They contain no internal hierarchical organization. Which technology has no internal hierarchy? Flat files How were data retrieved before database management systems? Sequentially from simple files In which...

Can customizable tables can be used as visualizations within Databricks SQL? - Yes! You can drag and drop columns and do all kinds of fun stuff Compare and contrast discrete and continuous statistics. - DISCRETE analyses data that takes on a finite number of values. Examples include mode, median, percentiles. CONTINUOUS analyses data that take on variations within a range. Examples include mean, standard deviation and correlation coefficient. Compare and contrast key statistical measures -...

WGU C175 Final Exam Questions and Answers Latest Updated 2024/2025 (Graded A+) What is a broad definition of data? Raw facts that are captured on printed or digital media What are data? Facts that are collected and stored in a database system What is a determining characteristic of unstructured data? It does not follow a data model. Which is true about flat files? They contain no internal hierarchical organization. Which technology has no internal hierarchy? Flat files How were data re...

AWS Solutions Architect Associate Test Questions and Answers Solved 100%Correct. Amazon SWF is designed to help users: a. Manage user identification and authorization b. Coordinate synchronous and asynchronous tasks c. Secure their VPCs d. Help users store file based objects Correct Answer: b In RDS, what is the maximum value I can set for my backup retention period? a. 15 days b. 30 days c. 35 days d. 45 days Correct Answer: c True or False. Automated backups are enabled by default f...

DNS Sinkhole - Answer-Provide a response to a DNS query that does not resolve the IP address.. Instead targets the addresses for known malicious domains Role-Based access control (RBAC) - Answer-grants permissions based on a user's role or group. Reverse Engineering - Answer-the process of decontructing something in order to discover its features and constituents Banner grabbing - Answer-used to gain information about a computer system on a network and the services running on its open...

Question 1 (2 marks) Which of the following is an aggregate expression that will find the oldest date in the invoiceDate column? 1. MIN(invoiceDate) 2. MAX(invoiceDate) 3. HIGH(invoiceDate) 4. LOW(invoiceDate) Question 2 (2 marks) Which of the following LIMIT clauses will return a maximum of five rows starting with the eleventh row in the result set? 15 ICT3612/102/0/2024 1. LIMIT 10, <= 5 2. LIMIT 11, <= 5 3. LIMIT 10, 5 4. LIMIT 11, 5 Question 3 (2 marks) When coded in a...