{“questions”:{“6110n”:{“id”:”6110n”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”_______ is the process of transforming and mapping raw data into a useful format for analysis?”,”desc”:””,”hint”:””,”answers”:{“u2shb”:{“id”:”u2shb”,”image”:””,”imageId”:””,”title”:”Ingestion”},”adebt”:{“id”:”adebt”,”image”:””,”imageId”:””,”title”:”Deduplication”},”u5qjq”:{“id”:”u5qjq”,”image”:””,”imageId”:””,”title”:”Wrangling”,”isCorrect”:”1″},”amoj6″:{“id”:”amoj6″,”image”:””,”imageId”:””,”title”:”Visualisation”}}},”rtn6n”:{“id”:”rtn6n”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select the TRUE statements regarding data ingestion”,”desc”:””,”hint”:””,”answers”:{“i9mq8”:{“id”:”i9mq8″,”image”:””,”imageId”:””,”title”:”Data can arrive as a continuous stream or in batches”,”isCorrect”:”1″},”egeud”:{“id”:”egeud”,”image”:””,”imageId”:””,”title”:”Data capture and storage are the primary purposes of the ingestions process”,”isCorrect”:”1″},”3laur”:{“id”:”3laur”,”image”:””,”imageId”:””,”title”:”Complex calculations should be run at the ingestion stage for optimal performance”},”p5kdv”:{“id”:”p5kdv”,”image”:””,”imageId”:””,”title”:”Data ingestion provides meaningful insights into the data captured”}}},”de1kx”:{“id”:”de1kx”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”SELECT the valid approaches to data processing”,”desc”:”https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-concepts-of-data-analytics\/2-describe-data-ingestion-process “,”hint”:””,”answers”:{“v2rti”:{“id”:”v2rti”,”image”:””,”imageId”:””,”title”:”ETL”,”isCorrect”:”1″},”6flci”:{“id”:”6flci”,”image”:””,”imageId”:””,”title”:”LET”},”np5ez”:{“id”:”np5ez”,”image”:””,”imageId”:””,”title”:”ELT”,”isCorrect”:”1″},”dhyzn”:{“id”:”dhyzn”,”image”:””,”imageId”:””,”title”:”TLE”}}},”v953p”:{“id”:”v953p”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which data processing approach is best suited where the data has privacy concerns?”,”desc”:”Sensitive data can be discarded or masked before loading into a databases.”,”hint”:””,”answers”:{“ni31w”:{“id”:”ni31w”,”image”:””,”imageId”:””,”title”:”ETL”,”isCorrect”:”1″},”jdmb1″:{“id”:”jdmb1″,”image”:””,”imageId”:””,”title”:”LET”},”zfelh”:{“id”:”zfelh”,”image”:””,”imageId”:””,”title”:”ELT”},”hsdht”:{“id”:”hsdht”,”image”:””,”imageId”:””,”title”:”TLE”}}},”z4sd2″:{“id”:”z4sd2″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which data processing approach is best suited for large volumes of data?”,”desc”:””,”hint”:””,”answers”:{“p8pen”:{“id”:”p8pen”,”image”:””,”imageId”:””,”title”:”ETL”},”adiib”:{“id”:”adiib”,”image”:””,”imageId”:””,”title”:”LET”},”e2cka”:{“id”:”e2cka”,”image”:””,”imageId”:””,”title”:”ELT”,”isCorrect”:”1″},”7ak85″:{“id”:”7ak85″,”image”:””,”imageId”:””,”title”:”TLE”}}},”zy4k3″:{“id”:”zy4k3″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which of these options is a cloud-based data integration service?”,”desc”:”SSIS is integration software but is not cloud based.”,”hint”:””,”answers”:{“m019z”:{“id”:”m019z”,”image”:””,”imageId”:””,”title”:”SSIS”},”8p5bt”:{“id”:”8p5bt”,”image”:””,”imageId”:””,”title”:”Azure SQL Database”},”ms2x3″:{“id”:”ms2x3″,”image”:””,”imageId”:””,”title”:”Synapse Analytics”},”rfoae”:{“id”:”rfoae”,”image”:””,”imageId”:””,”title”:”Azure Data Factory”,”isCorrect”:”1″}}},”igrh9″:{“id”:”igrh9″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Describe the purpose of reporting.”,”desc”:””,”hint”:””,”answers”:{“janbu”:{“id”:”janbu”,”image”:””,”imageId”:””,”title”:”Creating a graphical representation of data to help understand trends and patterns”},”1b2iv”:{“id”:”1b2iv”,”image”:””,”imageId”:””,”title”:”Organising data into easily digested informational summaries”,”isCorrect”:”1″},”jcoe5″:{“id”:”jcoe5″,”image”:””,”imageId”:””,”title”:”Explaining why events happened and what you can do about them”},”46whq”:{“id”:”46whq”,”image”:””,”imageId”:””,”title”:”To support better decision making”}}},”eovx9″:{“id”:”eovx9″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Describe the purpose of business intelligence”,”desc”:””,”hint”:””,”answers”:{“hc0rs”:{“id”:”hc0rs”,”image”:””,”imageId”:””,”title”:”Creating a graphical representation of data to help understand trends and patterns”},”onfru”:{“id”:”onfru”,”image”:””,”imageId”:””,”title”:”Organising data into easily digested informational summaries”},”38v0o”:{“id”:”38v0o”,”image”:””,”imageId”:””,”title”:”Explaining why events happened and what you can do about them”},”w8tr7″:{“id”:”w8tr7″,”image”:””,”imageId”:””,”title”:”To support better decision making”,”isCorrect”:”1″}}},”hd4q4″:{“id”:”hd4q4″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Describe the purpose of data visualisation”,”desc”:””,”hint”:””,”answers”:{“3zt58”:{“id”:”3zt58″,”image”:””,”imageId”:””,”title”:”Creating a graphical representation of data to help understand trends and patterns”,”isCorrect”:”1″},”5f2sg”:{“id”:”5f2sg”,”image”:””,”imageId”:””,”title”:”Organising data into easily digested informational summaries”},”kvuye”:{“id”:”kvuye”,”image”:””,”imageId”:””,”title”:”Explaining why events happened and what you can do about them”},”c4gx0″:{“id”:”c4gx0″,”image”:””,”imageId”:””,”title”:”To support better decision making”}}},”qmpqs”:{“id”:”qmpqs”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all valid data visualisation options”,”desc”:””,”hint”:””,”answers”:{“pj0sp”:{“id”:”pj0sp”,”image”:””,”imageId”:””,”title”:”Bar and column chart”,”isCorrect”:”1″},”jq2cx”:{“id”:”jq2cx”,”image”:””,”imageId”:””,”title”:”Tabular chart”},”d5t7w”:{“id”:”d5t7w”,”image”:””,”imageId”:””,”title”:”Line chart”,”isCorrect”:”1″},”nfsw5″:{“id”:”nfsw5″,”image”:””,”imageId”:””,”title”:”Matrix”,”isCorrect”:”1″},”dqigf”:{“id”:”dqigf”,”image”:””,”imageId”:””,”title”:”JSON”}}},”pz2xp”:{“id”:”pz2xp”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all valid data visualisation options”,”desc”:””,”hint”:””,”answers”:{“zbozz”:{“id”:”zbozz”,”image”:””,”imageId”:””,”title”:”Key influencers”,”isCorrect”:”1″},”jvtz4″:{“id”:”jvtz4″,”image”:””,”imageId”:””,”title”:”Weekly digest”},”15b7v”:{“id”:”15b7v”,”image”:””,”imageId”:””,”title”:”Treemap”,”isCorrect”:”1″},”gjp9w”:{“id”:”gjp9w”,”image”:””,”imageId”:””,”title”:”Filled Map “,”isCorrect”:”1″},”ogzha”:{“id”:”ogzha”,”image”:””,”imageId”:””,”title”:”Scatter”,”isCorrect”:”1″}}},”50tdo”:{“id”:”50tdo”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all valid data analytics categories”,”desc”:””,”hint”:””,”answers”:{“85jhk”:{“id”:”85jhk”,”image”:””,”imageId”:””,”title”:”Descriptive”,”isCorrect”:”1″},”ymo6a”:{“id”:”ymo6a”,”image”:””,”imageId”:””,”title”:”Real time”},”fq99v”:{“id”:”fq99v”,”image”:””,”imageId”:””,”title”:”Diagnostic”,”isCorrect”:”1″},”t0t5j”:{“id”:”t0t5j”,”image”:””,”imageId”:””,”title”:”Databricks”},”y655e”:{“id”:”y655e”,”image”:””,”imageId”:””,”title”:”Predictive”,”isCorrect”:”1″},”qjgak”:{“id”:”qjgak”,”image”:””,”imageId”:””,”title”:”Prescriptive”,”isCorrect”:”1″},”f35kv”:{“id”:”f35kv”,”image”:””,”imageId”:””,”title”:”Machine Learning”},”jx6el”:{“id”:”jx6el”,”image”:””,”imageId”:””,”title”:”Cognitive”,”isCorrect”:”1″},”e3tbg”:{“id”:”e3tbg”,”image”:””,”imageId”:””,”title”:”Inferred”}}},”3s0k3″:{“id”:”3s0k3″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which statement is true regarding diagnostic analytics?”,”desc”:””,”hint”:””,”answers”:{“b6ze2”:{“id”:”b6ze2″,”image”:””,”imageId”:””,”title”:”Helps answer questions about what has happened”},”jhuhm”:{“id”:”jhuhm”,”image”:””,”imageId”:””,”title”:”Helps answer questions about why something has happened”,”isCorrect”:”1″},”jkkjr”:{“id”:”jkkjr”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what will happen in the future”},”woavf”:{“id”:”woavf”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what actions need to be taken in order to achieve a goal or target”},”z6m95″:{“id”:”z6m95″,”image”:””,”imageId”:””,”title”:”Helps you learn what might happen if circumstances change”}}},”8qf52″:{“id”:”8qf52″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which statement is true regarding predictive analytics?”,”desc”:””,”hint”:””,”answers”:{“cjhar”:{“id”:”cjhar”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what has happened”},”fs37m”:{“id”:”fs37m”,”image”:””,”imageId”:””,”title”:”Helps answer questions about why something has happened”},”0x7vf”:{“id”:”0x7vf”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what will happen in the future”,”isCorrect”:”1″},”6bytk”:{“id”:”6bytk”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what actions need to be taken in order to achieve a goal or target”},”mhywv”:{“id”:”mhywv”,”image”:””,”imageId”:””,”title”:”Helps you learn what might happen if circumstances change”}}},”htwdz”:{“id”:”htwdz”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which statement is true regarding descriptive analytics?”,”desc”:””,”hint”:””,”answers”:{“azekm”:{“id”:”azekm”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what has happened”,”isCorrect”:”1″},”6ujuz”:{“id”:”6ujuz”,”image”:””,”imageId”:””,”title”:”Helps answer questions about why something has happened”},”20mrd”:{“id”:”20mrd”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what will happen in the future”},”2zfc1″:{“id”:”2zfc1″,”image”:””,”imageId”:””,”title”:”Helps answer questions about what actions need to be taken in order to achieve a goal or target”},”m06vk”:{“id”:”m06vk”,”image”:””,”imageId”:””,”title”:”Helps you learn what might happen if circumstances change”}}},”3gb0k”:{“id”:”3gb0k”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which statement is true regarding cognitive analytics?”,”desc”:””,”hint”:””,”answers”:{“0jd0y”:{“id”:”0jd0y”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what has happened”},”7jop0″:{“id”:”7jop0″,”image”:””,”imageId”:””,”title”:”Helps answer questions about why something has happened”},”3wv2v”:{“id”:”3wv2v”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what will happen in the future”},”qyqbz”:{“id”:”qyqbz”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what actions need to be taken in order to achieve a goal or target”},”3sj2x”:{“id”:”3sj2x”,”image”:””,”imageId”:””,”title”:”Helps you learn what might happen if circumstances change”,”isCorrect”:”1″}}},”mffx9″:{“id”:”mffx9″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which statement is true regarding prescriptive analytics?”,”desc”:””,”hint”:””,”answers”:{“bnnck”:{“id”:”bnnck”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what has happened”},”h1lpx”:{“id”:”h1lpx”,”image”:””,”imageId”:””,”title”:”Helps answer questions about why something has happened”},”rds40″:{“id”:”rds40″,”image”:””,”imageId”:””,”title”:”Helps answer questions about what will happen in the future”},”4ti4z”:{“id”:”4ti4z”,”image”:””,”imageId”:””,”title”:”Helps answer questions about what actions need to be taken in order to achieve a goal or target”,”isCorrect”:”1″},”42la4″:{“id”:”42la4″,”image”:””,”imageId”:””,”title”:”Helps you learn what might happen if circumstances change”}}}},”results”:{“2qh5u”:{“id”:”2qh5u”,”title”:”DP-900 Practice questions – Explore concepts of data analytics”,”image”:””,”imageId”:””,”min”:”0″,”max”:”17″,”desc”:””,”redirect_url”:””}}}

{“questions”:{“dt2pe”:{“id”:”dt2pe”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which of these data types would be most suitable for non-relational database?”,”desc”:””,”hint”:””,”answers”:{“0i235”:{“id”:”0i235″,”image”:””,”imageId”:””,”title”:”Log data”,”isCorrect”:”1″},”k93nl”:{“id”:”k93nl”,”image”:””,”imageId”:””,”title”:”Data which follows a set structure”},”xh6ix”:{“id”:”xh6ix”,”image”:””,”imageId”:””,”title”:”Data with a flexible structure”,”isCorrect”:”1″},”kn9gq”:{“id”:”kn9gq”,”image”:””,”imageId”:””,”title”:”Sales and order data for an e-commerce store”}}},”y4jym”:{“id”:”y4jym”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Each entity in a non-relational database should have a unique ______”,”desc”:””,”hint”:””,”answers”:{“7tijw”:{“id”:”7tijw”,”image”:””,”imageId”:””,”title”:”Foreign Key”},”ed996″:{“id”:”ed996″,”image”:””,”imageId”:””,”title”:”Composite Key”},”sl334″:{“id”:”sl334″,”image”:””,”imageId”:””,”title”:”Key Value”,”isCorrect”:”1″},”ea1ym”:{“id”:”ea1ym”,”image”:””,”imageId”:””,”title”:”JSON beautifier”}}},”tuxrk”:{“id”:”tuxrk”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which Azure based non-relational DBMS supports indexing, even when the structure of the indexed data varies from record to record?”,”desc”:”https:\/\/docs.microsoft.com\/en-us\/azure\/cosmos-db\/index-overview”,”hint”:””,”answers”:{“m4fgw”:{“id”:”m4fgw”,”image”:””,”imageId”:””,”title”:”PostGreSQL”},”2oieu”:{“id”:”2oieu”,”image”:””,”imageId”:””,”title”:”Azure Database for PostgreSQL”},”zvy1n”:{“id”:”zvy1n”,”image”:””,”imageId”:””,”title”:”Azure Database for Snowflake”},”al4ca”:{“id”:”al4ca”,”image”:””,”imageId”:””,”title”:”Azure Cosmos DB”,”isCorrect”:”1″}}},”h4a04″:{“id”:”h4a04″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select the suitable use cases for non-relational databases”,”desc”:””,”hint”:””,”answers”:{“enp6m”:{“id”:”enp6m”,”image”:””,”imageId”:””,”title”:”IoT and Telematics”,”isCorrect”:”1″},”snlom”:{“id”:”snlom”,”image”:””,”imageId”:””,”title”:”Gaming”,”isCorrect”:”1″},”5nq4f”:{“id”:”5nq4f”,”image”:””,”imageId”:””,”title”:”Online Banking”},”ppii9″:{“id”:”ppii9″,”image”:””,”imageId”:””,”title”:”Web and mobile applications”,”isCorrect”:”1″}}},”9jcd6″:{“id”:”9jcd6″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which option is best when data needs to be ingested quickly?”,”desc”:””,”hint”:””,”answers”:{“8hbtv”:{“id”:”8hbtv”,”image”:””,”imageId”:””,”title”:”Non-Relational database”,”isCorrect”:”1″},”z7g4w”:{“id”:”z7g4w”,”image”:””,”imageId”:””,”title”:”Relational database”}}},”yegq6″:{“id”:”yegq6″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which if the following data types use a columnar format?”,”desc”:””,”hint”:””,”answers”:{“sh8ob”:{“id”:”sh8ob”,”image”:””,”imageId”:””,”title”:”JSON”},”ddp8e”:{“id”:”ddp8e”,”image”:””,”imageId”:””,”title”:”Avro”},”3sgzn”:{“id”:”3sgzn”,”image”:””,”imageId”:””,”title”:”ORC”,”isCorrect”:”1″},”6gruw”:{“id”:”6gruw”,”image”:””,”imageId”:””,”title”:”Parquet”,”isCorrect”:”1″}}},”3x4jq”:{“id”:”3x4jq”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which of the following would be described as unstructured data?”,”desc”:”JSON is described as semi-structured data”,”hint”:””,”answers”:{“2xspl”:{“id”:”2xspl”,”image”:””,”imageId”:””,”title”:”Audio files”,”isCorrect”:”1″},”jotju”:{“id”:”jotju”,”image”:””,”imageId”:””,”title”:”GIFs”,”isCorrect”:”1″},”5ce1u”:{“id”:”5ce1u”,”image”:””,”imageId”:””,”title”:”JSON “},”tfr10”:{“id”:”tfr10″,”image”:””,”imageId”:””,”title”:”Video files”,”isCorrect”:”1″}}},”x1cj6″:{“id”:”x1cj6″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”NoSQL databases fall into which general categories?”,”desc”:”MySQL is a relational database. Parquet is a compressed columnar data format.”,”hint”:””,”answers”:{“s9k1q”:{“id”:”s9k1q”,”image”:””,”imageId”:””,”title”:”Key-Value stores”,”isCorrect”:”1″},”gz2sw”:{“id”:”gz2sw”,”image”:””,”imageId”:””,”title”:”Document databases”,”isCorrect”:”1″},”xyoua”:{“id”:”xyoua”,”image”:””,”imageId”:””,”title”:”MySQL databases”},”k94xh”:{“id”:”k94xh”,”image”:””,”imageId”:””,”title”:”Column family databases”,”isCorrect”:”1″},”q2ykf”:{“id”:”q2ykf”,”image”:””,”imageId”:””,”title”:”Parquet “},”mu2sb”:{“id”:”mu2sb”,”image”:””,”imageId”:””,”title”:”Graph databases”,”isCorrect”:”1″}}},”l5obk”:{“id”:”l5obk”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select the technology choices suitable for a key-value store in Azure?”,”desc”:”Blob storage is not suitable for key-values. Managed Instance is a SQL relational database service. RDS Aurora is in AWS, and is also a relational dbms.”,”hint”:””,”answers”:{“ofs28”:{“id”:”ofs28″,”image”:””,”imageId”:””,”title”:”Azure table storage”,”isCorrect”:”1″},”lhv0d”:{“id”:”lhv0d”,”image”:””,”imageId”:””,”title”:”Azure Cosmos DB”,”isCorrect”:”1″},”9jf04″:{“id”:”9jf04″,”image”:””,”imageId”:””,”title”:”Blob Storage”},”0qo10″:{“id”:”0qo10″,”image”:””,”imageId”:””,”title”:”Azure SQL Managed Instance”},”dvqf4″:{“id”:”dvqf4″,”image”:””,”imageId”:””,”title”:”RDS Aurora”}}},”slt99″:{“id”:”slt99″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select the TRUE statements regarding document store databases.”,”desc”:””,”hint”:””,”answers”:{“k61oe”:{“id”:”k61oe”,”image”:””,”imageId”:””,”title”:”Each document has a unique ID”,”isCorrect”:”1″},”gzymr”:{“id”:”gzymr”,”image”:””,”imageId”:””,”title”:”The fields in the documents are opaque to the database management system”},”6osp6″:{“id”:”6osp6″,”image”:””,”imageId”:””,”title”:”The fields in the documents are transparent to the database management system”,”isCorrect”:”1″},”qwx7d”:{“id”:”qwx7d”,”image”:””,”imageId”:””,”title”:”Data is often stored as JSON, but could be in other formats such as XML, YAML and BSON”,”isCorrect”:”1″},”6oaeq”:{“id”:”6oaeq”,”image”:””,”imageId”:””,”title”:”Typically, a document contains part of the data for an entity”}}},”09n1u”:{“id”:”09n1u”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select the TRUE statements regarding column family databases.”,”desc”:”Although Cassandra is a column family database, Azure database for Cassandra is not a valid service in Azure.”,”hint”:””,”answers”:{“5vbdu”:{“id”:”5vbdu”,”image”:””,”imageId”:””,”title”:”Rows and columns are used to organise data”,”isCorrect”:”1″},”qdw1k”:{“id”:”qdw1k”,”image”:””,”imageId”:””,”title”:”Logically related columns such as name and address are stored together in column families”,”isCorrect”:”1″},”2ae93″:{“id”:”2ae93″,”image”:””,”imageId”:””,”title”:”Azure database for Cassandra is a widely used column family database”},”12srt”:{“id”:”12srt”,”image”:””,”imageId”:””,”title”:”Azure Cosmos DB uses the Cassandra API to support column family data”,”isCorrect”:”1″}}},”152or”:{“id”:”152or”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select the TRUE statements regarding graph databases”,”desc”:””,”hint”:””,”answers”:{“dhe0g”:{“id”:”dhe0g”,”image”:””,”imageId”:””,”title”:”Graph databases are designed to visualize complex logarithmic data (log scale graphs)”},”bwjze”:{“id”:”bwjze”,”image”:””,”imageId”:””,”title”:”Graph databases focus on relationships between entities”,”isCorrect”:”1″},”ax98q”:{“id”:”ax98q”,”image”:””,”imageId”:””,”title”:”Azure Cosmos DB uses the Gremlin API to support graph databases”,”isCorrect”:”1″},”cctyo”:{“id”:”cctyo”,”image”:””,”imageId”:””,”title”:”Graph databases are queried using T-SQL”},”n5mh2″:{“id”:”n5mh2″,”image”:””,”imageId”:””,”title”:”Nodes are instances of entities”,”isCorrect”:”1″},”1ujde”:{“id”:”1ujde”,”image”:””,”imageId”:””,”title”:”Edges are relationships between nodes”,”isCorrect”:”1″}}}},”results”:{“nqlnu”:{“id”:”nqlnu”,”title”:”DP-900 practice questions – Explore concepts of non-relational data”,”image”:””,”imageId”:””,”min”:”0″,”max”:”12″,”desc”:””,”redirect_url”:””}}}

{“questions”:{“0mmvn”:{“id”:”0mmvn”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”In a relational database, entities are modelled as:”,”desc”:””,”hint”:””,”answers”:{“vucxc”:{“id”:”vucxc”,”image”:””,”imageId”:””,”title”:”Columns”},”ghwe2″:{“id”:”ghwe2″,”image”:””,”imageId”:””,”title”:”Tables”,”isCorrect”:”1″},”g6vqt”:{“id”:”g6vqt”,”image”:””,”imageId”:””,”title”:”Views”},”mjcxk”:{“id”:”mjcxk”,”image”:””,”imageId”:””,”title”:”Primary Keys”}}},”ojc7o”:{“id”:”ojc7o”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”True or false? Rows in a table can have a flexible number of columns.”,”desc”:”Although nullable columns can be empty, each row has a fixed number of columns.”,”hint”:””,”answers”:{“rqir7”:{“id”:”rqir7″,”image”:””,”imageId”:””,”title”:”True”},”6nmqh”:{“id”:”6nmqh”,”image”:””,”imageId”:””,”title”:”False”,”isCorrect”:”1″}}},”morxv”:{“id”:”morxv”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”True or false? Primary keys uniquely identify each row in a table.”,”desc”:””,”hint”:”Primary key values must be unique on each row but can be made up of multiple columns. (These are known as composite primary keys).”,”answers”:{“9gmj9”:{“id”:”9gmj9″,”image”:””,”imageId”:””,”title”:”True”,”isCorrect”:”1″},”bi0fr”:{“id”:”bi0fr”,”image”:””,”imageId”:””,”title”:”False”}}},”b4mi7″:{“id”:”b4mi7″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”For each value in a foreign key column, there must be a row with the same value in the corresponding ______ column in the related table.”,”desc”:””,”hint”:””,”answers”:{“k36aj”:{“id”:”k36aj”,”image”:””,”imageId”:””,”title”:”Foreign Key”},”ejcv4″:{“id”:”ejcv4″,”image”:””,”imageId”:””,”title”:”3rd normal form”},”dr38l”:{“id”:”dr38l”,”image”:””,”imageId”:””,”title”:”Primary Key”,”isCorrect”:”1″},”oq53w”:{“id”:”oq53w”,”image”:””,”imageId”:””,”title”:”Identity”}}},”vxuww”:{“id”:”vxuww”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select the use cases for which a relational database is the most suitable option.”,”desc”:”E-commerce and banking are suitable for relational databases. Graph databases are suitable for social networks and blob storage is suitable for digital media collections.”,”hint”:””,”answers”:{“x6ovi”:{“id”:”x6ovi”,”image”:””,”imageId”:””,”title”:”E-Commerce (Online shopping)”,”isCorrect”:”1″},”78p6h”:{“id”:”78p6h”,”image”:””,”imageId”:””,”title”:”Social networks”},”xd91v”:{“id”:”xd91v”,”image”:””,”imageId”:””,”title”:”Online banking”,”isCorrect”:”1″},”yr3oq”:{“id”:”yr3oq”,”image”:””,”imageId”:””,”title”:”Digital media collections”}}},”4xqlk”:{“id”:”4xqlk”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Please select a benefit of indexes on relational tables.”,”desc”:””,”hint”:””,”answers”:{“l2j74”:{“id”:”l2j74″,”image”:””,”imageId”:””,”title”:”Helps you search efficiently for data”,”isCorrect”:”1″},”r4jwr”:{“id”:”r4jwr”,”image”:””,”imageId”:””,”title”:”Reduces storage space”},”ejlzg”:{“id”:”ejlzg”,”image”:””,”imageId”:””,”title”:”Speeds up insert, update, and delete operations”},”y0tcc”:{“id”:”y0tcc”,”image”:””,”imageId”:””,”title”:”Indexes are virtual tables”}}},”r4q7b”:{“id”:”r4q7b”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which phrase best describes a view?”,”desc”:””,”hint”:””,”answers”:{“vggwu”:{“id”:”vggwu”,”image”:””,”imageId”:””,”title”:”8kb of data”},”j6efu”:{“id”:”j6efu”,”image”:””,”imageId”:””,”title”:”A virtual table based on the results of a query”,”isCorrect”:”1″},”uu8f9″:{“id”:”uu8f9″,”image”:””,”imageId”:””,”title”:”A data compression technique”},”jq020″:{“id”:”jq020″,”image”:””,”imageId”:””,”title”:”A subset of a data table”}}},”i5h73″:{“id”:”i5h73″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Can views can be joined to SQL tables and other views.”,”desc”:””,”hint”:””,”answers”:{“3kqwe”:{“id”:”3kqwe”,”image”:””,”imageId”:””,”title”:”Tables only”},”3fpl4″:{“id”:”3fpl4″,”image”:””,”imageId”:””,”title”:”Views only”},”67hup”:{“id”:”67hup”,”image”:””,”imageId”:””,”title”:”Tables and views”,”isCorrect”:”1″},”tqynb”:{“id”:”tqynb”,”image”:””,”imageId”:””,”title”:”Can’t join to either”}}},”hqgod”:{“id”:”hqgod”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”If you need full control of your SQL Server in the Azure cloud, which option should you choose?”,”desc”:”Although EC2 would give you full control of your SQL Server, this is a service from AWS, not Azure. Any PaaS solutions have limited features so don’t allow full control.”,”hint”:””,”answers”:{“u3mzh”:{“id”:”u3mzh”,”image”:””,”imageId”:””,”title”:”Azure SQL Database (PaaS)”},”0ormi”:{“id”:”0ormi”,”image”:””,”imageId”:””,”title”:”SQL Managed Instance (PaaS)”},”duyyc”:{“id”:”duyyc”,”image”:””,”imageId”:””,”title”:”SQL Server on VMs (IAAS)”,”isCorrect”:”1″},”r9hxf”:{“id”:”r9hxf”,”image”:””,”imageId”:””,”title”:”Elastic Cloud Compute VMs (EC2)”}}},”0ygwr”:{“id”:”0ygwr”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all the benefits of using a PaaS solution for your relational database.”,”desc”:””,”hint”:””,”answers”:{“50xp4”:{“id”:”50xp4″,”image”:””,”imageId”:””,”title”:”Automatic backups”,”isCorrect”:”1″},”k85mx”:{“id”:”k85mx”,”image”:””,”imageId”:””,”title”:”Automatic patching”,”isCorrect”:”1″},”wx92t”:{“id”:”wx92t”,”image”:””,”imageId”:””,”title”:”Install and managed database software yourself”},”ucelk”:{“id”:”ucelk”,”image”:””,”imageId”:””,”title”:”Quick and easy scaling”,”isCorrect”:”1″}}},”dzzwg”:{“id”:”dzzwg”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Besides Azure SQL database, which other popular DBMSs have a PaaS solution in Azure?”,”desc”:””,”hint”:””,”answers”:{“dlurl”:{“id”:”dlurl”,”image”:””,”imageId”:””,”title”:”Azure Database for PostgreSQL”,”isCorrect”:”1″},”yu810″:{“id”:”yu810″,”image”:””,”imageId”:””,”title”:”Azure Database for Oracle”},”e8aqv”:{“id”:”e8aqv”,”image”:””,”imageId”:””,”title”:”Azure Database for MySQL”,”isCorrect”:”1″},”tcnur”:{“id”:”tcnur”,”image”:””,”imageId”:””,”title”:”Azure Database for MariaDB”,”isCorrect”:”1″},”oflqy”:{“id”:”oflqy”,”image”:””,”imageId”:””,”title”:”Azure Database for Snowflake”},”rfg46″:{“id”:”rfg46″,”image”:””,”imageId”:””,”title”:”Azure Database for Access”}}}},”results”:{“lf22z”:{“id”:”lf22z”,”title”:””,”image”:””,”imageId”:””,”min”:”0″,”max”:”11″,”desc”:””,”redirect_url”:””}}}

{“questions”:{“lpwiu”:{“id”:”lpwiu”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which job role manages databases, user permissions, backups and restores as well as optimising performance and availability?”,”desc”:””,”hint”:””,”answers”:{“mnhwf”:{“id”:”mnhwf”,”image”:””,”imageId”:””,”title”:”Database Administrator”,”isCorrect”:”1″},”2vagn”:{“id”:”2vagn”,”image”:””,”imageId”:””,”title”:”BI Developer”},”sfl88″:{“id”:”sfl88″,”image”:””,”imageId”:””,”title”:”Data Analyst”},”5hgc0″:{“id”:”5hgc0″,”image”:””,”imageId”:””,”title”:”Data Engineer”}}},”12chw”:{“id”:”12chw”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which job role designs and implements data ingestion pipelines, data transformation and cleansing tasks, and data stores for analytical workloads?”,”desc”:””,”hint”:””,”answers”:{“6rx5f”:{“id”:”6rx5f”,”image”:””,”imageId”:””,”title”:”BI Developer”},”pn4yx”:{“id”:”pn4yx”,”image”:””,”imageId”:””,”title”:”Database Administrator”},”g0n5i”:{“id”:”g0n5i”,”image”:””,”imageId”:””,”title”:”Data Engineer”,”isCorrect”:”1″},”zf1w6″:{“id”:”zf1w6″,”image”:””,”imageId”:””,”title”:”Data Analyst”}}},”bcxor”:{“id”:”bcxor”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which job role is responsible for designing and building scalable models and designing advanced analytics capabilities via reports and visualisations?”,”desc”:”Although BI developers do write reports and visualisations, they are not specifically by MS Learn. The answer you are looking for is data analyst.”,”hint”:””,”answers”:{“cfkx5”:{“id”:”cfkx5″,”image”:””,”imageId”:””,”title”:”Database Engineer”},”zxkv5″:{“id”:”zxkv5″,”image”:””,”imageId”:””,”title”:”Data Administrator”},”hfqq1″:{“id”:”hfqq1″,”image”:””,”imageId”:””,”title”:”Data Analyst”,”isCorrect”:”1″},”6qqb3″:{“id”:”6qqb3″,”image”:””,”imageId”:””,”title”:”BI Developer”}}},”fio3t”:{“id”:”fio3t”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all valid tasks undertaken by a Database Administrator?”,”desc”:”In some smaller companies, DBAs may be expected to do some non standard tasks including writing reports and designing ETL packages but these are usually done by data analysts and data engineers respectively.”,”hint”:””,”answers”:{“vqk4u”:{“id”:”vqk4u”,”image”:””,”imageId”:””,”title”:”SQL Server Backups”,”isCorrect”:”1″},”w40vr”:{“id”:”w40vr”,”image”:””,”imageId”:””,”title”:”Report writing”},”rbt5w”:{“id”:”rbt5w”,”image”:””,”imageId”:””,”title”:”Designing high availability solutions”,”isCorrect”:”1″},”ol53s”:{“id”:”ol53s”,”image”:””,”imageId”:””,”title”:”Designing ETL packages”}}},”awny3″:{“id”:”awny3″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which client tool is primarily used by SQL Server DBAs?”,”desc”:”Although 3rd party products such as Toad for SQL Server are available, the majority of SQL DBAs use SSMS. Cross platform tools like Azure Data Studio are also gaining prominence. pgAdmin is for PostgreSQL. MySQL Workbench is for MySQL.”,”hint”:””,”answers”:{“ugbui”:{“id”:”ugbui”,”image”:””,”imageId”:””,”title”:”MySQL Workbench”},”qqjjd”:{“id”:”qqjjd”,”image”:””,”imageId”:””,”title”:”pgAdmin”},”r4t35″:{“id”:”r4t35″,”image”:””,”imageId”:””,”title”:”SQL Server Management Studio (SSMS)”,”isCorrect”:”1″},”a0qfc”:{“id”:”a0qfc”,”image”:””,”imageId”:””,”title”:”Toad for SQL Server”}}},”tk710″:{“id”:”tk710″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select an example of a cross platform database administration tool?”,”desc”:”ADS currently provides connections to on-premises SQL Server databases, Azure SQL Database, PostgreSQL, Azure SQL Data Warehouse, and SQL Server Big Data Clusters, amongst others.”,”hint”:””,”answers”:{“icbs3”:{“id”:”icbs3″,”image”:””,”imageId”:””,”title”:”SQL Server Management Studio (SSMS)”},”cnfq1″:{“id”:”cnfq1″,”image”:””,”imageId”:””,”title”:”Azure Data Studio”,”isCorrect”:”1″},”duniy”:{“id”:”duniy”,”image”:””,”imageId”:””,”title”:”phpMyAdmin”},”a6l82″:{“id”:”a6l82″,”image”:””,”imageId”:””,”title”:”Oracle Instant Client for Microsoft Windows (X64)”}}},”9juac”:{“id”:”9juac”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”What does the S.Q.L. stand for in Transact-SQL?”,”desc”:”https:\/\/en.wikipedia.org\/wiki\/Transact-SQL”,”hint”:””,”answers”:{“5wbul”:{“id”:”5wbul”,”image”:””,”imageId”:””,”title”:”Specific Query Language “},”31fes”:{“id”:”31fes”,”image”:””,”imageId”:””,”title”:”Set-based Query Language”},”090uv”:{“id”:”090uv”,”image”:””,”imageId”:””,”title”:”Standard Query Language”},”z5ls3″:{“id”:”z5ls3″,”image”:””,”imageId”:””,”title”:”Structured Query Language”,”isCorrect”:”1″}}},”39s0p”:{“id”:”39s0p”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all valid tasks undertaken by a data engineer?”,”desc”:”https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/4-review-tasks-tools-for-data-engineering”,”hint”:”https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/4-review-tasks-tools-for-data-engineering”,”answers”:{“1kpog”:{“id”:”1kpog”,”image”:””,”imageId”:””,”title”:”Developing, constructing, testing, and maintaining databases and data structures”,”isCorrect”:”1″},”tkbt5″:{“id”:”tkbt5″,”image”:””,”imageId”:””,”title”:”Developing processes for creating and retrieving information from data sets”,”isCorrect”:”1″},”wza8f”:{“id”:”wza8f”,”image”:””,”imageId”:””,”title”:”Deploying sophisticated analytics programs, machine learning, and statistical methods”,”isCorrect”:”1″},”yvowd”:{“id”:”yvowd”,”image”:””,”imageId”:””,”title”:”Using PowerShell to manage SQL Server Backups”},”zammq”:{“id”:”zammq”,”image”:””,”imageId”:””,”title”:”Using programming languages and tools to examine the data”,”isCorrect”:”1″},”p0ifp”:{“id”:”p0ifp”,”image”:””,”imageId”:””,”title”:”Performance tuning T-SQL queries using Java”}}},”4gsm0″:{“id”:”4gsm0″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select only the true statements below.”,”desc”:””,”hint”:””,”answers”:{“xmql7”:{“id”:”xmql7″,”image”:””,”imageId”:””,”title”:”Data Engineers may use languages such as HiveQL, R, or Python”,”isCorrect”:”1″},”gq4j8″:{“id”:”gq4j8″,”image”:””,”imageId”:””,”title”:”Azure data engineers may use Databricks for developing data intensive applications”,”isCorrect”:”1″},”0rcy4″:{“id”:”0rcy4″,”image”:””,”imageId”:””,”title”:”HDInsight is used in big data processing.”,”isCorrect”:”1″},”ri294″:{“id”:”ri294″,”image”:””,”imageId”:””,”title”:”Azure BigQuery is used in big data processing”}}},”ll1re”:{“id”:”ll1re”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which reporting tools might you expect a skilled data analyst to be comfortable with?”,”desc”:”SSIS is used for ETL so is the domain of the data engineer.”,”hint”:””,”answers”:{“iq0wr”:{“id”:”iq0wr”,”image”:””,”imageId”:””,”title”:”SSAS”,”isCorrect”:”1″},”2v8g6″:{“id”:”2v8g6″,”image”:””,”imageId”:””,”title”:”SSIS”},”p06rm”:{“id”:”p06rm”,”image”:””,”imageId”:””,”title”:”SSRS”,”isCorrect”:”1″},”4bnps”:{“id”:”4bnps”,”image”:””,”imageId”:””,”title”:”Power BI”,”isCorrect”:”1″}}},”dprxa”:{“id”:”dprxa”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all valid tasks undertaken by a SQL Analyst.”,”desc”:”https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-roles-responsibilities-world-of-data\/5-review-tasks-tools-for-data-visualization-reporting”,”hint”:””,”answers”:{“ggo47”:{“id”:”ggo47″,”image”:””,”imageId”:””,”title”:”Making large volumes of data easy to understand through the use of charts and graphs”,”isCorrect”:”1″},”33u3y”:{“id”:”33u3y”,”image”:””,”imageId”:””,”title”:”Finding hidden patterns in data”,”isCorrect”:”1″},”85gps”:{“id”:”85gps”,”image”:””,”imageId”:””,”title”:”Installing Power BI Gateway”},”s2s66″:{“id”:”s2s66″,”image”:””,”imageId”:””,”title”:”Combining data sets from multiple sources”,”isCorrect”:”1″}}}},”results”:{“669pt”:{“id”:”669pt”,”title”:”DP-900 practice questions – Explore roles and responsibilities in the world of data”,”image”:””,”imageId”:””,”min”:”1″,”max”:”11″,”desc”:””,”redirect_url”:””}}}

{“questions”:{“ocdmt”:{“id”:”ocdmt”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Structured data is typically represented in which format?”,”desc”:”Structured data is typically represented in a database table, with columns for field for each record. e.g. Name, DOB, CustomerID. Each record is a row within the table.”,”hint”:””,”answers”:{“e6zkg”:{“id”:”e6zkg”,”image”:””,”imageId”:””,”title”:”Rows and columns of a database table”,”isCorrect”:”1″},”v3yg1″:{“id”:”v3yg1″,”image”:””,”imageId”:””,”title”:”Azure Blob Storage”},”vxxrb”:{“id”:”vxxrb”,”image”:””,”imageId”:””,”title”:”JSON”},”bu8pu”:{“id”:”bu8pu”,”image”:””,”imageId”:””,”title”:”Customer records”}}},”xhwvp”:{“id”:”xhwvp”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”What is a good storage option for semi-structured data?”,”desc”:”As it has some structure, but fields can vary, JSON is good option for semi-structured data.”,”hint”:””,”answers”:{“y7qq7”:{“id”:”y7qq7″,”image”:””,”imageId”:””,”title”:”Rows and columns of a database table”},”4fnfo”:{“id”:”4fnfo”,”image”:””,”imageId”:””,”title”:”Azure Blob Storage”},”vzc1x”:{“id”:”vzc1x”,”image”:””,”imageId”:””,”title”:”JSON”,”isCorrect”:”1″},”iogex”:{“id”:”iogex”,”image”:””,”imageId”:””,”title”:”Customer records”}}},”z05by”:{“id”:”z05by”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which option would be a good use for graph databases?”,”desc”:””,”hint”:””,”answers”:{“9wo99”:{“id”:”9wo99″,”image”:””,”imageId”:””,”title”:”Online Transactional Processing (OLTP)”},”q4shg”:{“id”:”q4shg”,”image”:””,”imageId”:””,”title”:”Stocks and shares database”},”7m9oy”:{“id”:”7m9oy”,”image”:””,”imageId”:””,”title”:”Data visualisation”},”2bjo3″:{“id”:”2bjo3″,”image”:””,”imageId”:””,”title”:”Information about complex relationships”,”isCorrect”:”1″}}},”6jom1″:{“id”:”6jom1″,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Which option is best suited to storing multimedia data such as videos?”,”desc”:””,”hint”:””,”answers”:{“byppb”:{“id”:”byppb”,”image”:””,”imageId”:””,”title”:”Azure SQL DB”},”4px0j”:{“id”:”4px0j”,”image”:””,”imageId”:””,”title”:”Azure Synapse Analytics”},”vaoy9″:{“id”:”vaoy9″,”image”:””,”imageId”:””,”title”:”Azure blob storage”,”isCorrect”:”1″},”vqsdz”:{“id”:”vqsdz”,”image”:””,”imageId”:””,”title”:”Cosmos DB”}}},”m5h4v”:{“id”:”m5h4v”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select a benefit of normalizing data.”,”desc”:””,”hint”:””,”answers”:{“6rfc6”:{“id”:”6rfc6″,”image”:””,”imageId”:””,”title”:”The need to write complex queries makes SQL salaries higher than average for IT jobs”},”tvc8l”:{“id”:”tvc8l”,”image”:””,”imageId”:””,”title”:”Fast throughput for transactions”,”isCorrect”:”1″},”mia7u”:{“id”:”mia7u”,”image”:””,”imageId”:””,”title”:”Tables need to be joined to make sense”},”ssxyw”:{“id”:”ssxyw”,”image”:””,”imageId”:””,”title”:”It is ideal for storing documents”}}},”hremt”:{“id”:”hremt”,”mediaType”:”image”,”answerType”:”text”,”imageCredit”:””,”image”:””,”imageId”:””,”video”:””,”imagePlaceholder”:””,”imagePlaceholderId”:””,”title”:”Select all valid tasks for an Analytical Data Processing System?”,”desc”:”Data ingestion, transformation and visualisation are all valid steps. So too is data querying which is not listed.”,”hint”:””,”answers”:{“h6hf5”:{“id”:”h6hf5″,”image”:””,”imageId”:””,”title”:”Data Ingestion”,”isCorrect”:”1″},”piaa9″:{“id”:”piaa9″,”image”:””,”imageId”:””,”title”:”Data Destruction”},”cu2oc”:{“id”:”cu2oc”,”image”:””,”imageId”:””,”title”:”Data Transformation”,”isCorrect”:”1″},”1zy38″:{“id”:”1zy38″,”image”:””,”imageId”:””,”title”:”Data Assembly”},”9epge”:{“id”:”9epge”,”image”:””,”imageId”:””,”title”:”Data Visualisation”,”isCorrect”:”1″}}}},”results”:{“tcn7q”:{“id”:”tcn7q”,”title”:”Your Score”,”image”:””,”imageId”:””,”min”:”0″,”max”:”6″,”desc”:””,”redirect_url”:””}}}