Question 1

Which of the following tasks are necessary to implement data replication?Note: There are 3 correct answers to this question.

AEnable the linked database feature

BCreate a remote subscription

CCreate a target table

DDefine a flowgraph

ECreate a virtual table

Answer : B, C, E

Question 2

What are the characteristics of a SHARED replica table? Note: There are 3 correct answers to this question.

AThe consuming application always references the virtual table

BThe replica table always stores real-time data

CYou can choose your own replica table name

DYou can toggle queries routing between remote table data and replica table data

EYou do not need to create the physical replica table manually

Answer : B, D, E

Question 3

In a flowgraph, which node do you use to select only the required columns from a data source and to filter specific rows?

AProjection

BAggregate

CCase

DPivot

Answer : B

Question 4

What is the purpose of a remote subscription?

ATo establish a connection to the replication service

BTo be notified when remote data has changed

CTo update data in a local table based on changes made to a remote table

DTo assign a virtual table to a remote source

Answer : C

Question 5

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.

Which of the following could be a valid reason?

AYou did not define at least one input parameter.

BYou did not define a valid table type.

CYour table function includes a DELETE statement.

DYour table function refers to a scalar function.