D465 Data Applications set 2 Exam with precise detailed answers

D465 Data Applications set 2 |! |! |! |! |!




Exam with precise detailed |! |! |! |!




answers

Absolute Reference - Correct answer ✔Is a reference that is locked so that
|! |! |! |! |! |! |! |! |! |! |! |! |!




rows and columns won't change when copied
|! |! |! |! |! |!




Administrative metadata - Correct answer ✔Metadata that indicates the |! |! |! |! |! |! |! |! |!




technical source of a digital asset
|! |! |! |! |!




Aesthetic (R) - Correct answer ✔A visual property of an object in your plot.
|! |! |! |! |! |! |! |! |! |! |! |! |! |!




connection or mapping between a visual feature |! |! |! |! |! |!




Aggregation - Correct answer ✔Collecting or gathering many separate pieces
|! |! |! |! |! |! |! |! |! |!




into a whole
|! |!




Algorithm - Correct answer ✔Process or set of rules to be followed in
|! |! |! |! |! |! |! |! |! |! |! |! |!




calculations especially by a computer. |! |! |! |!




Analysis - Correct answer ✔Is the process used to make sense of the data
|! |! |! |! |! |! |! |! |! |! |! |! |! |!




collected. It means taking the right steps to proceed and think about your
|! |! |! |! |! |! |! |! |! |! |! |! |!




data in different ways. Make a template and update code.
|! |! |! |! |! |! |! |! |!

,Comments - Correct answer ✔are at the beginning of a line of code using the |! |! |! |! |! |! |! |! |! |! |! |! |! |! |!




'#' symbol|!




4 phases of analysis - Correct answer ✔organize data, format and adjust data,
|! |! |! |! |! |! |! |! |! |! |! |! |!




get input from others, transform data
|! |! |! |! |!




AND - Correct answer ✔In SQL operator enables a data professional to filter
|! |! |! |! |! |! |! |! |! |! |! |! |!




for two conditions at once when using WHERE statement
|! |! |! |! |! |! |! |!




Annotate - Correct answer ✔Add notes to a document/diagram to explain or
|! |! |! |! |! |! |! |! |! |! |! |!




comment upon it. help explain its purpose or to highlight important data. Let
|! |! |! |! |! |! |! |! |! |! |! |! |!




you customize your plot
|! |! |!




Argument (R) - Correct answer ✔Information function in R needs in order to
|! |! |! |! |! |! |! |! |! |! |! |!




run
|!




Arithmetic Operators - Correct answer ✔Used to complete math calculations |! |! |! |! |! |! |! |! |!




Array - Correct answer ✔A collection of values in spreadsheet cells
|! |! |! |! |! |! |! |! |! |!




Attribute - Correct answer ✔A characteristic or quality of data used to label a
|! |! |! |! |! |! |! |! |! |! |! |! |! |!




column in a table |! |! |!




AS - Correct answer ✔Comes before and identifies the data type which you
|! |! |! |! |! |! |! |! |! |! |! |! |!




are casting to.|! |!

, Bar graph - Correct answer ✔contrast and compare two or more values
|! |! |! |! |! |! |! |! |! |! |!




BigQuery - Correct answer ✔Doesn't currently recognize SELECT INTO
|! |! |! |! |! |! |! |! |!




command



CASE - Correct answer ✔Returns records that meet conditions by including
|! |! |! |! |! |! |! |! |! |! |!




an if/then statement in a query
|! |! |! |! |!




CAST - Correct answer ✔converting the data you select to a different data
|! |! |! |! |! |! |! |! |! |! |! |! |!




type



COALESCE - Correct answer ✔A SQL function that returns non-null values
|! |! |! |! |! |! |! |! |! |! |!




in a list
|! |!




Code Chunk - Correct answer ✔Runnable piece of R code. History of inputs
|! |! |! |! |! |! |! |! |! |! |! |! |!




that can be shared with other analyst. Code added in a .RMD file. It allows
|! |! |! |! |! |! |! |! |! |! |! |! |! |! |!




the analyst to check the code for errors.
|! |! |! |! |! |! |!




Code Dynamic - Correct answer ✔Ensure that they are not hard coding any
|! |! |! |! |! |! |! |! |! |! |! |! |!




values within the code that do not change when they need to.
|! |! |! |! |! |! |! |! |! |! |!




Changelog - Correct answer ✔A file containing a chronologically ordered list
|! |! |! |! |! |! |! |! |! |! |!




of modifications made to a project
|! |! |! |! |!