Microsoft Certified: Azure Data Fundamentals

0/9 checked

Q_01 domain/d1 · medium single discuss →

A data engineer is designing a Stream Analytics query that must ensure a strongly typed output to a SQL database. They want to protect the query from type mismatches, but they also want to avoid dropping any rows because of casting errors, keeping the original value available in another column. Which casting function should they use?

A CAST, because it enforces the type on the column
B TRY_CAST, because errors become NULL and the row is not dropped
C CREATE TABLE, because it defines a single explicit schema
D GetType, because it returns the type of the column

Q_02 domain/d1 · medium single discuss →

A Stream Analytics job reads integer values from an input source. Some incoming values exceed the range that the bigint type can represent. What will happen to the job, and what is a recommended workaround?

A The job will silently truncate the value; no action is needed
B The job fails to deserialize the events with an InputDeserializationError; pre-process the data and convert the large integers to string
C The value is automatically converted to float with no error
D The job converts the value to a bit and continues processing