Designer Core - General Knowledge

Question 1

True or False. The unique tool is case sensitive

Answer 1

True

Question 2

Which of the following statements about the Unique too are NOT true? Select all that apply

1. It’s best practice to join the results from the U & D outputs
2. You can select up to 10 columns in one Unique tool
3. The Unique tool is case sensitive

Answer 2

1 and 2

Question 3

True or False: The Unique tool is case sensitive and will display the last value from the dataset in the U output when duplicate values are found

Answer 3

False

Question 4

True or False? “1 in N chance to include each row” means that the resulting number of records will be equivalent to 1/N of the records in the original dataset.

Answer 4

False - “1 in N chance to include each row” does not represent an exact fraction of the incoming records. To include 1/N of all rows, select “1 of every N rows”.

Question 5

All of the following sampling methods are available in the Sample tool except: Last N, Every row, 1 of every N rows, First N, First N%, or Skip 1st N

Answer 5

Every row

Question 6

True or False? Columns classified as a numeric data type may be joined to columns classified as any data type when joining by specific fields

Answer 6

False

Question 7

This associates a website’s URL with the IP address associated with the site so that the request is directed to the correct server

Answer 7

Domain name system

Question 8

When people interact with cloud products, they are typically working with Platform as a Service products. True or False?

Answer 8

False

Question 9

What does elasticity refer to in a cloud environment?

Answer 9

???

Question 10

What is subnetting used for?

Answer 10

Used as another element of security in the cloud designed to reduce the chance of unauthorized access

Question 11

In addition to a password, what are some common secondary methods of authentication when using MFA?

Answer 11

Codes