Which of the following is the best approach to use to gain a general understanding of a data set?
Answer : A
A data analyst needs to write a SOL query measuring last month's website visits and distribute a summary report to the marketing team. Which of the following is the analyst creating?
Answer : D
A database administrator needs to ensure only approved users can access specific database tables to perform financial functions. Which of the following is the best access control method for the administrator to use?
Answer : A
Which of the following is an object associated with a table that sorts and stores table row data in a key-value pair?
Answer : D
Which of the following query statements would be used when filtering data in a relational database management system? (Select two).
Answer : B, C
An analyst wants to check the progress and performance regarding the number of customers an organization served in the last six years. Which of the following represents the type of analysis the analyst should perform?
Answer : B
A company notifies its employees that emails will be automatically moved to a cloud-based server in 180 days. Which of the following describes this concept?
Answer : C